Wednesday, September 25, 2019

List of users connected to client tools



SELECT c.cnx_id,
  SUBSTR(u.name,1,30),
  SUBSTR(c.login_time,1,20),
  SUBSTR(c.app_name1,1,20),
  SUBSTR(c.host_name,1,25),
  c.host_port
FROM opb_client_conn c,
  opb_user_group u
WHERE c.login_id                                  =u.id
AND to_date(SUBSTR(login_time,1,10),'mm/dd/yyyy')!=trim(sysdate)
AND app_name1 IN ('Designer' ,'Workflow Manager' , 'Workflow Monitor', 'Repository Manager')
ORDER BY Host_name,
  app_name1,
  Login_time;



3 comments:

  1. Thank You for sharing

    ReplyDelete
  2. Iam not understand the user connect tools that you have provided.This code is very complicated for me because,my profession is to write an assignmnts to help the students and also I have provided exam helper service to help for those students who have been difficulties to write assignment on the given deadline.

    ReplyDelete