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)?
Anyone have any information for Lindsay?
Lindsay Estabrooks Apr 23, 2015 3:09 PM
A query that partly answers your question is this:
from usm_offering o
where o.offering_name = 'User Administration'
from usm_offering_ratedef_inclusion i
where i.parent_id = 10141
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.
from usm_offering o,usm_offering_ratedef_inclusion i,usm_rate_definition rd
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.
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.
Thanks Louis. I sent you an email.
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.