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 M365 Manager Plus?
      New to M365 Manager Plus?
        New to RecoveryManager Plus?
        New to RecoveryManager Plus?
          New to Exchange Reporter Plus?
          New to Exchange Reporter Plus?
            New to SharePoint Manager Plus?
            New to SharePoint Manager Plus?
                See all integrations
                New to ADManager Plus?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial
                  Start your free trial

                    • 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 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 workstation, agent installed status and domain name (MSSQL & PGSQL)

                      Tested in build PGSQL (14300) and MSSQL (14306) PGSQL & MSSQL: select si.workstationname "Workstation",max(case when si.isagentinstalled = '0' then 'NO' else 'SI' end) "Installato", max(ai.agentversion) "VERSIONE AGENTE", di.domainname "Domain Name" ...

                    • Query to extract the “Software-License Additional Fields” along with the existing additional fields (PGSQL)

                      (Applicable for builds 14300 & above) Below query has been modified to add a LEFT JOIN between the additional fields table and the table from which you extracted the softwares: QUERY: SELECT SUM(scd.ALLOCATED) AS "Allocated", ...

                      Related Products