PRUEBA AHORA

All Workstations Without Antivirus Software Audit

Security Software

Find All Computers Without Antivirus Software in Your Network

List all workstations without antivirus software in your network to verify your network’s security and make sure that all workstations are secured. Antivirus software is crucial for businesses as computers without them they are the easy targets for any kind of cyber attack. Knowing exactly which workstations are not safe is critical in the defense of your environment. With this audit, you can easily identify which assets still require your attention. Workstations without anti-virus

All Workstations Without Antivirus 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
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
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 <= 1 And
  tblAssetCustom.State = 1
Order By tblAssets.AssetName

Show

Hide