When performing administration in CA Service Catalog it may be useful to know which forms are used in which service offerings - how can we query this from the database?
The following SQL query will return which forms are currently in which offerings; offerings without forms or forms without offerings will not be returned.
select f.form_entity_name, o.offering_name from usm_form_entities f, usm_rate_definition d, usm_offering_ratedef_inclusion i, usm_offering o
where d.text_1 = f.form_entity_id
and d.status = 1
and d.item_type = 14
and d.item_id = i.child_id
and i.parent_id = o.offering_id