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: 4
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: 64  
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: 4  
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 Software Deployment packages to Windows 10 machines Fail
by  jblamire  
Go to last post Go to first unread
Last post: Yesterday at 8:01:37 PM(UTC)
Lansweeper Change user who entered time worked
by  sbAYVdQu   Go to last post Go to first unread
Last post: Yesterday at 7:33:01 PM(UTC)
Lansweeper Questions about Emailing Reports
by  Cripple.Zero  
Go to last post Go to first unread
Last post: Yesterday at 7:04:54 PM(UTC)
Lansweeper Installing Lansweeper on Windows Core Server
by  AZHockeyNut   Go to last post Go to first unread
Last post: Yesterday at 6:13:15 PM(UTC)
Lansweeper Lansweeper Asset Screen not showing Purchased & Warranty values
by  JacobH  
Go to last post Go to first unread
Last post: Yesterday at 2:15:09 PM(UTC)
Lansweeper Sonos not detected
by  Vic T.   Go to last post Go to first unread
Last post: Yesterday at 2:03:26 PM(UTC)
Lansweeper Lansweeper Ignoring Exclusions after 6.x to 7.Upgrade
by  Vic T.  
Go to last post Go to first unread
Last post: Yesterday at 1:52:05 PM(UTC)