SonicGT

Has anyone written a query to show say which programs from add/remove programs exist on say 80% or something of all pc's?

I'm trying to determine the most common applications in my environment.

Thanks

__________________
----
Visit my personal site
http://www.windycitystangs.com

artusod

Hi,
Something like this? Just change the 60 to whatever percentage you want.

Select [name],(Cast(Count([name])asfloat)/Cast((selectcount(*)from vComputer)asfloat))* 100 As'% installed'
from AeXInv_AeX_OS_Add_Remove_Programs
Groupby [name]
Having(Cast(Count([name])asfloat)/Cast((selectcount(*)from vComputer)asfloat))* 100 > 60
Orderby'% installed'

Dan