→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
joe_lucero
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
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