Permalink
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
25 lines (22 sloc) 684 Bytes
[Module Metadata]
AUTHOR=Sarah Edwards/mac4n6.com/@iamevltwin
MODULE_NOTES=
[Database Metadata]
DATABASE=CurrentPowerlog.PLSQL
PLATFORMS=IOS
VERSIONS=10,11,12
[Query Metadata]
QUERY_NAME=powerlog_springboard_aggregate_notifications
ACTIVITY=Application Usage
KEY_TIMESTAMP=TIMESTAMP
[SQL Query 10,11,12]
QUERY=
SELECT
DATETIME(TIMESTAMP, 'unixepoch') AS TIMESTAMP,
NOTIFICATIONBUNDLEID AS "BULLETIN BUNDLE ID",
TIMEINTERVAL / 60 AS "TIME INTERVAL IN SECONDS",
COUNT AS "COUNT",
NOTIFICATIONTYPE AS "NOTIFICATION TYPE",
ID AS "PLSPRINGBOARDAGENT_AGGREGATE_SBNOTIFICATIONS_AGGREGATE TABLE ID"
FROM
PLSPRINGBOARDAGENT_AGGREGATE_SBNOTIFICATIONS_AGGREGATE