Release Notes › Known Issues › Queries and Reports › Queries Show No More Than 100,000 Rows

Previous Topic: Query Wizard Simple Filter Fails with Special Characters

Next Topic: Scheduled Reports With No Limit Option Selected Fail to Appear in PDF Format

Queries Show No More Than 100,000 Rows

Symptom:

When you query a database with more than 200,000 events, only 100,000 rows appear, even if the query Row Limit value is set higher than 100,000.

Solution:

The maximum number of rows displayed is 100,000 per database. If there is one database involved in the query only 100,000 rows are displayed. A query against multiple archive databases displays results beyond the 100,000 limit.