Asset SQL query
We are doing some reporting in regards to our assets however the out of the box reporting doesn't seem to satisfy our requirements.
What we would like to do is find the related hardware asset of a hardware asset.
For example a SIM Card hardware asset which is directly linked/related to a Mobile Phone hardware asset.
(If you open a Hardware Asset and look in the Related Assets tab - you will notice an are which displays "Hardware Assets this Hardware Asset belongs to"
Does anyone know of a SQL query which would identify the related asset of a hardware asset?