→ 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: 
lexios
Engaged Sweeper
Hello, I have created a number of reports based on Registry Key scan.
The problem is that if the key is not found on an Asset, then the asset is not shown at all on the report.

What is the proper way of doing this so we know.

a. All assets that have the key
b. All assets that do not have the key


Thanks a lot for any help!


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblSoundDevice.Manufacturer,
tblAssetCustom.Model,
tblRegistry.Regkey,
tblRegistry.Value
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSoundDevice On tblAssets.AssetID = tblSoundDevice.AssetID
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where tblSoundDevice.Manufacturer = 'Conexant' And
tblRegistry.Regkey Like '%SOFTWARE\Conexant' And tblRegistry.Value =
'CurrentDriverVersion' And tblAssetCustom.State = 1
1 REPLY 1
Esben_D
Lansweeper Employee
Lansweeper Employee
We have a sample report available for scanned registry keys. I recommend you use that as a start. You can find it here: https://www.lansweeper.com/Forum/yaf_postst10451_Value-of-a-value-name-submitted-for-custom-registry-scanning.aspx#post39295

Do note that it is not possible for Lansweeper to tell you if a key exists or not. Only if the specified value exists or not.