Workstation and installed softwares

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 

          • 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.

            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", LONGTODATE(MAX(LASTSUCCESSAUDIT.AUDITTIME)) "Last ...

          • 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 ...