Who's logged in to OneWorld?

Who\'s logged in to OneWorld?

What table can I query to see what users are logged into OneWorld or who have logged in recently?

I know I can do this from the SAW, but our setup doesn't allow all users access to the SAW and I need this information from time to time when I'm not near a workstation with SAW installed.

Besides, I'm just curious.

Thanks in advance.

Re: Who\'s logged in to OneWorld?

Tim

The table F00960 shows the last time a machine was logged on and who the user was. It won't tell you if they are still logged on but it is a useful tool. I added P00960 to my GH9083 menu.

Patty

Re: Who\'s logged in to OneWorld?

Excellent, that is what I was looking for. Thanks very much.

RE: Who\'s logged in to OneWorld?

Hello, Tim,
I know the answer for the Oracle; you might find something similar in MS
SQL.
I use either "SELECT * from V$SESSION;" or shorter "select OSUSER, MACHINE
from v$session where username='JDE';"

Regards, Alex Shevchenko

XE SP18 Oracle 8.1.7, Solaris production
XE SP18 Oracle 8.1.7, Solaris test

Re: Who\'s logged in to OneWorld?

This is going at looking at current connections from the database side (Oracle in our case). I use a script with the following command to find out which workstations are connected to our Oracle database:

select distinct terminal from v$session;

I see you're both Oracle and SQL Server -- maybe there's a table like v$session for the SQL Server.

Re: Who\'s logged in to OneWorld?

If you've got

History=1 under security on you server INI

you can see this information from USER SECURITY under the Form row exit