→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Bart_M
Lansweeper Alumni
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
0 REPLIES 0

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now