CA Service Management

 View Only
  • 1.  Table info of process code-Service Catalog

    Posted May 29, 2015 02:11 AM

    Dear Team,

     

    Please help with the MDB table details which stores the detials of all the service CODE (provided in service builder) which directs to PAM process.

     

    Thanks,

    Saranya P



  • 2.  Re: Table info of process code-Service Catalog

    Posted Jun 03, 2015 04:45 PM

    Anyone have any help for Saranya?

     

    Thanks

     

    Table info of process code-Service Catalog

     

    Dear Team,

     

    Please help with the MDB table details which stores the detials of all the service CODE (provided in service builder) which directs to PAM process.

     

    Thanks,

    Saranya P



  • 3.  Re: Table info of process code-Service Catalog
    Best Answer

    Broadcom Employee
    Posted Jun 04, 2015 12:43 PM

    HI Saranya

                Please use the following query to return offering name and code

     

                select offering_name,code from usm_offering;

     

    rgds

    Sankar



  • 4.  Re: Table info of process code-Service Catalog

    Posted Jun 05, 2015 04:49 AM

    Hi Sankar,

     

    Thank you for the assistance,it helps. We are also able to find the same with below query:

     

    select code, item_text from usm_rate_definition

     

    Thanks,

    Saranya P



  • 5.  Re: Table info of process code-Service Catalog

    Posted Jul 23, 2015 10:51 AM

    Hi Sankar. Thanks for sharing this.