RegKey report empty if key not found

[lexios]

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

[Esben_D]

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.