CMDB Export - All Fields

talkijibb
Kilo Explorer

I need an export/report from our CMDB that includes all CIs and all fields within each Configuration Item. I haven't gotten past the cmdb_ci report and that is not what I'm looking for. TIA!

2 REPLIES 2

Patrick DeCarl1
ServiceNow Employee
ServiceNow Employee

Hi,



You can add below sysparm to your url to get all fields exported from the table you need.


  /cmdb_ci_list.do?CSV&sysparm_default_export_fields=all



Determining which list fields are exported


HugoFirst
Kilo Sage

Hello C S,



I had great luck exporting in JSON format.   The result is easy to parse, you get all the fields, and you can specify display_value=true so you will see names and not sys_id's for people, groups, etc.



Here's a couple of links to check:


Export directly from a URL  



Also, if you will export more than 10,000 records, you'll need to export in segments.   See this page to learn about that:


Break up a large export