How do I extract (report or CMDB Query) the contents of multiple Dynamic CI Groups.

Go to solution
Nicole Bell
Tera Contributor

‎01-12-2022 02:38 PM

I have created around 20 Dynamic CI Groups using the CMDB Query and CMDB Group method. 

I now want to show ALL the CIs related to these Dynamic CI Groups.  

I have tried the CMDB Query but cannot get the contents of the Dynamic CI Groups to display. 

Labels:
0 Helpfuls
  • 1,347 Views
1 ACCEPTED SOLUTION

Go to solution
SebastianKunzke
Kilo Sage
Kilo Sage

‎01-12-2022 11:32 PM

I am unsure, if you are able to solve this over a CMDB query. My advise would be to use the table "svc_ci_assoc". This table stores the linkage between dynamic CI groups and the CIs. Based on that table you should be able to get your expected result.

View solution in original post

2 REPLIES 2

Go to solution
SebastianKunzke
Kilo Sage
Kilo Sage

‎01-12-2022 11:32 PM

I am unsure, if you are able to solve this over a CMDB query. My advise would be to use the table "svc_ci_assoc". This table stores the linkage between dynamic CI groups and the CIs. Based on that table you should be able to get your expected result.

Go to solution
Nicole Bell
Tera Contributor

‎01-13-2022 01:01 AM

Hi Sebastian, thank you so much!  This has worked wonderfully.  Gosh - I spent ages with my colleague today looking and looking for how this was supposed to work, you've made our day!  Thanks again.