I've got a USB screen setup on my system, is there an SQLite command you could share with me to Select the Total (up and down) use for all users for the current month (I have exclude local network turned on) and another command just for my up/down for the current month? That way I could pull the data and show it on the screen.
Can be just be a raw figure, I'm happy to convert the value into KB/MB/GB/etc as needed if that will make for a simpler SQL statement
This should give you the figures for the current month:
SUM(DATA_IN) AS DL,
SUM(DATA_OUT) AS UL,
SUM(DATA_IN + DATA_OUT) AS BOTH
date('1899-12-30', '+' || DAY || ' days')
date('now', 'start of month')
date('now', 'start of month', '+1 month', '-1 day')
You can add a filter for a specific user simply by adding a clause to WHERE, e.g.