10-01-2017 11:58 PM
10-04-2017 04:11 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
Case
When SubQuery1.Valuename Is Not Null And SubQuery1.Valuename <>
'' Then 'Yes' Else 'No' End As ValuenameFound,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
SubQuery1.Value,
SubQuery1.Regkey,
SubQuery1.Valuename,
SubQuery1.Lastchanged,
tblSoftwareUni.SoftwarePublisher As Publisher
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join (Select Top 1000000 tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.Lastchanged
From tblRegistry
Where
tblRegistry.Regkey Like
'%SOFTWARE\WOW6432Node\Adobe\Acrobat Reader\DC\Installer' And
tblRegistry.Valuename = 'ENU_GUID') SubQuery1 On SubQuery1.AssetID =
tblAssets.AssetID
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where Case
When SubQuery1.Valuename Is Not Null And SubQuery1.Valuename <>
'' Then 'Yes' Else 'No'
End = 'Yes' And tblSoftwareUni.softwareName Like 'Adobe Acrobat Reader DC%'
Order By tblSoftware.softwareVersion
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now