Control Room Terminated logging SQL

[Baran999]

Hi

I want to extract the terminated processes from the database. 

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.

I think it may be BPASessionLog_NonUnicode and then I have to join BPASession on sessionnumber, but I might be wrong. Hope you can help me. 

[John__Carter · Accepted solution]

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 BPVSessionInfo that does this for you.