CA Service Management

  • 1.  Query relationships - Offerings, options, forms

    Posted 04-23-2015 03:09 PM

    Trying to see the relationship between a form and the option/offering to which it is related. There does not seem to be anything in the gui that will easily show that and I have not been able to determine which table(s) contain that relationship. Is there table documentation available for Service Catalog (similar to the Technical Reference for Service Desk)?



  • 2.  Re: Query relationships - Offerings, options, forms

    Posted 04-28-2015 01:17 PM

    Anyone have any information for Lindsay?

     

    Thanks

     

    Query relationships - Offerings, options, forms

     

    Trying to see the relationship between a form and the option/offering to which it is related. There does not seem to be anything in the gui that will easily show that and I have not been able to determine which table(s) contain that relationship. Is there table documentation available for Service Catalog (similar to the Technical Reference for Service Desk)?



  • 3.  Re: Query relationships - Offerings, options, forms

    Broadcom Employee
    Posted 04-29-2015 09:15 AM

    Hi Lindsay.

     

    A query that partly answers your question is this:

    select o.offering_id,o.offering_name

    from usm_offering o

    where o.offering_name = 'User Administration'

     

    select i.parent_id,i.rate_plan_id

    from usm_offering_ratedef_inclusion i

    where i.parent_id = 10141

     

    select *

    from usm_rate_definition rd

    where rd.rate_plan_id = 10121

     

    select * from usm_offering where offering_name = 'User Administration'

    > check the content of the 'path' column.

     

    Joined:

    select o.offering_id,o.offering_name,

           i.parent_id,i.rate_plan_id,

           rd.item_id,rd.rate_plan_id,rd.item_text

    from usm_offering o,usm_offering_ratedef_inclusion i,usm_rate_definition rd

    where o.offering_name = 'User Administration'

      and i.parent_id = o.offering_id

      and rd.rate_plan_id = i.rate_plan_id

     

    Next step is to find the relationship between the form and the above 'objects'.

     

    I hope this helps you further (somewhat)? Kind regards, Louis.



  • 4.  Re: Query relationships - Offerings, options, forms

    Broadcom Employee
    Posted 04-29-2015 09:21 AM

    Hi Lindsay.

     

    For CA Service Catalog release 12.7,12.8 and 12.9, I do have the MDB-Schema(ERD) files available.

    Please provide your email address and I can send these to you when you like me to do so.

    My email address is Louis.vanAmelsfort@ca.com

     

    Kind regards, Louis.



  • 5.  Re: Query relationships - Offerings, options, forms

    Posted 04-29-2015 03:18 PM

    Thanks Louis. I sent you an email.



  • 6.  Re: Query relationships - Offerings, options, forms

    Broadcom Employee
    Posted 04-30-2015 07:19 AM

    Hi Lindsay.

     

    I received your email message. Thanks for that.

    And in 2 replies on your message, I attached the SC R12.7 and SC R12.8 ERD.zip files.

    And in a separate(2nd) email message, the SC r12.9 ERD.zip file.

     

    Kind regards, Louis.