How can I find the service associated with a Resource?

Document ID : KB000015351
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

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?

Answer:

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.