Notification

Icon
Error

"Exception" or "Exclusion" in Default Report - Trying to customize a default report

Posted: Thursday, February 7, 2019 8:04:10 PM(UTC)
Cripple.Zero

Cripple.Zero

Member Original PosterPosts: 17
0
Like
This issue has been solved! Click here to view the solution
I am trying to add an exclusion to one of the default reports in LANSweeper. It is the "Error: WMI Access Denied" report.

On our network we have PCL-like devices that are used on our manufacturing floor. They are boxes that have an Ethernet port and have a highly customized Windows embedded environment, but aren't robust enough to install software like Office, anti-virus, etc. They only provide a Windows GUI for engineers to access parts of the machinery that these PCL boxes control.

That being said, I would like to exclude those boxes from the Access Denied listing. There are quite a few of them across our different plants, so having them show up on the report skews our numbers by quite a lot. Each PCL device has a scanned asset name of "GVxxxx" (where 'xxxxx' represents the version number and a random ID unique to each box).

I am trying to exclude from the report all but the beginning "GV" AssetName portion. I have tried many different combinations of LIKE and NOT LIKE with operators and wildcards with <>, % or _


=============================
Select Top 1000000 tblErrors.AssetID,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetName,
'WMI Access denied. Username(s) tried: ' + tblErrors.ErrorText As Message,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As Type,
tblAssets.IPAddress As [IP Address],
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblErrors.Lastchanged As [Last changed],
tblAssets.Firstseen,
tblAssets.Lastseen,
'red' As foregroundcolor
From tblErrors
Inner Join tblAssets On tblErrors.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysasseterrortypes On
tblErrors.ErrorType = tsysasseterrortypes.Errortype
Left Outer Join tblOperatingsystem On
tblAssets.AssetID = tblOperatingsystem.AssetID
Left Outer Join tsysIPLocations On tblAssets.LocationID =
tsysIPLocations.LocationID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Where tblAssets.AssetName <> 'GV%' And tblAssetCustom.State = 1 And
tblOperatingsystem.AssetID Is Null And tblErrors.ErrorType = 1
Order By [Last changed] Desc,
tblAssets.AssetName

===================================

I'm not sure which combination is needed to exclude "GV" devices from the report. Am I placing the exclusion in the wrong part of the code?
JacobH
#1JacobH Member Posts: 165  
posted: 2/8/2019 9:26:26 PM(UTC)
Where tblAssets.AssetName not like 'GV%'

worked for me

Cripple.Zero
#2Cripple.Zero Member Original PosterPosts: 17  
posted: 2/8/2019 9:38:30 PM(UTC)
Thank you. I swear I did that, but then again, it was around 11pm and my eyes were getting squinty!!!

That did work, btw. This helps tremendously!

Active Discussions

Lansweeper Active Assets Versus Non-Active
by  RC62N   Go to last post Go to first unread
Last post: Yesterday at 9:29:26 PM(UTC)
Report Center Low Hard Disk Space (coloured) - Win+Linux
by  Olivier J.  
Go to last post Go to first unread
Last post: Yesterday at 4:16:02 PM(UTC)
Lansweeper check if process is running report
by  Randomusername   Go to last post Go to first unread
Last post: Yesterday at 3:29:16 PM(UTC)
Lansweeper Top 10 users submitting tickets
by  ChuckSchurman  
Go to last post Go to first unread
Last post: 8/22/2019 3:53:21 AM(UTC)
Lansweeper Identifying weak protocols
by  Jason Tree   Go to last post Go to first unread
Last post: 8/20/2019 3:06:03 PM(UTC)
Lansweeper Ticket Report Overview
by  briangmiller  
Go to last post Go to first unread
Last post: 8/20/2019 1:49:35 PM(UTC)
Lansweeper switch ports with multiple assets
by  FischbachM   Go to last post Go to first unread
Last post: 8/19/2019 9:10:42 AM(UTC)
Lansweeper Modify "....less than 1GB free HD..." Report
by  Cripple.Zero  
Go to last post Go to first unread
Last post: 8/15/2019 7:11:10 PM(UTC)