I'm looking into creating a wall board for our call counts and i would like to know what query I would use to find call counts for each of our SIP trunks. Possibly separate by inbound and outbound counts. Total per current day, per last 7 days, per last 30 days. I've been looking at the CDR table, but my attempts at pulling up usable data so far have not panned out.
