SMI query for onstat - g opn (open tables)

I'm trying to write an SMI query similar to "onstat - g opn" which shows open tables for each user thread. But, I want to see the username, database name, and tablename instead of thread ID and table partnumber in hex!!! I can't seem to track down the columns that I need in the SMI tables to do this. I can link the thread ID, session ID, and username easily enough, but where are the open tables coming from? Thanks in advance, Jeff Larsen larsen@qec.com