Hey folks,

Not intending to interfere with Michael's good intentions here, but I
think a recommended approach from Cisco Support perspective would be to
use our API to grab this information.

You can use "getuserinfo" and also "getreports" API to periodically
interrogate the CAM for this information.
This API will be enhanced and maintained over a period of time.

See attached!

Regards
Prem

-----Original Message-----
From: Cisco Clean Access Users and Administrators
[mailto:[log in to unmask]] On Behalf Of Dennis Xu
Sent: Wednesday, November 07, 2007 1:18 PM
To: [log in to unmask]
Subject: Re: CCA Reporting about OS Service Pack

Michael,

I would like to see the sample sql too. Thanks!

Dennis Xu
Network Analyst(CCS)
University of Guelph
5198244120 x 56217
[log in to unmask]

-----Original Message-----
From: Cisco Clean Access Users and Administrators
[mailto:[log in to unmask]] On Behalf Of Speight, Howard
Sent: November-07-07 4:14 PM
To: [log in to unmask]
Subject: Re: CCA Reporting about OS Service Pack

I'm already auditing two registry keys, I'd like to see the sample sql,
perhaps a zip file posted to the list? 

-----Original Message-----
From: Cisco Clean Access Users and Administrators
[mailto:[log in to unmask]] On Behalf Of Michael Grinnell
Sent: Wednesday, November 07, 2007 15:49
To: [log in to unmask]
Subject: Re: CCA Reporting about OS Service Pack

In 4.1 you can create an Audit rule that will silently capture the
information.  From there, you can grab the info from the reports table.
I can send you some sample SQL if you would like.  You will probably
need to crank your reports retention up beyond the default 50,000 if you
want any kind of historical reporting.


Michael Grinnell
Network Security Administrator
The American University


On Nov 7, 2007, at 3:39 PM, Dennis Xu wrote:

> Is there a way to get the report about how many users are running 
> Windows XP SP1 and SP2?
>
>
>
> Dennis Xu
>
> Network Analyst(CCS)
>
> University of Guelph
>
> 5198244120 x 56217
>