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

 

This SQL query was written as a request from a reader wanting to know how to count the number of machines that have McAfee VirusScan Enterprise installed by using the Add And Remove Programs applet.

 

SQL Query:

 

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

 

To see the machine names rather than the counts use this query:

 

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

 

 

 

Published Sunday, June 29, 2008 7:20 AM by dhite
Filed under:

Comments

No Comments