TimRiedel607946

DB Client State

Discussion created by TimRiedel607946 on Sep 5, 2016
Latest reply on Sep 6, 2016 by TimRiedel607946
Hello,

I have the following problem:
I want to get the states of the clients of a system from the DB, but I can't figure out how to get this information.

My query is:

   SELECT OH_CLIENT, OH_TITLE
   FROM UC4.OH
   WHERE OH_OTYPE = 'CLNT' AND OH_NAME != 'CLNT'
   ORDER BY OH_CLIENT ASC;

This gives me all clients. To get the state of the clients I tried to use OH_Inactive, all columns of the table MAND and something with the end time / return code from the table AH, but nothing worked.

Can you give me a query, which contains the information or at least a hint in which tables I could search?

I searched for the problem in this forum and I'm very sorry, if I missed a discussion with this topic.

Thanks a lot

Tim

Outcomes