maemo.org - Talk - View Single Post - Call Log with Maemo 5 / N900 (especially vs Symbian S60)

nygren	2010-01-06 , 22:45
Posts: 8 \| Thanked: 7 times \| Joined on Jul 2008	#34

I've found the following to be quite useful for figuring out where calls
and SMS messages actually came from:

Code:

sqlite3 -line .rtcom-eventlogger/el.db 'select service_id, ET.name,
datetime(storage_time,"unixepoch") storage_time,
datetime(start_time,"unixepoch") start_time,
datetime(end_time,"unixepoch") end_time, is_read, flags, E.remote_uid,
remote_name, abook_uid, group_uid, channel, free_text from Events as
E, EventTypes ET, Remotes as R where E.event_type_id=ET.id and
R.remote_uid=E.remote_uid and E.local_uid=R.local_uid order by
storage_time;'

(I stuck it in a shell script that I can just run as-needed until it is better in the OS or until there's a better app for it.)

Quote & Reply |

The Following User Says Thank You to nygren For This Useful Post:
OVK