Hey Kurt,

If you are using 4.1.x, you can use the Silent Audit feature to get the
info.
This way the users wont even see any end screens.

The report can also be run per package with 4.1.x

-Prem 

-----Original Message-----
From: Cisco Clean Access Users and Administrators
[mailto:[log in to unmask]] On Behalf Of Kurt Huenemann
Sent: Friday, April 27, 2007 12:14 PM
To: [log in to unmask]
Subject: how to report on AS program in use?

Good day all,

I would like to determine how many of our NAC users have a particular
Anti-Spyware package installed.  We have an 'optional' requirement
checking if WebRoot SpySweeper is installed, so it gets reported on the
CAM "Reports" tab, and we offer it as a download if the user does not
have it.

I'm ready to renew the license for SpySweeper, so I'm wondering who
really uses it.

Something like this should work:

  controlsmartdb=# select dm_user,dm_mac,dm_os,report_text
  controlsmartdb-#   from dm_report
  controlsmartdb-#  where report_text like '%Sweeper%';

but of course report_text is a huge field that is difficult to work
with, and I'm not sure how to select if the test was successful or not.

Can anyone suggest a 'tidy' way to see what A-S package the user
actually has?

Thanks in advance!

Kurt


--
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.