Asset Management - report to get the list of workstations that do not have agent installed on them

SELECT MAX(workstation.WORKSTATIONNAME) "Workstation Name",
       MAX(net.IPADDRESS) "IP Address",
       MAX(aaov.NAME) "Site",
       MAX(aaaUser.FIRST_NAME) "User",
       MAX(workstation.LOGGEDUSER) "Last Logged In User",
       LONGTODATE(MAX(LASTSUCCESSAUDIT.AUDITTIME)) "Last Success scan" FROM SystemInfo workstation
LEFT JOIN NetworkInfo net ON workstation.WORKSTATIONID=net.WORKSTATIONID
LEFT JOIN Resources RESOURCE ON workstation.WORKSTATIONID=resource.RESOURCEID
LEFT JOIN ResourceOwner rOwner ON resource.RESOURCEID=rOwner.RESOURCEID
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 SDUser sdUser ON rOwner.USERID=sdUser.USERID
LEFT JOIN AaaUser aaaUser ON sdUser.USERID=aaaUser.USER_ID
LEFT JOIN LastAuditInfo ON workstation.WORKSTATIONID=LastAuditInfo.WORKSTATIONID
LEFT JOIN AuditHistory ON LastAuditInfo.LAST_AUDITID=AuditHistory.AUDITID
LEFT JOIN AuditFailureInfo ON AuditHistory.AUDITID=AuditFailureInfo.AUDITID
LEFT JOIN AuditHistory LASTSUCCESSAUDIT ON LastAuditInfo.LAST_SUCCESS_AUDITID=LASTSUCCESSAUDIT.AUDITID
LEFT JOIN AgentInfo ON workstation.WORKSTATIONID=AgentInfo.WORKSTATIONID
WHERE (workstation.ISAGENTINSTALLED = '0')
GROUP BY workstation.WORKSTATIONID
Click this link to navigate to the next report.