Custom report to display User details along with Manager
Last Updated April 06, 2019
This query will help fetch following details of a user :
On Symantec Management console, click on Reports > All Reports.
Right click and select New > 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
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe