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

        New to ADManager Plus?

          New to ADSelfService Plus?

            • 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 ...
            • Block attachments from specific IP Address

              Requirement: In few organisations, certain IP Address are refrained from creating requests with attachments. Steps to configure: Goto Admin > Developer Space > Request Custom Functions > Global function > New > Paste the content from the ...