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;
Thank You for sharing
ReplyDeleteNice blog thanks for sharing
ReplyDeleteSeleniumTesting in Pune
It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
ReplyDeletehttp://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/