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;