Max number of records for report

[Aniket Shukla]

Hello, Does anyone know the Max number of records(displayed in months) that can be returned when using COLUMN type report which is trend by a Date type field, Calendar is Standard Calendar, per is Month and Aggregation by Count.

[Aniket Shukla]

@Ankur Bawiskar 

Currently it's showing based on available data but need to know the Max number of records it can show

[Community Alums]

Hi @Aniket Shukla ,

Please check the below links:

https://www.servicenow.com/docs/bundle/xanadu-platform-administration/page/administer/exporting-data...

https://www.servicenow.com/community/developer-forum/maximum-number-of-records-returned-using-query/....

It looks like the maximum records that can be returned from a query is 10,000. 

Please mark my response as helpful or correct in case if this helps.

Regards,

Bhavani