How records are created in CMDB 360 [cmdb_multisource_data]

[Lam_B]

Hello,

While working with the new dashboard for CMDB 360, I noticed that some of my discovery sources are not shown in the graph. For example we have 6 discovery sources in the graph, while if you go to the "cmdb_ci" table and group by discovery source, you will find some additional ones.

The CIs with the missing ones are not reported in the "cmdb_multisource_data" table.

I want to understand when and how the records are created in "cmdb_multisource_data."

[Maik Skoddow · Accepted solution]

Hi @Lam_B 

all the information regarding discovery sources on that dashboard are coming from table sn_cmdb_ws_ms_ci_dashboard_data. That table is populated via Script Include MultiSourceQueryProcessor and its contained method _getNumberOfDiscoverySources() is responsible for determining the discovery sources. By design, that method looks up table cmdb_multisource_data to retrieve all discovery sources.

And now coming to your question: Table cmdb_multisource_data is only filled when sending data through the IRE, either by using the right APIs in scripts or by leveraging any Service Graph connectors. For more information, please refer to https://docs.servicenow.com/bundle/vancouver-servicenow-platform/page/product/configuration-manageme...

Thanks
Maik

[Lam_B]

Thank you, Mark, for your response. I now understand that only CIs that go through the IRE are displayed in the dashboard.

However, I have an additional question. What does the "reconciled CIs" card show? As per my understanding, the "reconciled CI" card displays the total number of unique CIs created in the CMDB after processing the reconciliation, right? And the "total CMDB 360 records" card shows the total number of raw CMDB 360 records, meaning that a CI can be discovered multiple times.

Looking at my production dashboard , I have four Discovery sources, and the total number of CMDB 360 records is 60M, of which all 60M have been reconciled.

However, I don't understand one thing. In my dashboard, we can see data mismatches, which means that multiple discovery sources have reported CIs with different values (as also observed from the coverage card). Therefore, in my CMDB 360 table, I should have several CIs reported multiple times by different sources (which is the case). However, I shouldn't have the same number on the "reconciled CI" card. From my understanding, this card should only show the number of CIs injected into the actual CMDB after reconciliation, am I wrong ?

Regards

Lamia

[chaitanya34]

Hi Lamia,

How this widget : CIs not reported by discovery sources is populating data I tried so many ways in my PDI not getting any results

-If you have any example how data will capture on above widget that will help 

Thanks,

CK.