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: 15
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: 143  
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: 15  
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 NEW TAB
by  TinyTunerz   Go to last post Go to first unread
Last post: Today at 1:39:19 PM(UTC)
Lansweeper Force SNMP?
by  JacobH  
Go to last post Go to first unread
Last post: Today at 1:11:46 PM(UTC)
Lansweeper LSAgent has forgotten x64 Windows applications
by  thoughtmonkey   Go to last post Go to first unread
Last post: Today at 8:06:40 AM(UTC)
Lansweeper Lsremote "No supported authentication methods!"
by  Duiker  
Go to last post Go to first unread
Last post: Today at 7:52:24 AM(UTC)
Lansweeper Scan Uptime.
by  TimAlex   Go to last post Go to first unread
Last post: Today at 7:32:41 AM(UTC)
Lansweeper Performance scanning - incorrect values
by  Richard_Lan  
Go to last post Go to first unread
Last post: Yesterday at 4:26:02 PM(UTC)
Lansweeper Windows firewall rules
by  pryan67   Go to last post Go to first unread
Last post: Yesterday at 2:56:52 PM(UTC)
Lansweeper Run outside of our domain?
by  pryan67  
Go to last post Go to first unread
Last post: Yesterday at 2:53:05 PM(UTC)