Can we limit number of rows returned in queries and reports?

[David77]

We have a number of users running large queries and reports during normal work hours that may be having a negative effect on performance. Is there a way we can put limits on number of rows returned for certain groups of users?
Thanks

[Sid_Takali]

Hi @David77 Refer this Docs https://docs.servicenow.com/bundle/washingtondc-application-development/page/use/reporting/concept/c...

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

[Community Alums]

Hi @David77 ,

Please refer below links 

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

https://docs.servicenow.com/bundle/washingtondc-api-reference/page/integrate/odbc-driver/reference/r...

https://docs.servicenow.com/bundle/tokyo-application-development/page/integrate/inbound-other-web-se...

https://docs.servicenow.com/bundle/washingtondc-mobile/page/administer/tablet-mobile-ui/task/configu...

Please mark my answer correct and helpful if this works for you

Thanks and Regards 

Sarthak