Orphaned item

How can we get orphaned item by query to rhythmyx database? Please help.

You can find orphaned items by using the Technical Support Views for the version of Rhythmyx that you are using. Here are links for the views on the forum:

Rhythmyx 5.7.1
Rhythmyx 6.5.2
Rhythmyx 6.7