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: 455  
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 snmp trap HP 1910 switch
by  info   Go to last post Go to first unread
Last post: Today at 11:52:17 AM(UTC)
Lansweeper Lsagent cloud relay changes the scanserver value
by  ghelpdesk  
Go to last post Go to first unread
Last post: Today at 2:45:11 AM(UTC)
Lansweeper Is there a chance to get the firewall off via Lansweeper?
by  RedWood   Go to last post Go to first unread
Last post: Yesterday at 11:23:31 PM(UTC)
Lansweeper Not working Wake on Lan
by  RedWood  
Go to last post Go to first unread
Last post: Yesterday at 11:17:33 PM(UTC)
Lansweeper Wake on Lan Issues
by  RedWood   Go to last post Go to first unread
Last post: Yesterday at 11:06:12 PM(UTC)
Lansweeper New Web Interface
by  anpatterson03  
Go to last post Go to first unread
Last post: Yesterday at 10:05:19 PM(UTC)
Lansweeper LsAgent failing - Lansweeper SSL Expired
by  nlertn-PRE   Go to last post Go to first unread
Last post: Yesterday at 9:34:12 PM(UTC)
Lansweeper Outgoing help desk mail
by  KeithBecker  
Go to last post Go to first unread
Last post: Yesterday at 6:03:27 PM(UTC)