Notification

Icon
Error

Workstations with No AV

Posted: Thursday, June 25, 2020 8:36:11 AM(UTC)
daveyh

daveyh

Member Original PosterPosts: 5
0
Like
The built in report has started to produce some false positives. We use McAfee ENS, and in the Anti Virus list we have included 'McAfee Threat Protection' as that is the component we are looking for. There are several machines listed each day in the report, but when I check them they have McAfee installed and it is working correctly. The Lansweeper properties page for the Workstation also lists AV is installed.

As far as I am aware, the report hasn't been edited. Can a copy of the original report code be posted so I can compare this with ours?
brodiemac-too
#1brodiemac-too Member Posts: 22  
posted: 7/29/2020 7:44:53 PM(UTC)
Here's our. So far as I know, it has not been edited.
Code:
Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tblDomainroles On tblDomainroles.Domainrole =
    tblComputersystem.Domainrole
Where tblAssets.AssetID Not In (Select tblAntivirus.AssetID
      From tblAntivirus) And tblState.Statename = 'Active' And
  tblDomainroles.Domainrolename In ('Stand-alone Workstation',
  'Member Workstation')
Order By tblAssets.Domain,
  tblAssets.AssetName

Active Discussions

Lansweeper Email to close ticket
by  wgonzalez_hope   Go to last post Go to first unread
Last post: Yesterday at 3:54:01 PM(UTC)
Lansweeper Mass update assets through csv
by  B.L.  
Go to last post Go to first unread
Last post: Yesterday at 3:30:21 PM(UTC)
Lansweeper Restrict the access to the knowledgebase
by  ABEAL   Go to last post Go to first unread
Last post: Yesterday at 1:38:25 PM(UTC)
Lansweeper Wake on Lan Issues
by  Christophe  
Go to last post Go to first unread
Last post: Yesterday at 1:09:12 PM(UTC)
Lansweeper Reason: No email address found for the following user
by  Juha Otava   Go to last post Go to first unread
Last post: Yesterday at 9:59:41 AM(UTC)
Lansweeper Windows 10 Upgrade to 2004
by  CyberCitizen  
Go to last post Go to first unread
Last post: Yesterday at 8:47:16 AM(UTC)
Lansweeper Scanning despite exclusion
by  pskup   Go to last post Go to first unread
Last post: Yesterday at 7:27:08 AM(UTC)
Lansweeper Export ticket to CSV
by  KeithBecker  
Go to last post Go to first unread
Last post: 8/13/2020 5:56:10 PM(UTC)