Add Product and Product Type to this report

Add Product and Product Type to this report

Hello,

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)
              New to ADManager Plus?

                New to ADSelfService Plus?