Reporting - Finding assets that use certain business services

shivdadhan418
Tera Contributor

Hello,

 

I am trying to create a report that shows all assets with a hostname and ip address that are linked to certain business services. 

 

How can I achieve this? I am trying to find a link or common column between the alm_asset and cmdb_ci_service tables but I am not sure how to use both tables to return a combined list of assets that use specific business services. 

 

I believe I should be generating the report on the alm_asset table, as I am trying to find assets that use those business services, correct?

 

Any advice or help is much appreciated.

 

Thank you.

0 REPLIES 0