search cancel

Custom report to display User details along with Manager

book

Article ID: 174249

calendar_today

Updated On:

Products

Deployment Solution

Issue/Introduction

This query will help fetch following details of a user :

Department

Office Location

Manager

Email

Company

Office Telephone

Resolution

  1. On Symantec Management console, click on Reports > All Reports. 
  2. Right click and select New > Report > SQL Report
  3. 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