cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
235
Views
0
Helpful
1
Replies
Debra Chittick
Enthusiast

SQL query to identify call counts per SIP trunk

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.

1 REPLY 1
hamad2k9
Beginner

Hi Debra,

 

How do you extract this data from SQL, as I am new and want to extract data from SQL and showing in in my web application.

 

Regards

 

 

Content for Community-Ad