Skip to content

Instantly share code, notes, and snippets.

@wabzqem
Created April 27, 2020 10:18
Show Gist options
  • Save wabzqem/45688ea47f137fdb537bd3008eeac19c to your computer and use it in GitHub Desktop.
Save wabzqem/45688ea47f137fdb537bd3008eeac19c to your computer and use it in GitHub Desktop.
sqlite> select * FROM ZENCOUNTER WHERE Z_PK > 225;
226|1|1||0.0|609674900.519855|0.0|||App started|
227|1|1||0.0|609674900.532348|0.0|||Scanning started|
228|1|1||0.0|609674900.559534|0.0|||App entered foreground|
229|1|1|1|-57.0|609674900.766709|12.0|iPhone 6s|iPhone XS Max|<redacted>|AU_DTA
230|1|1|1|-53.0|609674902.399689|12.0|iPhone XS Max|iPhone 6s|<redacted>|AU_DTA
231|1|1||0.0|609674911.477912|0.0|||Scanning stopped|
232|1|1||0.0|609674926.049821|0.0|||App entered background|
233|1|1||0.0|609675035.919336|0.0|||Scanning started|
234|1|1|1|-84.0|609675036.107311|12.0|iPhone XS Max|iPhone 6s|<redacted>|AU_DTA
235|1|1||0.0|609675155.495037|0.0|||Scanning started|
236|1|1||0.0|609675155.496729|0.0|||Scanning stopped|
237|1|1||0.0|609675155.793031|0.0|||App entered foreground|
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment