JMast
Reputable Poster
Hello,
We used sys.sysprocesses in SQL Server in 8.0 (all fat client) to do a "scrape" of the users connected to the database every half hour. This provided us a good snapshot without the clutter of F9312.
We are now on 9.1 and I am wondering if there is a way to capture the same info. There isn't anything I can find on the database since it all comes through the webservers. Is there a way to tap into whatever the "User sessions" runtime metric is pulling on the web server? Is that a weblogic function or a JDE app that might be reported against?
Is there another way to get that info? We want to have an understanding of who actually is using the system throughout the day so we can evaluate requests for new users.
Thanks for the help,
Jer
We used sys.sysprocesses in SQL Server in 8.0 (all fat client) to do a "scrape" of the users connected to the database every half hour. This provided us a good snapshot without the clutter of F9312.
We are now on 9.1 and I am wondering if there is a way to capture the same info. There isn't anything I can find on the database since it all comes through the webservers. Is there a way to tap into whatever the "User sessions" runtime metric is pulling on the web server? Is that a weblogic function or a JDE app that might be reported against?
Is there another way to get that info? We want to have an understanding of who actually is using the system throughout the day so we can evaluate requests for new users.
Thanks for the help,
Jer