Permalink
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
35 lines (31 sloc) 764 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_paired_device_config
ACTIVITY=Device Status
KEY_TIMESTAMP=TIMESTAMP
[SQL Query 10,11,12]
QUERY=
SELECT
DATETIME(TIMESTAMP, 'unixepoch') AS TIMESTAMP,
BUILD,
DEVICE,
HWMODEL,
PAIRINGID AS "PAIRING ID",
ID AS "PLCONFIGAGENT_EVENTNONE_PAIREDDEVICECONFIG TABLE ID"
FROM
PLCONFIGAGENT_EVENTNONE_PAIREDDEVICECONFIG
[SQL Query 9]
QUERY=
SELECT
DATETIME(TIMESTAMP, 'unixepoch') AS TIMESTAMP,
BUILD,
DEVICE,
ID AS "PLCONFIGAGENT_EVENTNONE_PAIREDDEVICECONFIG TABLE ID"
FROM
PLCONFIGAGENT_EVENTNONE_PAIREDDEVICECONFIG