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.
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