→ 🚀Are you a Lansweeper Champion?! Join our Contributor Program Sign up here!

Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
WhatTheFrenchTo
Engaged Sweeper III
What table would I use via the report builder in order to exclude specific PCs? Specifically, I'm trying to exclude a couple PCs from the no AV report since we don't want them running AV anyways for testing.
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
In order to manually exclude specific machines from a report, use a filter like Not In ('hostname01','hostname02','hostname03') as filter criterium for tblAssets.Assetname.
In the SQL query, the filter would look like this:

Where tblAssets.Assetname Not In ('hostname01','hostname02','hostname03')

View solution in original post

2 REPLIES 2
WhatTheFrenchTo
Engaged Sweeper III
Thanks Daniel!
Daniel_B
Lansweeper Alumni
In order to manually exclude specific machines from a report, use a filter like Not In ('hostname01','hostname02','hostname03') as filter criterium for tblAssets.Assetname.
In the SQL query, the filter would look like this:

Where tblAssets.Assetname Not In ('hostname01','hostname02','hostname03')

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now