I have to write filter condition to detect all orphan CIs. From documentation example, the filter conditions in which both the Assigned to and the Owned by fields are empty, will identify the matching CIs as orphans. What other conditions should be there for considerations of orphan CIs?
A Configuration Item (CI) is considered an Orphan based on these criteria
The orphan rules for a particular CI class and you can change these in the CI Class Manager.
Here you define what you would like as the Orphan Rule to be for that class