SCCM SQL Query :To Get Hostname Of Client Machines With McAfee Virus Scan Installed

SCCM SQL Query :To Get Hostname Of Client Machines With McAfee Virus Scan Installed

By San - September 21, 2014

Select

SD.Name0,

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 SD.Name0, PF.DisplayName0, PF.Version0

Order By SD.Name0

Comments