Permalink
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
28 lines (25 sloc) 773 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_ids_messages
ACTIVITY=Device Status
KEY_TIMESTAMP=TIMESTAMP
[SQL Query 9,10,11,12]
QUERY=
SELECT
DATETIME(TIMESTAMP, 'unixepoch') AS TIMESTAMP,
DATETIME(TIMESTAMPEND, 'unixepoch') AS "TIMESTAMP END",
TOPIC AS "TOPIC",
PRIORITY AS "PRIORITY",
INCOMINGMESSAGES AS "INCOMING MESSAGES",
OUTGOINGMESSAGES AS "OUTGOING MESSAGES",
INCOMINGBYTES AS "INCOMING BYTES",
OUTGOINGBYTES AS "OUTGOING BYTES",
ID AS "PLIDENTITYSERVICESAGENT_EVENTINTERVAL_IDSMESSAGEPERIODIC TABLE ID"
FROM
PLIDENTITYSERVICESAGENT_EVENTINTERVAL_IDSMESSAGEPERIODIC