How can I use (Join) more than one table to populate 3c health dashboard?

[nishantamatya]

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,

1. Created a health group, it won't allow you to pick more than 1 class (table). However, works fine for one class(table)
2. 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.

[Kieran Anson]

Hi,

Possibly misunderstanding what you're trying to achieve? You can nest your query as OR conditions in the encoded query. It'll depend on the complexity of your query though. And it does mean you can't access cmdb_rel_ci...but that isn't a direct CI table anyway