Software Licenses

Software Licenses



SELECT resource.resourcename                 "License Name", 
       Max(softwarelist.softwarename)        "Software_Name", 
       Max(resource.acquisitiondate)         "Acquisition Date", 
       Max(resource.expirydate)              "Expiry Date", 
       Max(swinstallationkeyinfo.productid)  "Software_ID", 
       Max(swinstallationkeyinfo.productkey) "Software_Key" FROM   softwareinfo 
       LEFT JOIN softwarelist 
              ON softwareinfo.softwareid = softwarelist.softwareid 
       LEFT JOIN swinstallationkeyinfo 
              ON softwareinfo.softwareinfoid = 
                 swinstallationkeyinfo.softwareinfoid 
       LEFT JOIN componentdefinitionsoftware 
              ON softwarelist.softwareid = 
                 componentdefinitionsoftware.softwareid 
       LEFT JOIN resources resource 
              ON componentdefinitionsoftware.componentid = Resource.componentid 
       LEFT JOIN softwarelicenses 
              ON Resource.resourceid = softwarelicenses.resourceid 
GROUP  BY resource.resourcename 
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?

                    New to ADSelfService Plus?

                    Start your free trial

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

                      • 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 ...

                      • Workstation and installed software

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

                      • Software deployment in UEM when Service Request is approved

                        Use case: To initiate the software request from Service Catalog, approve the request and initiate the software deployment using the EC agent. Prerequisites: 1. To include required packages within a specific template, follow these steps: Begin by ...

                        Related Products