cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
poweld1
Champion Sweeper
I've got a report as below to find computers with the following registry key. I can't seem to figure out how to create a report to find computers without the registry key. Can I get some help with this?

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.Lastchanged
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where tblRegistry.Regkey Like '%SOFTWARE\Safend\Protector' And
tblRegistry.Valuename = 'InstallDir'
Order By tblAssets.AssetUnique
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Please use the report below for this.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.AssetID Not In (Select tblAssets.AssetID
From tblAssets Inner Join tblRegistry On tblAssets.AssetID =
tblRegistry.AssetID
Where tblRegistry.Regkey Like '%SOFTWARE\Safend\Protector' And
tblRegistry.Valuename = 'InstallDir') And tsysAssetTypes.AssetTypename =
'windows' And tblAssets.Lastseen <> '' And tblAssetCustom.State = 1

View solution in original post

3 REPLIES 3
jaywill80
Engaged Sweeper
How I would scope this report down to search for just laptops missing a registry key?

Thanks
poweld1
Champion Sweeper
Thanks that works great.
Hemoco
Lansweeper Alumni
Please use the report below for this.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.AssetID Not In (Select tblAssets.AssetID
From tblAssets Inner Join tblRegistry On tblAssets.AssetID =
tblRegistry.AssetID
Where tblRegistry.Regkey Like '%SOFTWARE\Safend\Protector' And
tblRegistry.Valuename = 'InstallDir') And tsysAssetTypes.AssetTypename =
'windows' And tblAssets.Lastseen <> '' And tblAssetCustom.State = 1