Calendar events

Calendar events that have been manually created by the user or synced using a mail application or other third-party applications are stored in the Calendar database. The Calendar database can be found at /HomeDomain/Library/Calendar/Calendar.sqlitedb.

The CalendarItem table in the Calendar.sqlitedb file contains the calendar events summary, description, start date, end date, and more. You can run the following queries in DB4S to parse the calendar, as illustrated in the following screenshot:

Examining calendar.sqlitedb in DB4S

As you can see, the CalendarItem table stores dates in Mac absolute time format, so we added 978307200 to reveal actual timestamps, with the help of the datetime function.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.221.53.5