usr number

Posted by cjbree on 06-Jan-2020 11:38


Hello,

My question is: How can i see which client has which usr number.

Explanation:

concerns Progress OpenEdge, Release 11.7.1, windows OS.
A user can start multiple clients in our application. We have a problem if we want to kill a specific client.
Via os-command "proshut d:\Projects\GOBS\Data\GOBS -C list > User_List_GOBS.txt"
we get an overview of which users are there with which clients (GOBS = database name "):

----------------------------------------------------------------------------------------
usr    pid    time of login           user id     Type  tty                  Limbo?
  5    988 Sat Dec 14 16:23:23 2019   DB_Agent    OEMA  batch                no     
  6  14300 Sat Dec 14 16:23:23 2019   SYSTEM      WDOG  batch                no     
 14  13140 Wed Dec 18 17:21:28 2019   mwstri      REMC  ALG-CAPE-PRGRS       no     
 15   3212 Fri Dec 20 10:00:16 2019   mcappe      REMC  ALG-CAPE-PRGRS       no     
 16  13036 Fri Dec 20 09:53:59 2019   mcappe      REMC  ALG-CAPE-PRGRS       no     
 18  19180 Mon Dec 16 12:39:02 2019   mwstri      REMC  ALG-CAPE-PRGRS       no     
 20  12504 Mon Jan  6 07:55:22 2020   wptaal      REMC  ALG-CAPE-PRGRS       no     
 21  13708 Thu Jan  2 17:46:54 2020   cjbree      REMC  ALG-CAPE-PRGRS       no     
 22   9884 Thu Jan  2 17:46:53 2020   cjbree      REMC  ALG-CAPE-PRGRS       no     
 23  16084 Thu Dec 19 19:41:05 2019   cjbree      REMC  ALG-CAPE-PRGRS       no     
 24   3024 Thu Dec 19 22:30:03 2019   Administrator REMC  ALG-CAPE-PRGRS       no     
 25  14604 Mon Jan  6 08:15:21 2020   dzeege      REMC  ALG-CAPE-PRGRS       no     

----------------------------------------------------------------------------------------

Here 3 users have multiple clients open (user IDs "cjbree" / "mwstri" / "mcappe")

with
FOR EACH _UserIO:
 DISP _UserIO.
END.
we can see this too. NAME is the username and USR is the number which is also available when running the above proshut command

With
FOR EACH _Connect:
 DISP _Connect.
END.

we get the same NAME and also the usr  number, but here it;s named USER-ID.

If we use DISP USER in a procedure editor we get the current NAME

So the question: how do we get the current USR or the current  _UserIO.USR?


thanks in advance

Posted by George Potemkin on 06-Jan-2020 11:46

> how do we get the current USR or the current  _UserIO.USR?

FIND FIRST DICTDB._MyConnection NO-LOCK.
DISPLAY DICTDB._MyConnection._MyConn-UserId.

All Replies

Posted by George Potemkin on 06-Jan-2020 11:46

> how do we get the current USR or the current  _UserIO.USR?

FIND FIRST DICTDB._MyConnection NO-LOCK.
DISPLAY DICTDB._MyConnection._MyConn-UserId.

Posted by cjbree on 06-Jan-2020 11:51

thanks for the quick answer. this is what we need !

This thread is closed