My situation is:
Assume I am selling computers, so each computer has an Asset. Also, each computer has components like monitor, motherboard, cpu, etc. Each component has an Asset too, and they all have a look up field pointing to the computer Asset. The computer does NOT have look up field for component Assets.
Now for some reasons, people buy two computers, later they combine the components, so all component Assets look up field pointing to computer Asset 1, and computer Asset 2 is "childless", because it has no component Asset child.
I would like to find out all computer Assets like Asset 2 in previous example. Is there a way to get the childless Assets?