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
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", ...
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 ...
Workstation Server Inventoried
SELECT Max(workstation.workstationname) "Workstation", Max(workstation.model) "Model", Max(workstation.servicetag) "Service Tag", Max(state.displaystate) "Asset State", ...
Workstation/Server Detected
SELECT Max(workstation.workstationname) "Workstation", Max(workstation.model) "Model", Max(workstation.servicetag) "Service Tag", Max(state.displaystate) "Asset State", ...