Find Servers with Anti-Virus Installations
Discover Dall servers in your network along with their anti-virus details. This audit lists exactly which servers in your environment have anti-virus software installed on them and are safe. Additional details like the version of the anti-virus software installed are also included in the report. The model, manufacturer, operating system and additional details are also included in the overview. With the filtering and sorting options, you can easily find specific servers you are looking for at take a look at more details.
All Servers with Anti-Virus Query
Select Top 1000000 unioned.assetid, tblAssets.AssetName, tsysOS.Image As icon, unioned.software, unioned.version, unioned.Enabled, unioned.Uptodate, unioned.RetrievedFrom, 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 ((Select a.assetid As assetid, a.software As software, a.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) a) 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)) unioned Inner Join tblAssetCustom On unioned.assetid = tblAssetCustom.AssetID Inner Join tblAssets On tblAssets.AssetID = unioned.assetid Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID Where tblComputersystem.Domainrole >= 2 And tblAssetCustom.State = 1 Order By tblAssets.AssetName