Permalink
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
29 lines (26 sloc) 697 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_push_message_received
ACTIVITY=Application Usage
KEY_TIMESTAMP=TIMESTAMP
[SQL Query 9,10,11,12]
QUERY=
SELECT
DATETIME(TIMESTAMP, 'unixepoch') AS TIMESTAMP,
BUNDLEID AS "BUNDLE ID",
CONNECTIONTYPE AS "CONNECTION TYPE",
ISDROPPED AS "IS DROPPED",
LINKQUALITY AS "LINK QUALITY",
PRIORITY,
TOPIC,
SERVERHOSTNAME AS "SERVER HOSTNAME",
SERVERIP AS "SERVER IP",
ID AS "PLPUSHAGENT_EVENTPOINT_RECEIVEDPUSH TABLE ID"
FROM
PLPUSHAGENT_EVENTPOINT_RECEIVEDPUSH