Notification

Icon
Error

Report thats showing Windows machines when AV is not like =

Posted: Thursday, November 28, 2019 9:38:01 AM(UTC)
Lenny87

Lenny87

Member Original PosterPosts: 1
0
Like
Hello,

We need a report thats showing all Windows machines (PCs and servers) where Antivirus is not like = For example Sophos antivirus.

We dont really knows how to build a report, so could any help us with that problem? :-)
RC62N
#1RC62N Member Posts: 411  
posted: 11/28/2019 5:56:51 PM(UTC)
Set up your base report and add tblAntivirus. Add tblAntivirus.DisplayName to the list of fields in the report and set the criteria to "Not Like '%Sophos%'" (or whatever you need to match).

e.g.
Code:
Select Top 1000000
  tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblAntivirus.DisplayName
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblAntivirus On tblAssets.AssetID = tblAntivirus.AssetID
Where
  tblAssetCustom.State = 1
  And tblAntivirus.DisplayName Not Like '%Sophos%'

Active Discussions

Lansweeper Asset Out of Warranty & Asset Out of Warranty in 60 Days Reports
by  RC62N   Go to last post Go to first unread
Last post: Yesterday at 10:29:35 PM(UTC)
Lansweeper Voip Phone to Computer
by  lansend  
Go to last post Go to first unread
Last post: Yesterday at 1:27:10 AM(UTC)
Lansweeper Report Showing custom registry keys scanned
by  impagian   Go to last post Go to first unread
Last post: 1/23/2020 4:01:34 PM(UTC)
Lansweeper Dell Update v3.0
by  gmw158  
Go to last post Go to first unread
Last post: 1/22/2020 5:42:19 PM(UTC)
Lansweeper Report to compare softwareVersion
by  RC62N   Go to last post Go to first unread
Last post: 1/22/2020 4:57:16 PM(UTC)
Lansweeper Dublicate entries (multiple lines with assetname)
by  wkorrubel  
Go to last post Go to first unread
Last post: 1/22/2020 10:10:28 AM(UTC)
Lansweeper Only show string right of character N
by  RC62N   Go to last post Go to first unread
Last post: 1/20/2020 10:36:12 PM(UTC)
Lansweeper Report From Lansweeper For My Company
by  RC62N  
Go to last post Go to first unread
Last post: 1/17/2020 6:59:47 PM(UTC)