How to Increase Max Rows for "Interface 95th Percentile Trend Scorecard" ?
search cancel

How to Increase Max Rows for "Interface 95th Percentile Trend Scorecard" ?

book

Article ID: 386857

calendar_today

Updated On: 03-26-2025

Products

Network Observability CA Performance Management

Issue/Introduction

We would like to increase the Results Limit for the Performance Management Chart "Interface 95th Percentile Trend Scorecard" .

The Max Rows is limited to 500 lines - is there a (hidden) way to increase this limit in DX NetOps 23.x or 24.x?

Environment

All supported DX NetOps Performance Management releases

Resolution

The following SQL statements will allow for the  "Interface 95th Percentile Trend Scorecard" view on the page number (replace in statement where you see <PAGE_NUMBER> in UPDATE and SELECT). 

NOTE: If the customer reverts the view to the out of the box configuration will need re-apply maximum item count.

The below alteration will persist for view on that page after any upgrade, and as need can be applied to more than one page.

----------------------------

UPDATE model_properties SET PropertyValue = 5000 WHERE PageID = <PAGE_NUMBER> AND ModelID = 1000293 AND MapName = 'Settings/ResultsLimit' AND PropertyName = 'SettingInvalidMessage';

SELECT  PageID,  ModelID,  TemplateID,  InstanceID,  TenantID,  UserID,  MapName,  PropertyName,  PropertyType,  PropertyValue,  Package FROM model_properties WHERE PageID = <PAGE_NUMBER> AND ModelID = 1000293 AND MapName = 'Settings/ResultsLimit' AND PropertyName = 'SettingInvalidMessage';

----------------------------

As an example:

NOTES:

- Do NOT use the "PageID=0" as that would be the out of the box and then would be applied to any NEW view configuration. Use the recommended approach to get the specific page as shown above.

- If unsure what the page number is that an be obtained from the URL: http://<portal>:8181/pc/desktop/page?mn=3&globalsearchtype=names&pg=2003456&startTime=2023-03-29+12:06&endTime=2023-03-30+12:06

- The screen capture above was just to help with the SQL statements as well as show the resulting behavior when applied.


Of course, there is the caveat: "Use as your own needs, but such a configuration is above and beyond the normal sanction operations for the application".