Hi,
I added a custom ''Registry Scanning'' in LS , then i create a report for the computers with the missing Key but it doesn't work correctly , can anyone feed me back with the correct report (details below) :
Lansweeper v. 6051
Microsoft SQL Server 2008
Report :
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.Regkey
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where tblAssets.AssetID Not In (Select Top 1000000 tblRegistry.AssetID
From tblRegistry
Where
tblRegistry.Regkey Like
'% SOFTWARE\Microsoft\Internet Explorer\MAIN\FeatureControl\FEATURE_ALLOW_USER32_EXCEPTION_HANDLER_HARDENING' And tblRegistry.Valuename = ' iexplore.exe') And tblAssets.AssetName Like 'TNS%' And tblRegistry.Valuename = 'iexplore.exe' And tblRegistry.Value = '1' And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName
Thanks.
