[cisco-voip] [NEWSENDER] - RE: Query for DN Active/Inactive - Message is from an unknown sender

[Daniel Rodriguez]

By active I meant the active checkbox that's available when the DN is unassigned (unchecked, inactive unassigned - checked, active (that is, used by CUCM during DA lookup) unassigned). The unassigned DN report was in front of my face... one of those questions a person regrets asking after realizing the answer was right there.  It's like spending 30m looking for my keys... only to find out they're in my pocket... :)

________________________________
From: Jason Aarons (US) [jason.aarons at us.didata.com]
Sent: Wednesday, November 18, 2009 6:57 PM
To: Fuller, Ben; Daniel Rodriguez; cisco-voip at puck.nether.net
Subject: [NEWSENDER] - RE: [cisco-voip] Query for DN Active/Inactive - Message is from an unknown sender

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.