CA Service Management

Expand all | Collapse all

Table info of process code-Service Catalog

Jump to Best Answer
  • 1.  Table info of process code-Service Catalog

    Posted 05-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 06-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 06-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 06-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 07-23-2015 10:51 AM

    Hi Sankar. Thanks for sharing this.