Administration Guide › Accessing Collected Events with ODBC and JDBC › How Queries are Processed › Result Limits

Result Limits

To manage disk space, CA User Activity Reporting Module limits the number of result rows. CA User Activity Reporting Module uses a subset of the Transact-SQL TOP keyword with only a fixed value. The percentage variant of the keyword is not supported.

The default TOP value used in CA User Activity Reporting Module is 5000 rows, with a maximum value of 50,000 rows.