SABnzbd Forums

I've just hit the 6.0TB downloaded milestone, I'd love to be able to export the data so that I can create graphs and play with the numbers in Excel. Is this possible?

All History data is stored in a simple SQLIte database, file history1.db in the admin folder.
There are quite a few utilities around that allow you to extract data from SQLite databases.

I have been having at look at the history.db file and had a question. Is there a date and time entry in the database? I cant seem to see it when I extract it using http://www.speqmath.com/tutorials/sqlite_export/ . Am I missing something? Or is the data just not there?

anzerman wrote:I have been having at look at the history.db file and had a question. Is there a date and time entry in the database? I cant seem to see it when I extract it using http://www.speqmath.com/tutorials/sqlite_export/ . Am I missing something? Or is the data just not there?

The second field "completed" is the date/time in unix time stamp format. See http://www.unixtimestamp.com/

thanks for that