Microsoft Defender AV mode device count
Description
'Provides the Anti virus mode and device count falling under that AV mode.'
Query · kql
DeviceTvmInfoGathering | extend AvMode = iif(tostring(AdditionalFields.AvMode) == '0', 'Active', iif(tostring(AdditionalFields.AvMode) == '1', 'Passive',iif(tostring(AdditionalFields.AvMode) == '2', 'Disabled', iif(tostring(AdditionalFields.AvMode) == '5', 'PassiveAudit',iif(tostring(AdditionalFields.AvMode) == '4', 'EDR Blocked' ,'Unknown'))))) | summarize DeviceCount = count() by AvMode