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

[Nicole Bell]

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. 

[SebastianKunzke · Accepted solution]

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.

[Nicole Bell]

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.