Adobe Report Help

[joe_lucero]

I am new to lansweeper reporting and would like to create a report that includes all purchased adobe licensing. I need to be able to exclude programs such as reader and flash

[Daniel_B · Accepted solution]

If you would like to scan license keys from computers in your network, you first need to enable this for the products you are interested in under Configuration\Product Keys. More information on viewing and scanning product license keys can be found in this KB article. After successfully rescanning your computers you will get a list of product keys through the built-in report "License: Software licensekey overview" or a customized version like this one:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tsysOS.OSname,
  tblSerialnumber.Product,
  tblSerialnumber.ProductID,
  tblSerialnumber.ProductKey,
  tsysOS.Image As icon
From tblAssets
  Inner Join tblSerialnumber On tblAssets.AssetID = tblSerialnumber.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblSerialnumber.Product Like 'adobe %' And tblAssetCustom.State = 1
Order By tblAssets.AssetUnique,
  tblSerialnumber.Product