All Servers without Anti-Virus Software Audit

Discover All Servers Without Anti-Virus Software

Discover servers in your network which might be vulnerable to viruses, malware or other threats. Anti-virus software is a critical line of defense or every server and should be a priority for every IT team. This audit provides a list of servers on which no anti-virus software was detected and that require attention as soon as possible to ensure your infrastructure is fully protected. A lack of protection can lead to unexpected downtime, causing lower productivity or even ransomware attacks in the worst case

All servers without Anti-virus software

Click to Open - All Servers without Anti-Virus Software Query
Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tsysOS.OSname As OS,
  tblAssets.SP As SP,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblAssets
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
    And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
      From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
          tblSoftware.softID Inner Join tsysantivirus On
          tblSoftwareUni.softwareName Like tsysantivirus.Software) And
  tblAssets.AssetID Not In (Select tblAntivirus.AssetID
      From tblAntivirus) And tblComputersystem.Domainrole >= 2 And
  tblAssetCustom.State = 1

Audit and Take Action in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting