Nice.  Perhaps Cisco could include this in the FAQ (nudge nudge):

http://cisco.com/en/US/products/ps6128/products_qanda_item09186a00803b7a9f.shtml#q20

Later,
Dave

Kurt Huenemann wrote:
> All,
> 
> A shortcut to getting your "count by OS" in one command:
> 
> controlsmartdb=#   select os_name,count(*)
> controlsmartdb-#     from user_info
> controlsmartdb-# group by os_name
> controlsmartdb-# order by os_name;
>     os_name     | count
> ----------------+-------
>  ALL            |     1
>  LINUX          |     4
>  MAC_ALL        |     1
>  MAC_OSX        |    11
>  WINDOWS_2K     |     4
>  WINDOWS_MCE_XP |    90
>  WINDOWS_PRO_XP |   454
>  WINDOWS_TPC_XP |     2
>  WINDOWS_XP     |     2
>  WINDOWS_XP_MCE |     1
> (10 rows)
> 
> Kurt
> 
> 
> 
> At 10:19 AM 1/18/2007, Howard Speight wrote:
> 
>> controlsmartdb=# select count(*) from user_info WHERE
>> os_name='WINDOWS_PRO_XP';
>>  count
>> -------
>>   2903
>> (1 row)
> 
> 
> 
> ____________________________________________________
> Kurt E. Huenemann '83
> Assoc. Vice President for Information Resources
> Asst. Professor of Computer Science
> Heidelberg College
> 310 East Market Street
> Tiffin, OH 44883
> 
> Internet: [log in to unmask]
> Fax:      419-448-2176
> Voice:    419-448-2351
> 
> Engaging Students.  Creating futures.
> ____________________________________________________