Need to add Device Type

Need to add Device Type

Hi,

Need to add device type (Desktop / Laptop) in this below query.

SELECT SystemInfo.WORKSTATIONNAME "Workstation", 
max(SystemInfo.MODEL)
"Model",MAX(procInfo.CPUNAME) AS "Processor Name", MAX(procInfo.SPEED) AS "Processor Speed (in MHz)",
max(osInfo.OSNAME) AS "OS",
max(state.DISPLAYSTATE) "Asset State" ,
(SoftwareList.SOFTWARENAME)
"Software_Name",
MAX(SoftwareType.SOFTWARETYPE)
"Software_Type",
MAX(SoftwareCategory.SOFTWARECATEGORY)
"Software_Category",
MAX(WmiSWUsageInfo.SOFTWAREUSAGE)
"Software_Usage",
MAX(SoftwareInfo.FILEVERSION) "File Version",
MAX(SWInstallationKeyInfo.PRODUCTID)
"Software_ID",
MAX(SWInstallationKeyInfo.PRODUCTKEY)
"Software_Key",MAX(aaov.NAME) "Site", longtodate(max(SoftwareInfo.FILECREATEDTIME)) "Installed On"   FROM SoftwareInfo LEFT JOIN
SoftwareList ON SoftwareInfo.SOFTWAREID=SoftwareList.SOFTWAREID LEFT
JOIN SoftwareType ON
SoftwareList.SOFTWARETYPEID=SoftwareType.SOFTWARETYPEID LEFT JOIN
WmiSWUsageInfo ON
SoftwareInfo.SOFTWAREINFOID=WmiSWUsageInfo.SOFTWAREINFOID LEFT JOIN
SWInstallationKeyInfo ON
SoftwareInfo.SOFTWAREINFOID=SWInstallationKeyInfo.SOFTWAREINFOID LEFT
JOIN SoftwareCategory ON
SoftwareList.SOFTWARECATEGORYID=SoftwareCategory.SOFTWARECATEGORYID
LEFT JOIN Systeminfo ON
SoftwareInfo.WORKSTATIONID=SystemInfo.WORKSTATIONID LEFT JOIN
Resources resource ON systeminfo.WORKSTATIONID=resource.RESOURCEID
LEFT JOIN ResourceLocation resLocation ON
resource.RESOURCEID=resLocation.RESOURCEID LEFT JOIN OsInfo osInfo ON SystemInfo.WORKSTATIONID=osInfo.WORKSTATIONID   LEFT JOIN SiteDefinition
siteDef ON resLocation.SITEID=siteDef.SITEID LEFT JOIN SDOrganization
aaov ON siteDef.SITEID=aaov.ORG_ID LEFT JOIN ResourceState state ON
resource.RESOURCESTATEID=state.RESOURCESTATEID   LEFT JOIN ProcessorInfo procInfo ON Systeminfo.WORKSTATIONID=procInfo.WORKSTATIONID  WHERE
SoftwareList.SOFTWARENAME like '%Microsoft Office%' GROUP BY
SoftwareList.SOFTWARENAME,SystemInfo.WORKSTATIONNAME

Thanks in advance.

              New to ADManager Plus?

                New to ADSelfService Plus?