Sagar, Not sure if native Remedy does this, - but look at the snmp and mib file.
however, we used IBM infosphere guardium, 1. How many users has logged in to remedy server? Currently Application User translation for guardium cannot tell specifically which user is logged in, only the app id. 2. How many forms have been modified by users? You can monitor tables/schemas, for sql procedure calls. 3. How many session that users has started at remedy server?Currently Application User translation for guardium cannot tell specifically which user is logged in, only the app id. 4. How many users have been logged into UNIX box?Now, if you users are logging into the unix server (putty/sqlpus), and acting on the daabase, then the tool should be OS User, DB User, Source Program, full sql. Howeever, if thru, the application, then dbuser = remedy application id. 5. Is there any Back up activity happening on any of the production remedy servers ?sql procedure calls and full sql will lat you know if the backs are running, or source programs like Rman, etc. 6. At UNIX level check how many process running currently and which process taking long time and too much memory? Guardium cannot to this , but use i think, (will need to check with Monitoring team).. nmon with another tool.... Hope this helps, dee _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

