Mailing List Archive: Cisco: VOIP

Query for DN Active/Inactive

Index | Next | Previous | View Threaded

drodriguez at fidelus

Nov 18, 2009, 2:04 PM

Post #1 of 5 (534 views)
Permalink

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

Ben.Fuller at uxcg

Nov 18, 2009, 3:07 PM

Post #2 of 5 (510 views)
Permalink

Re: Query for DN Active/Inactive [In reply to]

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 [mailto:cisco-voip-bounces [at] puck] On Behalf Of Daniel Rodriguez
Sent: Thursday, 19 November 2009 9:04 AM
To: cisco-voip [at] puck
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.

jason.aarons at us

Nov 18, 2009, 3:57 PM

Post #3 of 5 (513 views)
Permalink

Re: Query for DN Active/Inactive [In reply to]

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
[mailto:cisco-voip-bounces [at] puck] On Behalf Of Fuller, Ben
Sent: Wednesday, November 18, 2009 6:08 PM
To: Daniel Rodriguez; cisco-voip [at] puck
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
[mailto:cisco-voip-bounces [at] puck] On Behalf Of Daniel
Rodriguez
Sent: Thursday, 19 November 2009 9:04 AM
To: cisco-voip [at] puck
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.

denis.mailer at gmail

Nov 19, 2009, 5:49 AM

Post #4 of 5 (491 views)
Permalink

Re: Query for DN Active/Inactive [In reply to]

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> 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 [mailto:
> cisco-voip-bounces [at] puck] *On Behalf Of *Fuller, Ben
> *Sent:* Wednesday, November 18, 2009 6:08 PM
> *To:* Daniel Rodriguez; cisco-voip [at] puck
> *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 [mailto:
> cisco-voip-bounces [at] puck] *On Behalf Of *Daniel Rodriguez
> *Sent:* Thursday, 19 November 2009 9:04 AM
> *To:* cisco-voip [at] puck
> *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
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>

drodriguez at fidelus

Nov 19, 2009, 6:38 AM

Post #5 of 5 (490 views)
Permalink

Re: Query for DN Active/Inactive [In reply to]

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]
Sent: Thursday, November 19, 2009 8:49 AM
To: Daniel Rodriguez
Cc: Fuller, Ben; cisco-voip [at] puck
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<mailto:jason.aarons [at] us>> 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<mailto:cisco-voip-bounces [at] puck> [mailto:cisco-voip-bounces [at] puck<mailto:cisco-voip-bounces [at] puck>] On Behalf Of Fuller, Ben
Sent: Wednesday, November 18, 2009 6:08 PM
To: Daniel Rodriguez; cisco-voip [at] puck<mailto:cisco-voip [at] puck>
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<mailto:cisco-voip-bounces [at] puck> [mailto:cisco-voip-bounces [at] puck<mailto:cisco-voip-bounces [at] puck>] On Behalf Of Daniel Rodriguez
Sent: Thursday, 19 November 2009 9:04 AM
To: cisco-voip [at] puck<mailto:cisco-voip [at] puck>
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<mailto:cisco-voip [at] puck>
https://puck.nether.net/mailman/listinfo/cisco-voip

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads