Software Not installed machines

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 
              ON workstation.workstationid = si.workstationid 
       LEFT JOIN softwarelist sl 
              ON si.softwareid = sl.softwareid 
       LEFT JOIN resourceowner rOwner 
              ON rs.resourceid = rOwner.resourceid 
       LEFT JOIN resourceassociation rToAsset 
              ON rOwner.resourceownerid = rToAsset.resourceownerid 
       LEFT JOIN sduser sdUser 
              ON rOwner.userid = sduser.userid 
       LEFT JOIN aaauser aaaUser 
              ON sduser.userid = aaauser.user_id 
WHERE  workstation.workstationid NOT IN (SELECT workstationid 
                                         FROM   softwareinfo wi 
                                                LEFT JOIN softwarelist wl 
                                                wl.softwareid = wi.softwareid 
       wl.softwarename LIKE '%Microsoft%') 
GROUP  BY workstation.workstationname 

          • Related Articles

          • Software Licenses

            SELECT resource.resourcename                 "License Name",         Max(softwarelist.softwarename)        "Software_Name",         Max(resource.acquisitiondate)         "Acquisition Date",  ...
          • 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",  ...
          • How to export software data in CSV format?

            Steps to export Software data in CSV format 1. Login to ServiceDesk Plus/AssetExplorer. 2. Click on the Reports tab and then click on New Query Report button. 3. Copy and paste the following query and click Run Report. select "Scanned ...
          • Workstation and installed softwares

            SELECT systeminfo.workstationname    "Workstation",         ( softwarelist.softwarename ) "Software_Name",         Max(swmfg.NAME)               "Manufacturer",         Max(softwareinfo.fileversion) "Version" FROM   softwareinfo  ...