Workstation and installed software
SELECT systeminfo.workstationname "Workstation",
( softwarelist.softwarename ) "Software_Name",
Max(swmfg.NAME) "Manufacturer",
Max(softwareinfo.fileversion) "Version" FROM softwareinfo
LEFT JOIN softwarelist
ON softwareinfo.softwareid = softwarelist.softwareid
LEFT JOIN softwaretype
ON softwarelist.softwaretypeid = softwaretype.softwaretypeid
LEFT JOIN systeminfo
ON softwareinfo.workstationid = systeminfo.workstationid
LEFT JOIN softwaremanufacturer swmfg
ON softwarelist.swmanufacturerid = swmfg.swmanufacturerid
GROUP BY systeminfo.workstationname,
softwarelist.softwarename
ORDER BY 1
New to ADSelfService Plus?
Related Articles
Query to show software and its version along with workstations/Servers (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) SELECT SystemInfo.WORKSTATIONNAME "Workstation",MAX(aaaUser.FIRST_NAME) AS "User", MAX(Systeminfo.MODEL) AS "Model", (SoftwareList.SOFTWARENAME) "Software_Name", MAX(swmfg.NAME) "Manufacturer", ...
Software Not installed machines
SELECT Max(workstation.workstationname)"Machine Name", Max(aaauser.first_name) "User" FROM systeminfo workstation LEFT JOIN resources rs ON workstation.workstationid = rs.resourceid LEFT JOIN softwareinfo si ...
Software details
SELECT systeminfo.workstationname "Workstation", Max(aaauser.first_name) "User", ( softwarelist.softwarename ) "Software_Name", Max(softwaretype.softwaretype) "Software_Type", ...
Specific Software
SELECT ( softl.softwarename ) "Software Name", Max(workstation.workstationname) "Workstation", Max(workstation.model) "Model", Max(aaauser.first_name) "User", ...
Query to show list of softwares with last scanned date and license key (MSSQL & PGSQL)
Tested in build PGSQL (14300) and MSSQL (14306) select systeminfo.workstationname "Workstation Name", SoftwareList.SOFTWARENAME "Software Name", LONGTODATE(SoftwareInfo.filecreatedtime) "Software Installed Date", LONGTODATE(audithistory.audittime) ...