https://community.blueprism.com/t5/Product-Forum/Control-Room-Terminated-logging-SQL/m-p/110252#M49787 <P>What you see in Control Room is effectively the BPASession table joined with others (eg BPAProcess and BPAStatus) to resolve various IDs as names. There's a view called&nbsp;BPVSessionInfo that does this for you.</P> Wed, 08 May 2024 13:30:53 GMT John__Carter 2024-05-08T13:30:53Z https://community.blueprism.com/t5/Product-Forum/Control-Room-Terminated-logging-SQL/m-p/110213#M49775 <P>Hi</P><P>I want to extract the terminated processes from the database.&nbsp;</P><P>Can you help me which tables I should look into to get the process terminated which are shown in the control room? For example I am interested in looking into process terminated the last 24 hours.</P><P>I think it may be&nbsp;BPASessionLog_NonUnicode and then I have to join&nbsp;BPASession on sessionnumber, but I might be wrong. Hope you can help me.&nbsp;</P> Tue, 07 May 2024 12:33:54 GMT https://community.blueprism.com/t5/Product-Forum/Control-Room-Terminated-logging-SQL/m-p/110213#M49775 Baran999 2024-05-07T12:33:54Z https://community.blueprism.com/t5/Product-Forum/Control-Room-Terminated-logging-SQL/m-p/110252#M49787 <P>What you see in Control Room is effectively the BPASession table joined with others (eg BPAProcess and BPAStatus) to resolve various IDs as names. There's a view called&nbsp;BPVSessionInfo that does this for you.</P> Wed, 08 May 2024 13:30:53 GMT https://community.blueprism.com/t5/Product-Forum/Control-Room-Terminated-logging-SQL/m-p/110252#M49787 John__Carter 2024-05-08T13:30:53Z