[cisco-voip] Query for DN Active/Inactive

[Daniel Rodriguez]

Yep - That's why I was initially looking for a query for inactive/active directory number. We try to avoid this by assigning them to CTI RP's and giving it a clear description. The 'iscallable' column in the numplan table should work for this.

Thx
- Dan

From: Denis Pointer [mailto:denis.mailer at gmail.com]
Sent: Thursday, November 19, 2009 8:49 AM
To: Daniel Rodriguez
Cc: Fuller, Ben; cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Query for DN Active/Inactive

Also keep in mind that "unassigned" is not always inactive.  I have a deployment where we have several phantom mailboxes, to allow calls into these mailboxes we created an active / unassigned DN with Call Forward All to voicemail.


--
Denis Pointer, A. Sc. T.
Customer Systems Analyst (Senior Design)

CCVP, CCNA, CCDA
Cisco Unified Contact Center Specialist
Cisco IP Telephony Design Specialist
Cisco Unity Design Specialist
Cisco Unity Support Specialist
Cisco IP Communications Express Specialist

On Wed, Nov 18, 2009 at 5:57 PM, Jason Aarons (US) <jason.aarons at us.didata.com<mailto:jason.aarons at us.didata.com>> wrote:
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> [mailto: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<mailto: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> [mailto: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<mailto: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.

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net<mailto: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/20091119/83e0b0fc/attachment.html>