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')