How can i export more than 1000 records (list) to excel. Role is report admin and ITIL Admiin?

Tanmay15
Kilo Explorer

‎02-17-2020 08:45 AM

I'm extracting Incident change and request since o6/01/2019 till date . the number of record for incidents is more than 20K ? when i export to pdf , it exports only 1000 record , where to configure for all the records to exported also how to select destination as excel and not pdf?

Labels:
0 Helpfuls
  • 1,955 Views
8 REPLIES 8

cmcclendon
Mega Guru
In response to Sukraj Raikhraj

‎02-21-2020 05:37 AM

Hi Sukraj. I am sure you know all of this, but I have common answers to that frequently-asked question. They either:

  • Don't know how to use ServiceNow
  • Don't have the access they need to manipulate data in ServiceNow
  • Don't know how to or don't have access to reporting in ServiceNow
  • Plan to use another reporting tool, like Tableau for reporting

First, I would suggest checking to see if this export is already being done. Next, I would get with your data mart / data lake team to see if you can have the data exported (as Adam suggested) there so more people can take advantage of it.

-Chris

0 Helpfuls

Adam Stout
ServiceNow Employee
ServiceNow Employee

‎02-18-2020 07:37 PM

As mentioned you can change the global limits, but why?  If you need to do this on a regular basis, I would look at Export Sets:  https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/export-sets/conce...

I recommend you check the docs for all your options:  https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/exporting-data/co...

Overall though, I always question why we need to export large sets of data.  That introduces timing issues (the data continues to change after you export it), security issues (no more ACLs), and actionability issues (you can't just click on the record and take action).

0 Helpfuls

cmcclendon
Mega Guru
In response to Adam Stout

‎02-19-2020 06:40 AM

Hi Adam. I am sure you know all of this, but I have common answers to that frequently-asked question. They either:

  • Don't know how to use ServiceNow
  • Don't have the access they need to manipulate data in ServiceNow
  • Don't know how to or don't have access to reporting in ServiceNow
  • Plan to use another reporting tool, like Tableau for reporting

Sukraj: First, I would suggest checking to see if this export is already being done. Next, I would get with your data mart / data lake team to see if you can have the data exported (as Adam suggested) there so more people can take advantage of it.

-Chris

 

 

0 Helpfuls