os_name     | count
----------------+-------
 LINUX          |     2
 MAC_ALL        |     1
 MAC_OSX        |    87
 WINDOWS_2003   |     5
 WINDOWS_2K     |    14
 WINDOWS_95     |     1
 WINDOWS_98     |     3
 WINDOWS_ALL    |     3
 WINDOWS_MCE_XP |   377
 WINDOWS_ME     |     3
 WINDOWS_PRO_XP |  1248
 WINDOWS_TPC_XP |    14
 WINDOWS_XP     |   168
(13 rows)

I know... the 9x and ME machines are painful to see...

Simon

>>> "King, Michael" <[log in to unmask]> 01/18/07 10:54 AM >>>
I think that will fit on a single line, he might have broken it up for
clarity sake

select os_name,count(*) from user_info group by os_name order by
os_name; 

> -----Original Message-----
> From: Cisco Clean Access Users and Administrators 
> [mailto:[log in to unmask]] On Behalf Of Speight, Howard
> Sent: Thursday, January 18, 2007 10:50 AM
> To: [log in to unmask]
> Subject: Re: Vista
> 
> Oh that works like a charm, thanks for posting! Definitely 
> going in my tips notebook...  :-)
> 
> [root@rhcam1 ~]# psql -h 127.0.0.1 -U postgres controlsmartdb 
> Welcome to psql 8.1.3, the PostgreSQL interactive terminal.
> 
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help with psql commands
>        \g or terminate with semicolon to execute query
>        \q to quit
> 
> controlsmartdb=# select os_name,count(*) controlsmartdb-# 
> from user_info controlsmartdb-# group by os_name 
> controlsmartdb-# order by os_name;
>     os_name     | count
> ----------------+-------
>  ALL            |     2
>  LINUX          |     3
>  MAC_OSX        |   322
>  WINDOWS_2003   |     2
>  WINDOWS_2K     |     9
>  WINDOWS_MCE_XP |   561
>  WINDOWS_PRO_XP |  2878
>  WINDOWS_TPC_XP |    31
> (8 rows)
> 
> 
> 
> -----Original Message-----
> From: Cisco Clean Access Users and Administrators 
> [mailto:[log in to unmask]] On Behalf Of Kurt Huenemann
> Sent: Thursday, January 18, 2007 10:38
> To: [log in to unmask]
> Subject: Re: Vista
> 
> 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.
> ____________________________________________________
>