I would like to add Product Type and Product to this report. I searched the forums but didn't have any luck locating a report that would fit my needs. Thanks for the help.
SELECT systeminfo.workstationname "Workstation Name",
nt.ipaddress 'IP Address',nt.macaddress 'MAC Address',DATE_FORMAT(FROM_UNIXTIME(audithistory.audittime/1000),'%m-%d-%Y %k:%i') "Last Scanned on",audithistory.auditstatus "Scan status"
FROM audithistory LEFT JOIN systeminfo ON systeminfo.workstationid=audithistory.workstationid
LEFT JOIN Resources resource ON systeminfo.WORKSTATIONID=resource.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 RegionDefinition regionDef ON resLocation.REGIONID=regionDef.REGIONID LEFT JOIN networkinfo nt ON nt.workstationid=systeminfo.workstationid
WHERE audithistory.auditid IN
(SELECT MAX(audithistory.auditid) FROM audithistory GROUP BY workstationid)