I am trying to have a 3C health dashboard analyze a group of CIs that are specific to my organization. I can get the list of CIs by Joining these 3 tables: cmdb_ci_service_auto, cmdb_rel_ci and cmdb_ci .
things that i have tried,
- Created a health group, it won't allow you to pick more than 1 class (table). However, works fine for one class(table)
- Created a dynamic CI group,
- Query builder,
- How can i do joins in query builder for above 3 tables?
- without joins, i tried just one class and tried to display on 3c dashboard. it is not coming through.
- I have added (class = dynamic CI group) in the inclusion rule for the health dashboard.
Appreciate any help.
