Duplicate registry key report

[poweld1]

I've got registry scanning enabled for the SusClientId

HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\SusClientId

I can't figure how to create a report to find duplicate SusClientId values.

Cheers

[Khaneric]

Sorry to bring an old topic back from the grave but I'm finding this report isn't working currently. Is there anyway this can be updated to work as I feel it's a VERY useful report especially with all the critical patches coming out lately.

Thanks

[Susan_A · Accepted solution]

I've included a sample report below, which you can add to your Lansweeper installation by following these instructions. If you are interested in building or modifying reports, we do 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.
  
• Making use of our database dictionary, more information on which can be found here. 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,
  SubQuery.Value,
  SubQuery.Count
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
  Inner Join (Select Top 1000000 tblRegistry.Value,
  Count(tblRegistry.AssetID) As Count
From tblRegistry
  Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblRegistry.AssetID
Where tblAssetCustom.State = 1 And
  tblRegistry.Regkey =
  'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate'
  And tblRegistry.Valuename = 'susclientid'
Group By tblRegistry.Value,
  tblRegistry.Regkey,
  tblRegistry.Valuename) SubQuery On SubQuery.Value = tblRegistry.Value
Where SubQuery.Count > 1 And tblAssetCustom.State = 1
Order By SubQuery.Value,
  tblAssets.Domain,
  tblAssets.AssetName