Checking "Active" box on a DN

Version 1
    This document was generated from CDN thread

    Created by: MIKE WILCOX on 09-04-2012 06:06:05 PM
    What is the SQL statement to use to check the "Active" box on a DN? I know there is no way of doing it through updateLine so need to go the SQL route.
     
    Thanks,
     
    Mike

    Subject: RE: Checking "Active" box on a DN
    Replied by: David Staudt on 10-04-2012 03:02:31 PM
    Can you specify on which screen you see the 'Active' checkbox?

    Subject: RE: Checking "Active" box on a DN
    Replied by: MIKE WILCOX on 10-04-2012 04:03:05 PM
    Can you specify on which screen you see the 'Active' checkbox?

    David,
     
    It is on the Directory Number page if the DN is not associated to any devices. I found in the db docs the field iscallable in the numplan table and that seems to do the trick. Are there any adverse effects of manipulating this field directly via SQL?
     
    Thanks,
     
    Mike

    Subject: RE: Checking "Active" box on a DN
    Replied by: David Staudt on 10-04-2012 04:32:00 PM
    Gotcha...from the UCM help:
     
    Checking this check box allows calls to this DN to be forwarded (if
    forwarding is configured). If check box is not checked, Cisco Unified
    Communications Manager ignores the DN.
     
    This matches my understanding, it is present basically to allow the admin to configure unused 'dummy' numbers for certain call forwarding scenarios - not aware of any other effects.