Hi All,

Please can I have some assistance below. We need to amend the below query to show contact details such as phone numbers against the "Last Logged on User" and NOT the "User". 

Any help would be mostly appreciated!

SELECT MAX(workstation.WORKSTATIONNAME) "Machine Name",

MAX(workstation.MODEL) "Model",
MAX(workstation.MANUFACTURER) "Manufacturer",
MAX(workstation.SERVICETAG) "Service Tag",
MAX(workstation.LOGGEDUSER) "Last Logged In User",
MAX(state.DISPLAYSTATE) "Asset State",
MAX(osInfo.OSNAME) "OS",
MAX(aaov.NAME) "Site",
MAX(aaaUser.FIRST_NAME) "User",
MAX(DepartmentDefinition.DEPTNAME) "Department",
MAX(AaaContactInfo.LANDLINE) "Phone",
MAX(SDUser.JOBTITLE) "JobTitle",
MAX(AaaContactInfo.MOBILE) "Mobile",
LONGTODATE(max(AUDITHISTORY.AUDITTIME)) "Last Scan Date" FROM SystemInfo workstation
LEFT JOIN Resources resource ON workstation.WORKSTATIONID=resource.RESOURCEID
LEFT JOIN ResourceState state ON resource.RESOURCESTATEID=state.RESOURCESTATEID
LEFT JOIN ResourceOwner rOwner ON resource.RESOURCEID=rOwner.RESOURCEID
LEFT JOIN ResourceAssociation rToAsset ON rOwner.RESOURCEOWNERID=rToAsset.RESOURCEOWNERID
LEFT JOIN SDUser sdUser ON rOwner.USERID=sdUser.USERID
LEFT JOIN AaaUser aaaUser ON sdUser.USERID=aaaUser.USER_ID
LEFT JOIN ResourceLocation resLocation ON resource.RESOURCEID=resLocation.RESOURCEID
LEFT JOIN SiteDefinition siteDef ON resLocation.SITEID=siteDef.SITEID
LEFT JOIN SDOrganization aaov ON siteDef.SITEID=aaov.ORG_ID
LEFT JOIN OsInfo osInfo ON workstation.WORKSTATIONID=osInfo.WORKSTATIONID
LEFT JOIN AaaUserContactInfo ON AaaUser.USER_ID=AaaUserContactInfo.USER_ID
LEFT JOIN AaaContactInfo ON AaaUserContactInfo.CONTACTINFO_ID=AaaContactInfo.CONTACTINFO_ID
LEFT JOIN UserDepartment ON AaaUser.USER_ID=UserDepartment.USERID
LEFT JOIN DepartmentDefinition ON UserDepartment.DEPTID=DepartmentDefinition.DEPTID
LEFT JOIN LastAuditInfo ON resource.RESOURCEID=LastAuditInfo.WORKSTATIONID
LEFT JOIN AuditHistory LASTSUCCESSAUDIT ON LastAuditInfo.LAST_SUCCESS_AUDITID=LASTSUCCESSAUDIT.AUDITID
LEFT JOIN AuditHistory ON LastAuditInfo.LAST_AUDITID=AuditHistory.AUDITID
GROUP BY workstation.WORKSTATIONID

Regards,

Reece