1.19 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;