Incomplete Data from KnowledgeC.db

[hoovdc]

Summary:

I'm seeing partial data from my screentime history generated by this code. There's no obvious pattern across dates, times, apps, devices, etc.

Steps taken:

-Confirm data is shared across all apple devices, and all devices logged into same iCloud account (no issues)
-Confirm data is correctly appearing in the native screen time app UI locally on each Apple device (no issues)
-Confirm timezone data is consistent across date reporting formats (no issues)
-Analyze CSV output for patterns across date, time, apps, devices, etc (across all dimensions, there seems to only be a random subset of data that is available)
-Slightly broaden the SQL query to try to capture more data (unsuccessful)

Next planned steps:

I'll write a similar app in Swift to run from iPhone, using the DeviceActivityData structure instead of KnowledgeC.db. Export this version of the data and compare accuracy.

Questions:

If you run the current code version on your own device, does the data look accurate as of today? (Maybe I'm doing something wrong, or maybe the KnowledgeC.db schema changed, causing errors?)

Context:

I'm re-learning to code after 15 years away, and very inspired by your project! Thanks for making it available.

[mlindgren]

@hoovdc did you have any luck with your investigation? I'm having a similar issue. When I ran the Python script, I only got today's data from the local device, even though I can see synced data in the first-party screen time UI on the same device. I haven't had time to dig into the database and see if it contains all the expected entries. I'm wondering if Apple has changed it to store data from different devices in different locations, or something like that.