This query will help fetch following details of a user :
Department
Office Location
Manager
Company
Office Telephone
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