Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to extract report more than 10k records using database view

PatriciaA987250
Tera Expert

‎08-08-2024 02:18 AM

Hi

 

Im creating a report using export set and the export definition is through database view. The report will be exported to mid server in a csv format. Currently, im having issue with the report extraction where by the report does not contain the complete record (i.e. expected: 96 000 rows, exported: 10001 rows). I've done the necessary configuration, kindly refer to the attachment.  Please help me with solutions. 

 

Preview file
22 KB
Preview file
31 KB
0 Helpfuls
  • 785 Views
1 REPLY 1

shiwan_agrawal
ServiceNow Employee
ServiceNow Employee

‎08-20-2024 10:47 PM

@PatriciaA987250 Try the following steps:

1. Go to Import Export under System Properties and open

2. Try updating the Row Limits and see if that helps

shiwan_agrawal_0-1724219144539.png

 

NOTE: Keeping higher numbers while exporting data to csv/excel isn't recommended as it may create performance issues and hence, this must be tested properly.

 

If this helps answering your question, please mark this as "Accepted Solution".

 

-Shiwan Agrawal

0 Helpfuls