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

[Daniel Rodriguez]

Perfect.
Thanks!

Sent from my iPhone

On Nov 18, 2009, at 10:29 PM, "Ryan Ratliff" <rratliff at cisco.com> wrote:

> The column in numplan you want is 'iscallable'.   Don't just go by  
> unassigned DNs as they can be active.
>
> -Ryan
>
> On Nov 18, 2009, at 7:18 PM, Daniel Rodriguez wrote:
>
> 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 searc 
> h under are DN, description, and partition. I exported the output of 
>  SELECT * from numplan to CSV and looked at all the columns, but I c 
> an’t seem to find the column for active/inactive status. Maybe  
> I’m just blind or just looking at the wrong table. Data dictionary i 
> s usually helpful but searching for “active” comes back w/  
> hundreds of results. Dumping DA from DNA also doesn’t show active/in 
> active 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
> https://puck.nether.net/mailman/listinfo/cisco-voip
>