I would utilize the CMDB query builder and take it class by class. To create a report based on cmdb_rel_ci will not work, as it will only show CIs with relationships.
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
