Report Department Structure

[Hans Meiser]

Hello,

iam looking for a way to display current department structure of our company.
I need a list with all users and in one line all departments the user is member of from top to bottom.
In [Symantec_CMDB].[dbo].[RM_ResourceDepartment] i see a list of our departments, but for my surprise in column [ParentFolderGuid]all Departments have same value. I expected to use this to create a hierarchy.
So i think i have to use the resourceassociation "Department Hierarchy" in a recursive way.

Anybody can provide a ready to use sql script?

May SQL Knowledge is limited so i get it only without recusion in an **** way.

Thanks for your help
Hans

[Igor Perevozchikov]

Hi Hans Meiser!

1. There is a "Resource Association Grid" via right click menu on required department

Choose there required "Association Type" and click refresh.
As example to see only "User's Department" association report data

2. Check default "Users" report 

SMP Console > Reports > All Reports > expand "Notification Server Management" folder > expand "Server" folder > expand "Resource Reports" folder >  Users report

Best Regards,
IP.

------------------------------
[JobTitle]
[CompanyName]
[State]
------------------------------