Permalink
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
23 lines (20 sloc) 503 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_button_state
ACTIVITY=Device Status
KEY_TIMESTAMP=TIMESTAMP
[SQL Query]
QUERY=
SELECT
DATETIME(TIMESTAMP, 'unixepoch') AS TIMESTAMP,
BUTTONTYPE AS "BUTTON TYPE",
EVENTTYPE AS "EVENT TYPE",
ID AS "PLBUTTONAGENT_EVENTPOINT_BUTTONTABLE TABLE ID"
FROM
PLBUTTONAGENT_EVENTPOINT_BUTTON