Organisation issues

[J_Tamburrini]

Afternoon All,

Has anyone come across issues with users not being added into the division.

we run a LDAP sync to pull new users in and all other divisions seem to get populated so we know its working.

However our Planning & Development users are not being assigned the division and in some cases not even being added to the parent group of the division which is the Carter Jonas (this is the top of the org group)

 

secondly in the data base direct i tried to run a query to find all the divisions listed to see if out Planning & development appear.

no luck on this to show anything not even 25 lines

can anyone confirm i have written this correctly?

i got the info from the wiki https://wiki.hornbill.com/index.php/Organisation

HORNBILL HINT: Groups are stored in the table h_sys_groups and the types described above are represented by an integer value between 0 and 5 in a column called h_type. These are as follows; 0=general ,1=team ,2=department ,3=costcenter ,4=division ,5=company. The group type may be useful when creating measures, widgets, and reports.

 

 

 

 

[Guest Paul Alexander]

Hi @J_Tamburrini

 

have you tried searching for: SELECT * FROM h_sys_groups where h_name like 'Planning%'

that should tell you whether that division is in there anywhere.....

 

[J_Tamburrini]

Thanks Paul. i got something out of it. not the data i was looking for but at least it executed the query.

what i was looking for is a list of all the users who should be apart of the Planning & Development division.

More importantly is working out why they don't pull through to the division group in the first place.

we noticed as we run a report based on closed cases grouped by division and the P&D guys are mssing.

help needed.....

[Guest Paul Alexander]

You should be able to see this division in the Organisation list:

 

Then, after you've selected it, select the 'Assigned Users' tab which will show you who is assigned to the group:

 

 

I don't suppose the '&' in the division name is causing issues is it? Just a thought....

[Victor]

@J_Tamburrini - I suspect a mismatch between the division name/id in AD and the division name/id in Hornbill. Can you please PM me the import tool log file so I can have a quick look?