How can I find requests that are associated with a particular asset?

[TomW]

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!

 

[ArmandoDM]

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

[James Ainsworth]

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.

 

Regards,

James

[TomW]

Thanks to both of you for your replies and advice.