Permalink
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
33 lines (25 sloc) 723 Bytes
[Module Metadata]
AUTHOR=Sarah Edwards/mac4n6.com/@iamevltwin
MODULE_NOTES=
[Database Metadata]
DATABASE=CurrentPowerlog.PLSQL
PLATFORMS=IOS
VERSIONS=9,10,11,12
[Query Metadata]
QUERY_NAME=powerlog_process_data_usage
ACTIVITY=Device State
KEY_TIMESTAMP=TIMESTAMP
[SQL Query 9,10,11,12]
QUERY=
SELECT
DATETIME(TIMESTAMP, 'unixepoch') AS "TIMESTAMP",
DATETIME(TIMESTAMPEND, 'unixepoch') AS "TIMESTAMP END",
BUNDLENAME AS "BUNDLE ID",
PROCESSNAME AS "PROCESS NAME",
CELLIN AS "CELLULAR IN",
CELLOUT AS "CELLULAR OUT",
WIFIIN AS "WIFI IN",
WIFIOUT AS "WIFI OUT",
ID AS "PLPROCESSNETWORKAGENT_EVENTINTERVAL_USAGEDIFF TABLE ID"
FROM
PLPROCESSNETWORKAGENT_EVENTINTERVAL_USAGEDIFF