Finding the service associated with a Resource

Products

• CA Business Service Insight

Issue/Introduction

When you look up a resource in the CA Business Service Insight UI, it shows the service that resource is associated with.

Is it possible to find the same information directly from the database?

Environment

CA Business Service Insight 8.3.x and 9.x

Resolution

The following database query that shows the resource "cmd" associated to 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';

The query returns

APPLICATION_NAME RESOURCE_NAME
ServiceOne cmd

The value for the Application_Name field is the associated service.