→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
CyberCitizen
Honored Sweeper
Hi Guy's,

Having an issue limiting the search results on a report. Never had much luck limiting results under the OU section.



Basically trying to limit the results to Active. We have Disabled and Test, I am wanting to show Active on this report only.

If anyone can assist, that would be fantastic.

Report listed below.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssets.Version,
tblAssets.Domain,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblAssets.IPAddress,
tsysAssetTypes.AssetTypename As Type,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Lastseen,
tsysAssetTypes.AssetTypeIcon10 As icon,
Case
When tblAssets.Version > '1703%' Then '#d4f4be'
Else '#ffadad'
End As backgroundcolor,
tblADComputers.OU As [Active OU]
From tblAssets
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Outer Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Where tblAssets.IPAddress Is Not Null And tblAssets.IPAddress != '' And
tsysAssetTypes.AssetTypename = 'Windows' And tblAssetCustom.State = 1
Order By tblAssets.Version,
tblAssets.IPNumeric
1 REPLY 1
CyberCitizen
Honored Sweeper
Sorted, sorry just a brain fart moment.

Like '%Active%'