Workstation and installed software

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 ADManager Plus?

                  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",  ...