Find All Computers with Antivirus Software Enabled on Your Network
List all workstations with 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 they are the primary target for any kind of cyber attack. Knowing exactly which workstations are safe is critical in the defense of your environment.
All Workstations with Antivirus Software Query
Select Top 1000000 AntiVirus.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,
AntiVirus.Software,
AntiVirus.Version,
AntiVirus.Enabled,
AntiVirus.UpToDate,
AntiVirus.RetrievedFrom
From ((Select SoftwareComparison.AssetID As AssetID,
SoftwareComparison.Software As Software,
SoftwareComparison.Version As Version,
'Software Comparison' As RetrievedFrom,
'' As Enabled,
'' As UpToDate
From (Select tblSoftware.AssetID As AssetID,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version
From tblSoftware
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tsysantivirus On tblSoftwareUni.softwareName Like
tsysantivirus.Software) As SoftwareComparison)
Union
(Select tblAntivirus.AssetID As AssetID,
tblAntivirus.DisplayName As Software,
Null As Version,
'WMI' As RetrievedFrom,
Case When tblAntivirus.onAccessScanningEnabled = 1 Then 'Yes' Else 'No'
End As Enabled,
Case When tblAntivirus.productUpToDate = 1 Then 'Yes' Else 'No'
End As UpToDate
From tblAntivirus)) AntiVirus
Inner Join tblAssetCustom On AntiVirus.AssetID = tblAssetCustom.AssetID
Inner Join tblAssets On tblAssets.AssetID = AntiVirus.AssetID
Inner Join tsysIPLocations On tblAssets.LocationID =
tsysIPLocations.LocationID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblDomainroles On tblComputersystem.Domainrole =
tblDomainroles.Domainrole
Inner Join tblState On tblAssetCustom.State = tblState.State
Where tblDomainroles.Domainrolename In ('Stand-alone Workstation',
'Member Workstation') And tblState.Statename = 'Active'
Order By tblAssets.Domain,
tblAssets.AssetName,
AntiVirus.Software
