Comparing CSV Records with a ServiceNow CMDB Table Using Agentic Workflows or Now Assist

[VUTHUYDANN]

Objective:

After comparing the CSV data with the CMDB table, I want to identify:

1. Obsolete records
   • Records that exist in the CMDB table but are not present in the CSV file.
   • These may indicate assets or CIs that are no longer valid and require review.
2. New records
   • Records that exist in the CSV file but are not present in the CMDB table.
   • These may need to be created or investigated.
3. Matching records
   • Records that exist in both sources.

Questions:

• Can this comparison be implemented using Agentic Workflows and AI Agents in ServiceNow?
• Can Now Assist ingest CSV content, query a CMDB table, and return:
  • New records
  • Obsolete records
  • Matching records
  • Attribute mismatches
• Are there recommended patterns using Agent Actions, Flow Designer, IntegrationHub, or Data Stream Actions for this use case?
• Has anyone implemented a similar CMDB reconciliation/discovery-validation process using Agentic AI capabilities?

Example:

CSV contains:

• ServerA
• ServerB
• ServerC

CMDB contains:

• ServerA
• ServerB
• ServerD

Expected result:

• New: ServerC
• Obsolete: ServerD
• Matching: ServerA, ServerB

Thanks