Extracting chat history from Sametime 9 advanced chat rooms

HCL Sametime Sametime Forum
,
1

Hi,

I'm wondering if its possible to extract chat history from the Sametime 9 advanced chat rooms residing on DB2. I know it's old, out of support, but we are now trying to shut it down but some chat room owners want to save the chat history, and doing it from the GUI is a nightmare, aka you need to copy 100 entrys at a time and step into page after page. copying and pasting it manually.

So I would hope a DB2 guru could point me if it's possible or not.

Best Regards,

Pierre

2

Is there noone who can tell me the data modell of sametime in DB2? or hint me to how to create a sql query?

3

Hi Pierre --

There's probably not any formal documentation about how to directly access the database but you should be able to find out what the table names are by querying the system tables. See this post for some examples: https://stackoverflow.com/questions/3583963/db2-query-to-retrieve-all-table-names-for-a-given-schema