Shane_Meek_183

How to find the user who last started a particular client:

Discussion created by Shane_Meek_183 on Oct 30, 2014
Latest reply on Oct 30, 2014 by Shane_Meek_183
There may be other ways to do this, but one way I just learned is to take a look at the UC_CLIENT_SETTINGS variable in a given client and look at the CLIENT_STATUS key. Example below:

CLIENT_STATUS  |  GO;0001040008;2014-10-30

The GO is the current status of the client, the third value is the date it was last started (in this case, Oct 30, 2014). The middle value is the oh_idnr value of the user who last started the client, the username associated with that idnr can be returned from the db. 

Example: select * from oh where oh_idnr = 1040008

Outcomes