[cisco-voip] DN report including CSS

[Anthony Holloway]

SSH into your Publisher and paste this into the window:

admin:run sql select n.dnorpattern as dn, p.name as partition, css.name as
css from numplan as n left join routepartition as p on n.fkroutepartition =
p.pkid left join callingsearchspace as css on
n.fkcallingsearchspace_sharedlineappear = css.pkid where css.name like
'%nternational%'


On Tue, May 6, 2014 at 10:20 AM, Chris Chamberlain <chamberl at oakland.edu>wrote:

> Does anyone know if there is a way in CUCM 9.1 to generate a report
> detailing a list of DNs and their assigned CSS?  This seems like it would
> be something fairly straightforward, however we are not seeing a way to do
> this.  We have been asked to find every DN that currently has International
> Calling capability, but without looking at each DN individually I do not
> see an automated way of obtaining this information.  Any Thoughts?
>
> -Chris
>
> Chris Chamberlain
> Associate Director Network Engineering
> Oakland University
> 248.370.4321
>
>
>
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140506/ea840b9e/attachment.html>