CMDB Comparision

[Shanti7]

Hi, We have a need to compare the customer's CMDB with our CMDB and there are about 300k CIs where 20 attributes need to be compared. Wondering if this can be achieved withing ServiceNow.
1. If I get the Excel Extract, can I upload to ServiceNow and use any feature to compare the data?
2. Create an API and then compare the data and any discrepancies log them in a custom table?

[Dr Atul G- LNG]

Hi @Shanti7 

Practically, there’s no straightforward way — 300K records is not a small number, and it's not feasible to go through each and every record and attribute manually.

To approach this efficiently, you should:

1. 🔍 Prioritize the source of truth — clearly define which data source is authoritative.

2. 🏷️ Identify attribute-level priority — determine which attributes should take precedence during reconciliation.

3. ✅ Follow the 3C rule of CMDB — Completeness, Compliance, and Correctness.

Getting data into Excel and then comparing it might seem tedious and time-consuming, but it's often necessary for accuracy.

💡 Suggestion:
You could try loading the data into a GPT-enabled tool/site and ask it to compare records based on defined parameters.
However, since this involves client data, security and privacy must come first — make sure the platform you're using is secure and compliant.