
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-03-2020 03:53 PM
Hello all!
I had a question in regards to the aforementioned Lansweeper report. We currently have about 20 or so WYSE Clients (Thin OS PC's) in our environment. The problem that I am having is that these specific machines show up in our report and they should not.
Is there anyway to exclude a certain machine type from showing up in the report?
Thank you all so much!
I had a question in regards to the aforementioned Lansweeper report. We currently have about 20 or so WYSE Clients (Thin OS PC's) in our environment. The problem that I am having is that these specific machines show up in our report and they should not.
Is there anyway to exclude a certain machine type from showing up in the report?
Thank you all so much!
Labels:
- Labels:
-
General Discussion
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-04-2020 01:52 PM
Hi Tyler P.
If the WYSE clients are detected as a different asset type then Windows, you can add an exclusion based on asset type to the SQL code. I'd recommend to first save a copy of the report before making any changes.
You can exclude assets based on asset type by adding the following SQL statement to the where clause.
tblAssets.AssetID NOT IN
(
SELECT tblAssets.assetid
FROM tblAssets
WHERE tblassets.Assettype = '1'--> ID number of the assettype to be excluded
)
If the WYSE clients are detected as a different asset type then Windows, you can add an exclusion based on asset type to the SQL code. I'd recommend to first save a copy of the report before making any changes.
You can exclude assets based on asset type by adding the following SQL statement to the where clause.
tblAssets.AssetID NOT IN
(
SELECT tblAssets.assetid
FROM tblAssets
WHERE tblassets.Assettype = '1'
)
