Extracting Data from CMDB

[mahesh_vavilal1]

One of our support team would like to consume data from Service Now CMDB. Just curious to know as what are all the available options to extract data from CMDB.

[john_duchock]

Currently, we are using a standard ODBC connection though we are not pulling the full CMDB_CI table.   Instead, we are focusing on our "managed" configuration items (cmdb_ci_appl, cmdb_ci_server, cmdb_ci_netgear).   These tables are small enough so that our data extracts do not take very long.

There are certainly other methods of data extraction besides ODBC that would be more secure or more real-time but the learning curve can be steep on some of them...

[DrewW]

We wrote a program that extracts the data via XML and builds a replica of the database on a local SQL server.   This allows us to use SSRS for our more complicated reporting.

[cwjurges]

Use Perspectium Replicator. Publish once and subscribe everywhere. No incoming connections, Web services or semaphores thus, very low impact and high throughput.

Thanks,

Chris

[pavelmuller]

You could use SnowMirror instead of building a home-grown solution based on ODBC. You can configure only those tables and columns you really need and SnowMirror will be replicating increments from your CMDB into your on-premise database. Just download a trial and give it a try.