"not exist" on Registry keys

[hstru]

Hi,

I added some Registry Keys in Custom Scanning e.g.
SOFTWARE\Wow6432Node\Citrix\ICA Client\Engine\Configuration\Advanced\Modules\WFClient > TWISeamlessFlag
SOFTWARE\Wow6432Node\Policies\Citrix\HdxMediaStreamForFlash\Client\PseudoContainer > UseFlashRemoting
SOFTWARE\Wow6432Node\Policies\Citrix\HdxMediaStreamForFlash\Client\PseudoContainer > EnableServerSideContentFetching
SOFTWARE\Wow6432Node\Citrix\ICA Client\Engine\Configuration\Advanced\Modules\ClientDrive > HighThroughputWindowSize

I need a report that lists all machines where one or more of these keys do not exist.

I tried via tblRegistry but could only manage to list Keys, Values and Valuename but not a “not exist”.

Can you please help me out?

BR,
Henning

[hstru]

Thank you very much, that does the trick.

BR,
Henning

[Susan_A · Accepted solution]

I've pasted a sample report below that lists machines that are missing one or more of these keys. Instructions for adding this report to your installation can be found here. If you are interested in building or modifying reports, we would recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  
• Updating to Lansweeper 5.3, if you haven't already. Lansweeper 5.3 includes a database dictionary, which is linked at the top of the report builder. The dictionary explains in great detail what each table and field stores.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where (tblAssets.AssetID Not In (Select Top 1000000 tblRegistry.AssetID
    From tblRegistry
    Where
      tblRegistry.Regkey Like
      '%SOFTWARE\Wow6432Node\Citrix\ICA Client\Engine\Configuration\Advanced\Modules\WFClient' And tblRegistry.Valuename = 'TWISeamlessFlag') Or tblAssets.AssetID Not In (Select Top 1000000 tblRegistry.AssetID From tblRegistry Where tblRegistry.Regkey Like '%SOFTWARE\Wow6432Node\Policies\Citrix\HdxMediaStreamForFlash\Client\PseudoContainer' And tblRegistry.Valuename = 'UseFlashRemoting') Or tblAssets.AssetID Not In (Select Top 1000000 tblRegistry.AssetID From tblRegistry Where tblRegistry.Regkey Like '%SOFTWARE\Wow6432Node\Policies\Citrix\HdxMediaStreamForFlash\Client\PseudoContainer' And tblRegistry.Valuename = 'EnableServerSideContentFetching') Or tblAssets.AssetID Not In (Select Top 1000000 tblRegistry.AssetID From tblRegistry Where tblRegistry.Regkey Like '%SOFTWARE\Wow6432Node\Citrix\ICA Client\Engine\Configuration\Advanced\Modules\ClientDrive' And tblRegistry.Valuename = 'HighThroughputWindowSize')) And tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName