Jaziar
asked on
Who is currently logged ON?
Is there a way where you can hit a action button or run a agent that will tell you what users are logged on to the database at that moment in time?
Jaziar
One way i could think of is to call a script in the DAtabase QueryOPen and record the users in a particular document., Actually we did it for one of the applications, as we wanted the info who were accesing the database.
It's a simple lotusscript code, which if you want i will write it and give it to u.
Partha
One way i could think of is to call a script in the DAtabase QueryOPen and record the users in a particular document., Actually we did it for one of the applications, as we wanted the info who were accesing the database.
It's a simple lotusscript code, which if you want i will write it and give it to u.
Partha
Well, though I concur with Sjef, I would consider anyone with a session to be "logged on" for a particular server, so SHOW USERS works for me. It also shows what databases they have open.
If your server is clustered, by the way, you can take a database out of service.
If your server is clustered, by the way, you can take a database out of service.
Guys
I believe jaziar is talking abt ppl who have logged on to a 'particular database' or is my rumbles mixed up here?
Partha
I believe jaziar is talking abt ppl who have logged on to a 'particular database' or is my rumbles mixed up here?
Partha
Hi bro,
There is also a QueryClose event, but whether it will be called when you bluntly shutdown the Notes-client I don't know. I'm afraid it isn't called. So you cannot record begin and end of a user session, so it's very difficult to know who currently uses the db.
Sjef
There is also a QueryClose event, but whether it will be called when you bluntly shutdown the Notes-client I don't know. I'm afraid it isn't called. So you cannot record begin and end of a user session, so it's very difficult to know who currently uses the db.
Sjef
It will be called Bro, i have done like this. WHen you directly close notes also, queryclose event of database will be called
Partha ;-)
Partha ;-)
Bro,
So you can block closing a database and closing Notes by setting Continue to False? Notes will never close then? Heavy implications! Will check this!!
Sjef
So you can block closing a database and closing Notes by setting Continue to False? Notes will never close then? Heavy implications! Will check this!!
Sjef
You can never close it bro.. :)
Partha
Partha
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Bro, you win :(
how about
consoleReturn$ = notesSession.SendConsoleCo mmand( serverName$, consoleCommand$ )
(if you have R6, that is)
An alternative, is check the views in log.nsf (eg. Database\Usage) It won't give you a really "realtime" overview (some delay), but it's something that you can work with .
So an actionbutton could do a quick lookup in Database\Usage and you would know who is logged in (using) the database.
Tom
consoleReturn$ = notesSession.SendConsoleCo
(if you have R6, that is)
An alternative, is check the views in log.nsf (eg. Database\Usage) It won't give you a really "realtime" overview (some delay), but it's something that you can work with .
So an actionbutton could do a quick lookup in Database\Usage and you would know who is logged in (using) the database.
Tom
Jaziar
Any progress on this
Partha
Any progress on this
Partha
Thx jaziar for the points :)
Partha
Partha
As far as I know, there is no such thing. There even are no real sessions in the sense that logging out breaks a session. You just en communicating with a server. It's all based on Remote Procedure Calls. You can see some tracking in the log db if you enabel session logging, but that won't give you the info you want. Also, typing SHOW USERS on the server's console will inform you about users, but they might all have gone. Sessions will be terminated by Notes after a timeout period.
Cheers!
Sjef