Permalink
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
24 lines (21 sloc) 574 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_network_usage
ACTIVITY=Network Usage
KEY_TIMESTAMP=TIMESTAMP
[SQL Query 9,10,11,12]
QUERY=
SELECT
DATETIME(TIMESTAMP, 'unixepoch') AS TIMESTAMP,
INTERFACE as "INTERFACE",
DOWNBYTES AS "DOWN BYTES",
UPBYTES AS "UP BYTES",
ID AS "PLNETWORKAGENT_EVENTBACKWARD_CUMULATIVENETWORKUSAGE TABLE ID"
FROM
PLNETWORKAGENT_EVENTBACKWARD_CUMULATIVENETWORKUSAGE