Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

Zeitgeist logs your activity in Unity. Is there a way to look at the raw logs it creates?

share|improve this question
add comment

2 Answers

up vote 4 down vote accepted

The logs are stored in ~/.local/share/zeitgeist/activity.sqlite. They are stored in an SQLite database, so you will need an SQLite database browser to view them.

share|improve this answer
    
Thanks. Can you recommend one? –  con-f-use Aug 3 '12 at 15:41
    
I like SQLite Database Browser sudo apt-get install sqlitebrowser. –  reverendj1 Aug 3 '12 at 15:48
add comment

Yes, Zeitgeist stores its data in sqlite. I'm using Ubuntu 12.04 (Precise Pangolin) and my zeitgeist usage data is in

~/.local/share/zeitgeist

In order to access the raw logs, you'll need to know some SQL, which I'll leave up to you. However, if you have not installed sqlite3 Install sqlite3, the command line interface for SQLite Version 3, then do so

sudo apt-get install sqlite3

Then, you may interogate the raw data as follows

[11:33:50 oyrm zeitgeist]$ pwd # Just to show where we are
/home/oyrm/.local/share/zeitgeist
[11:33:54 oyrm zeitgeist]$ sqlite3 -interactive activity.sqlite
SQLite version 3.7.9 2011-11-01 00:52:41
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
actor            extensions_conf  mimetype         storage        
event            interpretation   payload          text           
event_view       manifestation    schema_version   uri            
sqlite> 

As you can see, I have access to the activity.sqlite database at this point and may execute SQL to my hearts content. Now, figuring out how these are all related will be a puzzle for you, but you can use sqlite3 to determine useful things like db and table schemas.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.