>>>>What would be really great is to pull total users online
 
Supported (cisco) way is this:
send a POST of op=getuserinfo&qtype=all&qval= in whatever language you want then parse up the output.  
It gets returned in this format
IP=123.123.123.123,mac=00:90:F1:45:09:1A,NAME=user_login,PROVIDER=LDAP, etc,ROLE=Students, Faculty, etc,ORIGROLE=1, or # if applicable,    [6] => VLAN=X,NEWVLAN=blank, or # if applicable,WINDOWS_XP, etc
You could probably get what cas they are on by doing a JOIN on one of the tables, but that isn't supported.  
Unsupported (sql) way is this:
function cam_get_number_of_users_logged_in()
{
    $query = 'SELECT ss_key FROM user_info';
    $result = pg_query($query) or die('Query failed: ' . pg_last_error());
    $count = pg_num_rows($result);
    pg_free_result($result);
    return $count;
}
------
Btw, the "online users" are only a valid representation of online users for In Band mode.  

________________________________

From: Perfigo SecureSmart and CleanMachines Discussion List on behalf of John Truelove
Sent: Tue 10/3/2006 8:26 AM
To: [log in to unmask]
Subject: Gathering information from servers


Has anyone found a way to pull information from the CAMs relating to users, OS's, etc. so that it could
be used with monitoring applications (Cacti through SNMP or script) ?
 
With all of this talk about slow logins and servers being maxed out, I started looking into users per server, etc.
But this morning device lists was cleared so I will have to wait.
 
It would be nice to graph that information.  I am already pulling information for CPU, Memory, NIC, and Disk for all of my CAM / CAS.
 
What would be really great is to pull total users online, total users per CAS 1, 2, and 3.  Then put all of this information into 1 graph
that would be gathered and display from Cacti.
 
Am I dreaming here :-)
 
Any information that anyone can provide would be great.
 
Thanks
 
 
 
 
John Truelove
OIT Network Engineer - CCNP
Indiana State University
210 N 7th Street, Rankin Rm 54
Terre Haute, IN 47809
812-237-4921

*******************************************************************************************************************************************************
This email, and any attachments, thereto, is intended only for use by the addressee(s) named herein and may contain privileged 
and/or confidential information.  If you are not the intended recipient of this email, you are hereby notified that any dissemination, 
distribution or copying of this email, and any attachments thereto, is strictly prohibited.
*******************************************************************************************************************************************************