Hi Phill,

Thanks for the reply. I have a few minor issues with the screen (in EE 2017 it only displays 8 chars of the users session id) but more importantly, it doesn't link to a PTS # (which is what we get when the lock occurs).

I did notice that there is a login time, and I guess we could use some combination of login time and program to try and figure out which session it is. I was just hoping there was an easier way (like if this table contained pts # :P).

Thanks,

I Jamal

You can create simple browse from tables mon_mstr and _Connect (key is mon__qad01 = _Connect_Usr). In field _Connect-Device you will get pts number for user session. In field mon_userid is user ID and in field mon_program you will find which program runs user.

Add also filter _Connect-Device <> 'batch' to prevent display all batch sessions.

Thanks Tomaz. That helped quite a bit. For EE 2017 the fields are slightly different, but I was able to figure it out using the info you provided. For anyone who finds this through seaching, the field in mon_mstr is now mon__qadi01 in EE 2017. _Connect-Device contains the pts #.

FOR EACH mon_mstr NO-LOCK,
FIRST _Connect NO-LOCK
WHERE _Connect._Connect-Usr = mon__qadi01
AND _Connect._Connect-Device <> 'batch':
DISPLAY mon__qadi01 mon_userid _Connect._Connect-Device.
END.