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

[Nate VanMaren]

going from memory,
run sql select dnorpattern, alertingname from numplan where iscallable = false


________________________________________
From: cisco-voip-bounces at puck.nether.net [cisco-voip-bounces at puck.nether.net] On Behalf Of Jason Aarons (US) [jason.aarons at us.didata.com]
Sent: Wednesday, November 18, 2009 8:41 PM
To: Ryan Ratliff; Daniel Rodriguez
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] [NEWSENDER] - RE: Query for DN Active/Inactive -      Message is from an unknown sender

Could you provide a sample CLI query with iscallable ?

-----Original Message-----
From: Ryan Ratliff [mailto:rratliff at cisco.com]
Sent: Wednesday, November 18, 2009 10:31 PM
To: Daniel Rodriguez
Cc: Jason Aarons (US); Fuller, Ben; cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] [NEWSENDER] - RE: Query for DN Active/Inactive
- Message is from an unknown sender

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 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
https://puck.nether.net/mailman/listinfo/cisco-voip


-----------------------------------------
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


 NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.