ServiceDesk Plus | Hardware

Hardware
Query to show asset monitor details
Working On Build: 14500 SELECT si.workstationname "Asset Name", si.workstationname "Asset Name", mi.monitortype "Monitor Type", mi.serialnumber "Monitor Serial Number" from systeminfo si LEFT JOIN monitorinfo mi ON si.workstationid=mi.workstationid ...
Query to show asset hardware details with Bios date (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) PGSQL: SELECT MAX(aaov.NAME) AS "Site", MAX(workstation.WORKSTATIONNAME) AS "Machine Name", MAX(workstation.MANUFACTURER) AS "Manufacturer", MAX(workstation.MODEL) AS "Model", MAX(memInfo.TOTALMEMORY) AS ...

ServiceDesk Plus | Hardware | Knowledge Base