Good morning,
The following report works for me, although there are some programs like: AutoCAD or Retrospect I think it is because it does not find the license number, but I would like to know if there is another way of being able to list.
Thanks.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tsysAssetTypes.AssetTypename,
tblAssetCustom.Serialnumber As Serialnumber1,
tblAssets.Mac,
tsysOS.OSname As OS,
tblAssets.Processor,
tblAssets.Memory,
tblSerialnumber.Product,
tblAssetCustom.Custom2,
tblAssetCustom.Custom3,
tblAssetCustom.Custom4,
tblAssetCustom.Custom5
From tblAssets
Left Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join tblSerialnumber On tblAssets.AssetID = tblSerialnumber.AssetID
Left Join tblAntivirus On tblAssets.AssetID = tblAntivirus.AssetID
Left Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where (tblSerialnumber.Product Like '%acrobat%') Or
(tblSerialnumber.Product Like '%corel%') Or
(tblSerialnumber.Product Like '%AutoCAD%') Or
(tblSerialnumber.Product Like '%omnipage%') Or
(tblSerialnumber.Product Like '%photoshop%') Or
(tblSerialnumber.Product Like '%adobe%') Or
(tblSerialnumber.Product Like '%Project Standard 2013%') Or
(tblSerialnumber.Product Like '%Retrospect')
Order By tblSerialnumber.Product
