Find users who are connected to PeopleSoft application using Application Designer

find_app_designer_connections.sql

-- Find users who are connected to PeopleSoft application using Application Designer
set linesize 200
select p.spid,
substr(s.osuser,1,10) osuser,
substr(s.username,1,8) username,
substr(s.program,1,24) program,
substr(s.client_info,1,60) ClientInfo
from v$session s, v$process p
where s.paddr=p.addr
and s.osuser is not null
and s.program='pside.exe'
order by s.osuser;