TRY NOW

Adobe License Audit

Licenses Software

Perform an Adobe Software License Audit on Your Network

Generate a complete report for Adobe license audits which require a full list of computers from asset inventory software and based on AD computer accounts as well as an inventory on Adobe software installations on the network. The report below provides this overview of inventory and licenses. Adobe License Audit

Adobe License Audit Query

Select Top 1000000 tblAssets.AssetID,
   tblAssets.Domain,
   tblAssets.AssetName,
   Case When tblComputersystem.Domainrole > 1 Then 'Server' Else Case
       When Coalesce(tblPortableBattery.AssetID, 0) = 0 Then 'Desktop'
       Else 'Laptop' End End As Type,
   tblState.Statename As [Asset state],
   tsysAssetTypes.AssetTypeIcon10 As icon,
   tblAssets.Lastseen,
   tblOperatingsystem.Caption As OS,
   tSoftware.softwareName,
   tSoftware.SoftwarePublisher,
   tSoftware.softwareVersion
 From tblAssets
   Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
   Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
   Left Join (Select tblSoftware.AssetID,
     tblSoftwareUni.softwareName,
     tblSoftwareUni.SoftwarePublisher,
     tblSoftware.softwareVersion
   From tblSoftware
     Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
   Where (tblSoftwareUni.softwareName Like '%adobe%') Or
     (tblSoftwareUni.SoftwarePublisher Like '%adobe%')) tSoftware
     On tSoftware.AssetID = tblAssets.AssetID
   Left Join tblPortableBattery On tblAssets.AssetID = tblPortableBattery.AssetID
   Inner Join tblOperatingsystem
     On tblAssets.AssetID = tblOperatingsystem.AssetID
   Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
   Left Join tblState On tblState.State = tblAssetCustom.State
 Order By tblAssets.AssetName,
   tSoftware.softwareName

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.