Laptops without Encryption

[mmeetze]

I am currently scanning two custom reg keys to pull back a report of our installations of our two Encryption Products. I can run each report individually and pull back the information but I am currently trying to compile a report that will first Look and make sure that the Device is in fact a laptop and secondly that the presence of neither of the registry keys is there. This should provide me with an as accurate as possible list of Laptops that are not currently encrypted. The keys we are scanning for are below:
1.HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon\CMGShield RegValue:LogFileDir
2.HKLM\SOFTWARE\WINMagic\securedoc RegValue:productname


Could someone please assist in a query that will output All laptops that do not have the above Registry Keys present?

Thanks

[mmeetze]

Perfect, thanks so much!

[Jeremy_D · Accepted solution]

Please use the report below to list the information you are after. It lists laptops that are missing both of the specified registry values. Instructions for adding reports to your installation can be found here.

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 tblPortableBattery
    On tblAssets.AssetID = tblPortableBattery.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\Microsoft\Windows NT\CurrentVersion\Winlogon\CMGShield' And
    tblRegistry.Valuename = 'LogFileDir') And
  tblAssets.AssetID Not In (Select Top 1000000 tblRegistry.AssetID
  From tblRegistry
  Where tblRegistry.Regkey Like '%SOFTWARE\WINMagic\securedoc'
    And tblRegistry.Valuename = 'productname') And tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName