2 weeks ago
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.
Answered! Go to Answer.
2 weeks ago
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.
2 weeks ago
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.