SCCM SQL Query : To Count The Number Of Client Machines With McAfee Virus Scan Installed

SCCM SQL Query : To Count The Number Of Client Machines With McAfee Virus Scan Installed

By San - September 21, 2014

Select

Count(SD.Name0) Counts,

PF.DisplayName0,

PF.Version0

From v_Add_Remove_Programs PF

Join v_R_System SD on PF.ResourceID = SD.ResourceID

Where PF.DisplayName0 = ‘McAfee VirusScan Enterprise’

Group By PF.DisplayName0, PF.Version0

Order By Counts, PF.Version0

Comments