CMDB CI backup

Azamat M_
Kilo Contributor

Hello,

I am learning about how to best export data from CMDB, the intend is to be able to backup all of our CMDB data in an another storage (local file, or MID servers). So far I have used export sets that ServiceNow provides, which create an xml file and exports the selected CMDB table into a MID server, however this is not an ideal solution for our company. An xml file created by export set, does not distinguish data from any sub-tables that might be associated with the target table,

for example;

CMDB_CI has multiple child tables and export set doesn't do a good job of identifying the relationship between the tables. This will cause us issues when and if we have to re-import the backup data back into our CMDB.

 

I was just wondering if anyone knows or have done similar task with their instance, that would help me to export data more efficiently. Any guidance or suggestion is much appreciated! 

 

Thank you,

 

Azamat M

1 REPLY 1

sachin_namjoshi
Kilo Patron
Kilo Patron

i implemented solution to export CMDB class CI records from service now to external oracle remote db instance.

we used data pump utility to export CI records periodically based on condition in oracle database instance.

 

Check below for this utility

 

https://sourceforge.net/projects/servicenowpump/

 

Regards,

Sachin