cancel
Showing results for 
Search instead for 
Did you mean: 

Control Room Terminated logging SQL

Baran999
Level 2

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. 

1 BEST ANSWER

Helpful Answers

John__Carter
Staff
Staff

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.

View answer in original post

1 REPLY 1

John__Carter
Staff
Staff

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.