Sample custom report to display User details along with manager

Products

• IT Management Suite

Issue/Introduction

This report query will help report on the following details of a user :

• Department
• Office Location
• Manager
• Email
• Company
• Office Telephone

Environment

IT Management Suite 

Report Builder

Resolution

*NOTE - These instructions are given as an example only. Use and modify at your own risk.

In the Symantec Management console, click on Reports > All Reports. This must be performed with a user that has report builder rights.
Right click and select New > Base Report > SQL Report
Copy and paste below mentioned SQL query under Parameterized Query and Save:

Select  I.[Personal Title], I.[Initials], I.[Given Name],I.[Surname],I.[Department],I.[Office Location],
I.[Job Title],I.[Email],I.[Company],I.[Office Telephone],
R.[Name] As [Manager], RA.[ParentResourceGuid]
from Inv_Global_User_General_Details I
Join ResourceAssociation RA
On RA.ParentResourceGuid =I._ResourceGuid
Join RM_ResourceUser R
on R.Guid =RA.ChildResourceGuid