question export limits for scheduled list reports in Platform Analytics forum

export limits for scheduled list reports

Casey12 — Wed, 03 Jul 2019 18:39:46 GMT

Do list reports that get "exported" via a scheduled e-mail respect the export limits in the platform, as defined below?

https://docs.servicenow.com/bundle/madrid-platform-administration/page/administer/exporting-data/concept/c_ExportLimits.html

For example, if I currently have my CSV Format export row limit set at 250k rows, if this row limit is exceeded in a scheduled e-mail of a list report (in csv format), will the file be truncated?

Re: export limits for scheduled list reports

Prateek kumar — Wed, 03 Jul 2019 19:14:47 GMT

Yes it will be.

Re: export limits for scheduled list reports

Allen Andreas — Wed, 03 Jul 2019 19:16:03 GMT

I would imagine so, as I doubt this "loop-hole" exists, haha. You could always test this yourself and click "execute now" for the scheduled report and see what happens.

Please mark reply as Helpful/Correct, if applicable. Thanks!

Re: export limits for scheduled list reports

Prateek kumar — Wed, 03 Jul 2019 19:18:53 GMT

https://docs.servicenow.com/bundle/istanbul-performance-analytics-and-reporting/page/administer/exporting-data/concept/c_ExportLimits.html

https://docs.servicenow.com/bundle/london-servicenow-platform/page/administer/notification/reference/r_AttachmentLimitProperties.html

Re: export limits for scheduled list reports

Snehal13 — Fri, 26 Jul 2024 10:39:17 GMT

When I send a scheduled report of XLS with 7k records to 11 email ids, it doesnt go. When i send it to 2 people with email, it goes ? why so

Re: export limits for scheduled list reports

thoemu_s — Tue, 27 Aug 2024 14:03:50 GMT

When I try to access the links to the documentation I get a “404” result.

I have tried it with a scheduled job which is executed daily at 9 pm. All incidents that were opened “today” are requested.

When I run this manually, I receive the two messages in the syslog that it has started and finished, but the two recipients (censored here) do not receive any mail.

What is wrong?

If I use the function on the incident list (Export > Excel > Mail) then I receive the mail and the desired attachment. So that works.

// Create a new GlideRecord instance var gr = new GlideRecord('incident'); // Log a message indicating that the job has been started gs.info('The Scheduled Job has been started'); // Add a query to get only incidents that were opened today gr.addQuery('opened_at', 'ON', gs.daysAgoStart(0)); gr.query(); // Rest of your script... // Create a variable to store the CSV data var csv = ''; // Run through the results of the query while (gr.next()) { // Add the data of each incident to the CSV variable csv += gr.number + ',' + gr.short_description + ',' + gr.opened_at + '\n'; } // Create a new email var mail = new GlideEmailOutbound(); mail.setSubject('List of incidents opened today'); mail.setBody('Attached you will find a list of the incidents opened today in CSV format'); mail.addTo('Recipient1'); mail.addTo('Recipient 2'); // Add the CSV data as an attachment to the email mail.addPart(csv, 'text/csv', 'incidents.csv'); // Send the e-mail mail.send(); // Log a message indicating that the job has been started gs.info('The scheduled job has finished');