Please can I have some assistance mending the below. The script shows all the correct information but instead of receiving contact information regarding "User" we need it to show all the information for the "Last Logged on User" such as phone numbers etc.

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

Cheers,

Reece