How can I find the service associated with a Resource?

Products

• OBLICORE GUARANTEE

Issue/Introduction

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?

Environment

Release:
Component: OBLCRE

Resolution

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.