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 Lansweeper Webserver Error
by  Bruce.B   Go to last post Go to first unread
Last post: Today at 3:19:01 AM(UTC)
Lansweeper LsAgent install issue
by  Susan.A  
Go to last post Go to first unread
Last post: Yesterday at 8:46:19 PM(UTC)
Lansweeper Is a Common Table Expression possible?
by  PatrickWolf   Go to last post Go to first unread
Last post: Yesterday at 6:52:24 PM(UTC)
Lansweeper Tracking assets like docking station, mouse and keyboards
by  cycleheat  
Go to last post Go to first unread
Last post: Yesterday at 5:00:39 PM(UTC)
Lansweeper Update to V. 7.2.107.4
by  cycleheat   Go to last post Go to first unread
Last post: Yesterday at 4:57:38 PM(UTC)
Lansweeper Windows Defender AV
by  Rob B  
Go to last post Go to first unread
Last post: Yesterday at 4:55:19 PM(UTC)
Lansweeper Scan Server Scanning wrong IP range
by  wayneRex   Go to last post Go to first unread
Last post: Yesterday at 3:49:36 PM(UTC)
Lansweeper Lansweeper support levels
by  RobertB  
Go to last post Go to first unread
Last post: 1/23/2020 10:39:05 PM(UTC)