How do we export Complete CMDB in Excel format and CI count is 1800000

Chiranjeevi R
Tera Contributor

‎06-29-2022 07:38 AM

How  to export Complete CMDB in Excel format and when CI count is 1800000.

0 Helpfuls
  • 839 Views
2 REPLIES 2

Giles Lewis
Giga Guru

‎06-29-2022 09:04 AM

That is a really big spreadsheet. I suspect that you are not planning to manipulate a 1.8 million row spreadsheet in Microsoft Excel, because Excel is not designed to manipulate data sets of that size. I suspect that you are trying to move the data into another system (probably a database or some application) and you have chosen Excel as an intermediate file transfer format. I would suggest that an Excel export is probably NOT the best choice.

If you are trying to copy the data to database (such as Oracle or SQL Server), then there is an open source product at https://github.com/gflewis/sndml3 which can do a transfer of that size.

If you are trying to copy the data to another application, then you need to give us more details. The solution could be Integration Hub or REST API.

SebastianKunzke
Kilo Sage
Kilo Sage
In response to Giles Lewis

‎07-01-2022 11:09 PM

I agree with Giles. Without knowing your use case it will be difficult to help you.

However if you need it as excel I  would suggest to do the export class based. Because on a high level you otherwise will may loose some class specific attributes. In addition you may have CIs in your CMDB, where an export is not necessary (e.g. Disk, IP addresses), because that are just references. Over that you can reduce the amount of data. 

0 Helpfuls