Client Management Suite

 View Only
  • 1.  Report Department Structure

    Posted 27 days ago
    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


  • 2.  RE: Report Department Structure

    Broadcom Employee
    Posted 25 days ago

    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]
    ------------------------------