Subject: | |
From: | |
Reply To: | |
Date: | Fri, 27 Apr 2007 15:57:26 -0400 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
yeah looks like you have it right
SELECT count(distinct dm_mac) FROM dm_report WHERE report_text like '%Sweeper%'
not sure how far back the reports table goes, but the number of reports in the table divided by the total number of distinct dm_mac should give you a descently accurate average
Regards,
Alex Lanstein
Senior Software Engineer, Transitional Data Services
Help Desk/Network Junkie, Connecticut College
BOFH, LBCCHosting
860-625-4277
[log in to unmask]
________________________________
From: Cisco Clean Access Users and Administrators on behalf of Kurt Huenemann
Sent: Fri 4/27/2007 3:13 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.
|
|
|