All -
I'm trying to figure out a query that I can run which will dump a list of Remote Destination Name, Destination (Cell Number) and Extension tied to the Profile.
I was able to get create a query that gives me the RDN and Destination, but can't seem to pull in the extension that is tied to it. I'm not sure where to pull that data from.
Here is what I've come up with so far.
run sql select r.name, rd.destination from remotedestinationdynamic rd inner join remotedestination r on rd.fkremotedestination=r.pkid
Hopefully someone can help me pull in that last field.