Workstation and installed softwares
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?
Resources
Related Articles
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", ...
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 ...
List of workstations without agent installed.
For Versions 11.2 and below: SELECT MAX(workstation.WORKSTATIONNAME) "Workstation Name", MAX(net.IPADDRESS) "IP Address", MAX(aaov.NAME) "Site", MAX(aaaUser.FIRST_NAME) "User", MAX(workstation.LOGGEDUSER) "Last Logged In User", ...
Report on User accounts stored in a Workstation\Server
DB Compatibility : PGSQL & MSSQL Build Compatibility : Builds above 10000 select si.WORKSTATIONNAME AS "WORKSTATION NAME", ua.USERNAME,ua.DOMAINNAME,ua.FULLNAME,ua.DESCRIPTION,ua.STATUS,ua.LOCALACCOUNT,ua.SID, si.model AS "MODEL",si.servicetag AS ...