Permalink
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
31 lines (28 sloc) 845 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_device_telephony_activity
ACTIVITY=Device Status
KEY_TIMESTAMP=TIMESTAMP
[SQL Query 9,10,11,12]
QUERY=
SELECT
DATETIME(TIMESTAMP, 'unixepoch') AS TIMESTAMP,
AIRPLANEMODE AS "AIRPLANE MODE",
CALLSTATUS AS "CALL STATUS",
SIGNALBARS AS "SIGNALS BARS",
SIGNALSTRENGTH AS "SIGNAL STRENGTH",
CAMPEDRAT AS "CAMPED RAT",
CURRENTRAT AS "CURRENT RAT",
PREFERREDRAT AS "PREFERRED RAT",
ACTIVEBAND AS "ACTIVE BAND",
DATASTATUS AS "DATA STATUS",
SIMSTATUS AS "SIM STATUS",
ID AS "PLBBAGENT_EVENTPOINT_TELEPHONYACTIVITY TABLE ID"
FROM
PLBBAGENT_EVENTPOINT_TELEPHONYACTIVITY