SMP report results are restricted to 50,000 rows

Products

• IT Management Suite
• Client Management Suite

Issue/Introduction

When running reports from the Symantec Management Platform (SMP), the reports return only 50,000 rows by default even when many more rows are expected.

Environment

ITMS 8.5, 8.6, 8.7

Cause

By default all reports have a configured limit to return only 50,000 rows. This is by design and is to protect the Symantec Management Platform from reports that might otherwise slow down performance significantly, or even crash the Symantec Management Platform if the reports are poorly written (such as custom reports). 

Significant internal testing and customer feed-back has shown that this 50,000 row limit is ideal, and generally should not be altered without extreme caution.

Resolution

There is a setting that can be used to increase this 50,000 row limit, and it is a coreSettings value in "ReportMaxRowCount".

For version 8.5 and later, the suggested changes should be made to the core settings under the SMP Console at:

Settings menu > Notification Server > Core Settings

   

Additional Information

253073 Not all resources are returned while searching on a page