Network Management

Custom table Resource only showing top 100 results in the Orion Web Console

When creating a custom table in Orion. If there are more than 100 entries in the table only the top 100 will be shown on the web console.

First published date

10/29/2018 3:56 PM

Last published date

10/28/2022 3:14 PM

Overview

This article provides brief information and steps to resolve the issue there are more than 100 entries in a table, and only the top 100 entries are shown on the Orion Web  Console. 

Product section

Orion Platform

Cause

The issue is caused when the setting is to set a maximum number 100 rows.

Resolution

Resolution 1:

  1. Go to the Orion Server and Open Database Manager then add default Orion server 
  2. Then expand the Orion database
  3. You can find the value in the WebSettings table as ReportingTableViewMaxRowCount
  4. Click on Enable table editing then change the ReportingTableViewMaxRowCount value to 200
  5. Click Enable table editing again and click execute query to check if the change occurred (If not, you may need to stop all Orion services on Orion service manager)


Resolution 2:

The default maximum number of rows permitted is 100. This can be changed by modifying the web.config file in the website folder.

1. Go to C:\Program Files\SolarWinds\Orion\Web.

2. Edit web.config file.
Change:
   

<add key="ReportingTableViewMaxRowCount" value="100" />


to:
   

 <add key="ReportingTableViewMaxRowCount" value="200" />


    
Note: You will need to make this change on the primary and any additional web servers if you have them.
3. Reload the web page.