TomW Posted January 11, 2019 Posted January 11, 2019 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 Posted January 11, 2019 Posted January 11, 2019 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 Posted January 11, 2019 Posted January 11, 2019 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 Posted January 15, 2019 Author Posted January 15, 2019 Thanks to both of you for your replies and advice.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now