→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
AnthelioHealth
Engaged Sweeper
I've created a report from a registry scan...

It seems to work great, but what I would really like is the opposite of the current out put. Instead of getting a list of the servers that DO have this particular registry entry, I like a list of the servers that DO NOT have the entry. I tried inserting the 'Not Like' statement, but the result is a report with no data (and I know that's wrong). Here's the code:

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain As [Domain\Workgroup],
tsysIPLocations.IPLocation As Location,
tblAssets.IPAddress As [IP Address],
tsysOS.OSname As OS,
TsysChassisTypes.ChassisName As [Chassis Type],
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblSystemEnclosure.SerialNumber,
tblAssets.LastActiveScan,
tblAssets.Scanserver,
tblRegistry.Regkey,
tblRegistry.Value
From tblAssets
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On tblSystemEnclosure.ChassisTypes =
TsysChassisTypes.Chassistype
Where tblRegistry.Regkey Like '%Nimbus.Nim' And tblRegistry.Valuename = ' ' And
tblComputersystem.Domainrole > 1
Order By tblAssets.AssetUnique
1 REPLY 1
Hemoco
Lansweeper Alumni
Please use the report below.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain As [Domain\Workgroup],
tsysIPLocations.IPLocation As Location,
tblAssets.IPAddress As [IP Address],
tsysOS.OSname As OS,
TsysChassisTypes.ChassisName As [Chassis Type],
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblSystemEnclosure.SerialNumber,
tblAssets.LastActiveScan,
tblAssets.Scanserver
From tblAssets
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On tblSystemEnclosure.ChassisTypes =
TsysChassisTypes.Chassistype
Where tblAssets.AssetID Not In (Select tblRegistry.AssetID From tblRegistry
Where tblRegistry.Regkey Like '%Nimbus.Nim' And tblRegistry.Valuename = ' ')
And tblComputersystem.Domainrole > 1
Order By tblAssets.AssetUnique