Get list of users logged on to database
I can access the list of users in our database manually by going into the jmx-console, into an ejb then invoke java.land.string printDetails(). This gives me a nice page of data.
Can i do this programatically? I want the users to be able to see a list of who is logged on, so if we are running out of licences and someone has left themselves conected and gone for lunch they can be booted out.
Would it be possible to write this data to a text file every 5 minutes and then I can pick up the text file and look at it?