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. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    http://chennaitraining.in/building-estimation-and-costing-training-in-chennai/
    http://chennaitraining.in/embedded-systems-training-in-chennai/
    http://chennaitraining.in/vlsi-training-in-chennai/
    http://chennaitraining.in/matlab-training-in-chennai/
    http://chennaitraining.in/iot-training-in-chennai/

    ReplyDelete