→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
NOGEHR
Engaged Sweeper
Would like to modify the report, to exclude our Wes terminals. Wes being the computer name.

How would I go about modifying the canned report to do this?
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
In order to exclude specific asset names or parts of it from a report, edit the report, look for tblAssets.Assetname and add a filter criterium to it. The following report uses the criterium "Not Like 'wes%'":

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.AssetName Not Like 'wes%' And tblAssetCustom.State = 1

View solution in original post

2 REPLIES 2
NOGEHR
Engaged Sweeper
Thank you,

I was able to modify the report to obtain the information I needed.

Daniel_B
Lansweeper Alumni
In order to exclude specific asset names or parts of it from a report, edit the report, look for tblAssets.Assetname and add a filter criterium to it. The following report uses the criterium "Not Like 'wes%'":

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.AssetName Not Like 'wes%' And tblAssetCustom.State = 1

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now