03-22-2016 04:10 PM
Solved! Go to Solution.
03-31-2016 12:55 PM
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
03-09-2021 05:50 PM
09-09-2024 10:01 PM
just wondering if this ever was resolved. I can run a report, but it finds the multiple times a single asset has been scanned and counts itself as a duplicate.
just need a report to show the duplicate assets with the same clientid's
03-31-2016 12:55 PM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now