Jump to content

Assets and corresponding linked assets report


Recommended Posts

Hi @Victor

I am trying to create a simple data list report of assets, and their corresponding linked assets.

So we have, for example, a site as an asset, which is then linked to riverbed ( which is also an assets), which in turn linked to a switch.

So I am looking for some kind of a report which could give me a list of sites, and what is linked with them.

Site asset type- 19 ( BAsic)

Linked assets as Network device type assets




Link to comment
Share on other sites

@Joyce If you created a Single list of data report using an Entity and specifying the Asset as the entity, would you not get the desired result? When you do create this entity, under Data Collection you could specify fields site, name, building of the Asset table as shown in the screenshot below. The end result is a report with assets by site. Some sites have more than one asset as shown in the second screenshot.




assetBy Site.PNG

Link to comment
Share on other sites

@Joyce : I understand you have a support request raised to assist you with this. For the benefit of all community, I will post the answer here. Basically, the query you need to return that information is this:

  a.h_name, b.h_name FROM h_cmdb_links 
  h_cmdb_assets a ON a.h_asset_urn = h_cmdb_links.h_fk_id_l
  h_cmdb_assets b ON b.h_asset_urn = h_cmdb_links.h_fk_id_r
  a.h_type = 19
ORDER BY h_cmdb_links.h_fk_id_l

You need to transpose this query into a report, something my colleagues can help in the support request you have ongoing. The fields in the statement are just an example, you can add more fields to the report as per your requirements.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...