[cisco-voip] Query for DN Active/Inactive

[Jason Aarons (US)]

I agree, what is the definition of active?  Maybe the phone is Assigned
to Line 1 but that person was fired 6 months ago, is that inactive?

 

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Fuller, Ben
Sent: Wednesday, November 18, 2009 6:08 PM
To: Daniel Rodriguez; cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Query for DN Active/Inactive

 

Hi Dan,

 

If you are looking for 'Unassigned DNs', they can be queried in
/ccmadmin under Call Routing > Route Plan Report.

 

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Daniel
Rodriguez
Sent: Thursday, 19 November 2009 9:04 AM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] Query for DN Active/Inactive

 

Folks:

 

      I'm trying to search for inactive directory numbers in CUCM. It
can't be done within the CUCM web GUI since the only fields to search
under are DN, description, and partition. I exported the output of
SELECT * from numplan to CSV and looked at all the columns, but I can't
seem to find the column for active/inactive status. Maybe I'm just blind
or just looking at the wrong table. Data dictionary is usually helpful
but searching for "active" comes back w/ hundreds of results. Dumping DA
from DNA also doesn't show active/inactive status of my DNs.

 

      Thanks in advance.

 

- Dan

 

________________________________

CONFIDENTIALITY - The information contained in this electronic mail
message is confidential and is intended solely for the addressee(s). If
you are not an authorised recipient of this message please contact UXC
Getronics Australia immediately by reply email and destroy/delete this
message from your computer. Any unauthorised form of reproduction of
this message, or part thereof, is strictly prohibited.
DISCLAIMER - Unless specifically indicated otherwise, the views and
opinions expressed in this email are those of the sender and not UXC
Getronics Australia. While we endeavour to protect our network from
computer viruses, UXC Getronics Australia does not warrant that this
email or any attachments are free of viruses or any other defects or
errors. It is the duty of the recipient to virus scan and otherwise test
any information contained in this email before loading onto any computer
system.




-----------------------------------------
Disclaimer:

This e-mail communication and any attachments may contain
confidential and privileged information and is for use by the
designated addressee(s) named above only.  If you are not the
intended addressee, you are hereby notified that you have received
this communication in error and that any use or reproduction of
this email or its contents is strictly prohibited and may be
unlawful.  If you have received this communication in error, please
notify us immediately by replying to this message and deleting it
from your computer. Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20091118/83f9741c/attachment.html>