telco monthly contract sql query
 

im not sure if anyone else in interested but I wanted to know how many on peak and off peak minutes I used, over my contract period.

I saw people playing with el.db, I do dba work for a job at the momment so it caught my interest... but i dont have any app dev in c+ or what ever. so I spent afew hours making a single query and learning sqlite... im used to oracle.

so i made a batch file and called it from "desktop command execution widget"

so it returns: "Outbound Calls => (13)Minutes, (8/60)On, (5/300)Off"

see attached how it looks on the phone.
Might try and figure out cost of contract if limits exceeded.

Re: telco monthly contract sql query
 

Sounds interesting. Care to share the script?