Unassigned Associated Items

Version 1
    This document was generated from CDN thread

    Created by: Martin Sloan on 14-02-2012 03:40:02 PM
    I saw a post on this same topic from a few years back but it didn't have an answer so I figured I'd give it another shot.  I'm trying to locate a field in the CUCM DB that might indicate whether an item is "unassigned associated".  For example, a 7962 has an expansion module with 10 lines assigned and then during a MACD the expansion module phone button template is removed and replaced with Standard 796X.  In this case, the extra lines that no longer fit on the phone would drop down under the "unassigned associated items" list.  Does the DB differentiate between an assigned or unassigned dn?  I've checked the devicenumplanmap table which I'm thinking would be the only logical place to find this field if it existed and I do not see it.  The DN/Device associations for the unassigned lines appear to be just the same as the assigned lines, with higher numplanindex values.  Just a last ditch effort before I give up the search.
    Any help is appreciated!

    Subject: RE: Unassigned Associated Items
    Replied by: David Staudt on 14-02-2012 05:18:09 PM
    I suspect you are right, in that the line appearances themselves are not marked in any way as assigned/unassigned.  My guess would be that the UI checks the assigned template against the actual line appearances associated with the device and then calculates which lines are assigned/unassigned for display.  You may need to implement similar logic if you want to automate this check.  E.g. get a device and its line associations, get its assigned template, and calculate the 'overhang'...
    A definite work through will probably involve a couple of hours of researching and testing, I would recommend opening up a CDN Developer Support case.

    Subject: RE: Unassigned Associated Items
    Replied by: Martin Sloan on 16-02-2012 09:59:28 AM
    Thanks David.  That's definitely what I was thinking.  I didn't know it was possible to open cases with the CDN though.  Do I need anything outside of a CCO and support entitlement, which I have?

    Subject: RE: Unassigned Associated Items
    Replied by: David Staudt on 17-02-2012 12:17:52 PM
    CDN does offer case-based SLA support: http://developer.cisco.com/web/devservices/alldevs#case
    It does require a separate support contract from your normal TAC contract.