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
  • 645 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