Permalink
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
23 lines (20 sloc) 644 Bytes
[Module Metadata]
AUTHOR=Sarah Edwards/mac4n6.com/@iamevltwin
MODULE_NOTES=Data Usage Processes/Bundle IDs.
[Database Metadata]
DATABASE=DataUsage.sqlite,DataUsage-watch.sqlite
PLATFORMS=IOS
VERSIONS=8,9,10,11,12
[Query Metadata]
QUERY_NAME=datausage_zprocess
ACTIVITY=Data Usage
KEY_TIMESTAMP=TIMESTAMP
[SQL Query 8,9,10,11,12]
QUERY=
SELECT
DATETIME(ZPROCESS.ZTIMESTAMP+ 978307200, 'unixepoch') AS "TIMESTAMP",
DATETIME(ZPROCESS.ZFIRSTTIMESTAMP + 978307200, 'unixepoch') AS "PROCESS FIRST TIMESTAMP",
ZPROCESS.ZPROCNAME AS "PROCESS NAME",
ZPROCESS.ZBUNDLENAME AS "BUNDLE ID",
ZPROCESS.Z_PK AS "ZPROCESS TABLE ID"
FROM ZPROCESS