Specific Software

Specific Software



SELECT ( softl.softwarename )           "Software Name", 
       Max(workstation.workstationname) "Workstation", 
       Max(workstation.model)           "Model", 
       Max(aaauser.first_name)          "User", 
       Max(deptDef.deptname)            "Department", 
       Max(workstation.loggeduser)      "Last Logged In User", 
       Max(dominf.domainname)           "Domain Name", 
       CASE 
         WHEN Max(Cast(compDefLaptop.islaptop AS VARCHAR(5))) = 1 THEN 'Laptop' 
         ELSE 'Desktop' 
       END                              "Desktop /Laptopn" FROM   systeminfo workstation 
       LEFT JOIN resources resource 
              ON workstation.workstationid = resource.resourceid 
       LEFT JOIN componentdefinition product 
              ON resource.componentid = product.componentid 
       LEFT JOIN componentdefinitionlaptop compDefLaptop 
              ON product.componentid = compDefLaptop.componentid 
       LEFT JOIN resourceowner rOwner 
              ON resource.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 
       LEFT JOIN departmentdefinition deptDef 
              ON rOwner.deptid = deptDef.deptid 
       LEFT JOIN systeminfodomain sysInfod 
              ON workstation.workstationid = sysInfod.workstationid 
       LEFT JOIN domaininfo dominf 
              ON sysInfod.domainid = dominf.domainid 
       LEFT JOIN softwareinfo swi 
              ON workstation.workstationid = swi.workstationid 
       LEFT JOIN softwarelist softl 
              ON swi.softwareid = softl.softwareid 
WHERE  softl.softwarename LIKE '%MICROSOFT%' 
GROUP  BY workstation.workstationid, 
          softl.softwarename 


          • 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",  ...
          • 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 swm.name "Scanned ...
          • Software Compliance Report

            Number of products out of compliance select swct.compliancetype "Compliance Type",count(swcd.softwareid) "Number of Products" from SWComplianceDetails swcd left join swcompliancetype swct on swcd.swcompliancetypeid=swct.swcompliancetypeid where ...
          • 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  ...