
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-03-2015 06:06 PM
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.
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-03-2015 06:58 PM
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:
In the SQL query, the filter would look like this:
Where tblAssets.Assetname Not In ('hostname01','hostname02','hostname03')
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-03-2015 07:38 PM
Thanks Daniel!

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-03-2015 06:58 PM
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:
In the SQL query, the filter would look like this:
Where tblAssets.Assetname Not In ('hostname01','hostname02','hostname03')
