CA Service Management

  • 1.  Database table that stores Auto Assignment List (Group Detail)

    Posted Mar 03, 2017 03:14 PM

    I'm looking to activate the Auto Assignment List within the Group Detail screen in Xtraction. Out of the box, it doesn't have this field. In order for me to do this, I need to modify the Xtraction datamodel and point it to the correct database object/table. Can someone please point me to where this object/table is in the database?



  • 2.  Re: Database table that stores Auto Assignment List (Group Detail)

    Posted Mar 06, 2017 05:09 AM

    Hi,

    I don't think there is one single table because those are SREL from each different objects like pcat, chgcat,iss and loc.

    /J



  • 3.  Re: Database table that stores Auto Assignment List (Group Detail)

    Posted Mar 06, 2017 10:56 AM

    Actually, it seems like the first three are already implemented out of the box as you can see below:

     

     

     

    The one I need is the Location List.



  • 4.  Re: Database table that stores Auto Assignment List (Group Detail)

    Broadcom Employee
    Posted Mar 07, 2017 05:38 PM

    Marc,

     

    I'm not sure if this is exactly what you are looking for, but the table that stores that information in the mdb is stored in:

     

    usp_lrel_svc_locs_svc_groups

     

    The "cnt" column stores the uuid of the group.

    the "loc" column stores the uuid of the location