→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !
‎11-06-2012 10:35 AM
Solved! Go to Solution.
‎09-24-2013 04:23 PM
‎09-24-2013 05:39 PM
‎09-24-2013 04:23 PM
‎09-23-2013 01:45 PM - last edited on ‎12-02-2022 01:34 PM by Mercedes_O
In the absence of Lansweeper updating I have written this report SQL which should hopefully help others in the same position as described above. It will show all PCs without AntiVirus and any PCs with Windows Defender with realtime scanning turned off. Please note that I don't know if this definitely works on Vista as I don't currently have a machine to test with but it works perfectly on my Windows 8 boxes and Windows 7 boxes (Mix of defender, Security Essentials and Symantec).
Goto: Configuration > Custom Scanning
Choose Add registry key to scan
Rootkey: HKEY_LOCAL_MACHINE
RegPath: SOFTWARE\Microsoft\Windows Defender\Real-Time Protection
RegValue: DisableRealtimeMonitoring
Then either create a new report or edit the existing AV report with the below SQL.
Reports accessed via Dashboard > All Reports (or report builder)
Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Description,
tblAssets.Lastseen,
tblAssets.AssetName,
tsysOS.Image As icon
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
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
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
tblRegistry.AssetID From tblRegistry
Where
tblRegistry.Regkey =
'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows Defender\Real-Time Protection' And tblRegistry.Valuename = 'DisableRealtimeMonitoring' And tblRegistry.Value != '1')) And tblComputersystem.Domainrole < 2 And tblAssetCustom.State = 1
Order By tblAssets.AssetName
‎06-07-2013 04:44 PM
‎06-06-2013 06:38 PM
‎05-16-2013 11:05 AM
‎11-07-2012 03:12 PM
‎11-07-2012 03:13 PM
MartinT wrote:
However, you may need to consider what you detect in future as more and more W8 client machines appear and will be reported by Lansweeper as having no anti-virus, which is incorrect.
‎11-07-2012 03:02 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now