"Exception" or "Exclusion" in Default Report

[mhammond]

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?

[mhammond]

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!

[JacobH · Accepted solution]

Where tblAssets.AssetName not like 'GV%'

worked for me