Retrieve S_SRM_TASK_HIST username from database connection
Hello,
We've had Siebel for a long time, and moved to SSO a decade or so ago. I used to be able to get the person's name/id number from S_SRM_TASK_HIST, when joining to v$session, with information that i had, specifically sid and serial#. I used this method alot, to find out who was hitting buttons on the browser screen that results in runaway queries on that database.
select SRVR_USER_NAME from SIEBEL.S_SRM_TASK_HIST
where SRVR_PROC_ID_VAL in (
select substr(process,1,instr(process,':')-1)
from v$session
where sid = :1)