April 2020
Intermediate to advanced
400 pages
10h 12m
English
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:

As you can see, the CalendarItem table stores dates in Mac absolute time format, so we added 978307200 ...
Read now
Unlock full access