Getting all transactions from NRQL without limitations

How to get all events for a specified time interval. Right now there is a limit of 2000 events if I run
FROM Transaction SELECT * where xxx is NOT NULL AND LIMIT MAX WITH TIMEZONE ‘America/New_York’
We are basically checking if we can capture all transactions for few reporting and analysis purpose

Hello, @Balakumaran.Sugumar: There is a limit of 2000 results per query; it is not possible to increase this limit. The only way to get more data is to split your request into multiple queries, for example by using smaller time windows.

3 Likes

Thanks Phil … we will check for other available options

1 Like

Let us know what options you come up with :smiley: