When you look up a Resource in the CA Business Service Insight user interface, it shows the Service that resource is associated with. But how is this information found in the database?
Here's a query where I found my Resource "cmd" that shows an associated Service "ServiceOne"
select app.application_name, res.resource_name
from t_applications app, t_application_resources apr, t_resources res
where app.application_id = apr.application_id
and res.resource_name = 'cmd'
and apr.create_version_status = 'ACTIVE';
returns
APPLICATION_NAME RESOURCE_NAME
ServiceOne cmd
Within the database, the "Application" is the Service.