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;



2 Comments:

At 9/25/2019 , Blogger Rajasekar said...

Thank You for sharing

 
At 10/09/2019 , Blogger Paras Arora said...

Nice blog thanks for sharing
SeleniumTesting in Pune

 

Post a Comment

Subscribe to Post Comments [Atom]

<< Home