Query Report
Use this query :select au.FIRST_NAME 'User', res.RESOURCENAME 'WorkStation', ni.IPADDRESS 'IpAddress', dd.DEPTNAME 'Department', ao.NAME 'Site' from SdUser sdu left join AaaUser au on sdu.USERID=au.USER_ID left join ResourceOwner ro on sdu.USERID=ro.USERID left join Resources res on ro.RESOURCEID=res.RESOURCEID left join SystemInfo si on res.RESOURCEID=si.WORKSTATIONID left join NetworkInfo ni on si.WORKSTATIONID=ni.WORKSTATIONID left join UserDepartment ud on sdu.USERID=ud.USERID left join DepartmentDefinition dd on ud.DEPTID=dd.DEPTID left join SiteDefinition sd on dd.SITEID=sd.SITEID left join AaaOrganization ao on sd.SITEID=ao.ORG_IDRgdsAK