Asset: Antivirus Disabled (Built-in)

[Bart_M]

List of active windows assets where antivirus software is disabled

Meets all of the following criteria:
- Windows asset
- Active asset

Sorted on:
- Asset name

Select Top 1000000 (tblAssets.AssetID),
  tblAssets.AssetName,
  tsysOS.OSname As OS,
  (tblAssets.IPAddress),
  (tblAssets.Lastseen),
  (tblAssets.Lasttried),
  (tblAntivirus.DisplayName) As Antivirus,
  tsysOS.Image As icon
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblAntivirus On tblAssets.AssetID = tblAntivirus.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1 And tblAssets.AssetID Not In (Select Distinct
    tblAntivirus.AssetID From tblAntivirus
  Where tblAntivirus.onAccessScanningEnabled <> 0)
Order By tblAssets.AssetName