CUCM 7.1.2 SQL script

[m.ateeque]

how do i create script to locate  dialed 800 & 911 number from all of my 6 sites, voice gateways configured in MGCP, all sites are meshed with MPLS [ PNT] wan, through blogs i have an idea  we can run a  sql command on pub or sub  to get desired results.

Appreciate your help..thanks

[orobosa.orobor]

  You can export CDR report in Seviceability to locate dialed numbers. Your file will be comma delimited file. I usually import the file into Excel and sort through to locate the numbers.