Sunday, May 18, 2014

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

SQL :
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

No comments:

Post a Comment