Jump to content

Recommended Posts

Posted

Is it possible to search for requests that are associated with an asset?

I ask this question because I am trying to create reports to find incidents, services requests etc. that are associated with a particular asset.

There must be an association because when you look at a particular request, you can see the assets associated with it. I am essentially trying to do the reverse of this. I've been looking at the various entities in the Entity Viewer to find a link but have been unsuccessful so far!

 

Posted

Hello @TomW

the entity is called AssetsLinks and the corresponding table is h_cmdb_links.
In this table you will find the URNs for the request and for the asset linked to each other.

Hope this helps

Regards

Armando

Posted

Hi @TomW

If you would like to do this without creating a report, you can view the Asset Details where there will be a section at the bottom of the asset that lists any requests that are linked to that asset.  If this section is not visible this will indicate that no requests have been associated to that particular asset.

image.png

 

Regards,

James

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...