For OOB mode you will do the same thing from the oob_user_info table

-PA 

-----Original Message-----
From: Perfigo SecureSmart and CleanMachines Discussion List
[mailto:[log in to unmask]] On Behalf Of Lanstein, Alex C
Sent: Tuesday, October 03, 2006 12:05 PM
To: [log in to unmask]
Subject: Re: Gathering information from servers

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