cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
2185
Views
0
Helpful
1
Replies
Highlighted
Beginner

What format is the date in the Jabber IM history .db file?

We use hosted (cloud) Jabber for our business. Clients have v9.2.4 Build 4528 on Windows 7 workstations. I'm looking for a way to track a user's IM history.  My only solution has been to import the .db file found in the C:\Users\%username%\AppData\Local\Cisco\Unified Communications\Jabber\CSF\History.  I can see the raw data and don't mind manipulating it myself to generate a report....if I could understand it.  However, the date format is puzzling me.  The field is called "date" and contains a long integer like 1371737172491145.  Can someone tell me how to convert that into a date/time value?

Is there a doc somewhere that explains the data structure? It's also not clear to me how to join the tables to determine who the message is sent to, etc.

Thanks.

1 REPLY 1

Re: What format is the date in the Jabber IM history .db file?

Hi,

i have the same problem and i can't find a solution.

Did you find anything?

Thanks

News:

Use "Sqlite Browser" (you can find it on google). Now you can read the full content of the db file.

Then you can use this:

select datetime( date/1000000, 'unixepoch','localtime') as data ,name,number,jid,duration from history_participant

inner join history_item on history_participant.item = history_item.id

and you will return the right date

bye bye

CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards