Best way to export CMDB data

[winnie_leung]

Dear Gurus,

I read the wiki on how to export CMDB data, we need to keep a offline record. Many of the ways are interactive and thus is not very practical for routine exporting.

How do you guys export CMDB records regularly? The only easy way I found is to schedule email reports. However, it is not very practical to open email one by one and save the attachment.

Is there any easy way to download or export the reports to local computers? Thanks!

Best Regards,

Winnie

[Bhavesh Jain1]

You may be interested in looking at below article

» Crossfuze Scheduled Data Extract

[m_servicenow]

Bhavesh,

I beleive Crossfuze Scheduled Data Extract is paid service. is there any tools or method by which we can export CMDB Data.

Regards,

Mukesh

[amadosierra]

Hi Winnie,

I have created a custom application in C# that downloads data from ServiceNow using Web Services since I have found that it was the best method to do it. I took the idea from the wiki (Web Services C Sharp .NET End to End Tutorial - ServiceNow Wiki) and ellaborated enough to download unlimited number of records or just from the past hour/day, depending on the frequency required.

There is an open source application that allows for more flexibility, it even lets you create download jobs from within your ServiceNow instance: ServiceNow Data Mart Loader | Free software downloads at SourceForge.net

The drawback for me was that I needed the data in a MSSQL database, not Oracle or MySQL as it is designed for, and at the time I knew about this tool I almost had it completed to my needs. Nonetheless, it seems like a great design and would love to create a version for MSSQL as well. Definetely worth checking it out.

Regards,

/Amado Sierra

[Bhavesh Jain1]

Nice to see such feature. Thanks for sharing.