Ask the Community
Groups
Overcoming the Historical Performance Reporting limit of top (or bottom) 200 - Connect IT Community | Kaseya
<main> <article class="userContent"> <p><strong>QUESTION</strong></p> <p>How do I overcome the Historical Performance Reporting limit of top (or bottom) 200</p> <p><strong><br>RESOLUTION</strong></p> <p><strong>Limitation:</strong></p> <p>The main reason for limiting the number of rows on custom reports is to avoid a performance bottleneck on the DGE database(es) and how it would affect overall performance. This can manifest in either delays on the Web Application as users drill-down into summary pages, historical data, etc and/or a backlog of collected results waiting to be written to the DGE database</p> <p><strong>Limitation:</strong><br>You will need to re-apply these changes after installing a newer version of Traverse</p> <p><strong>Answer:</strong></p> <p>In order to enable up to 500 rows, please edit TRAVERSE_HOME\webapp\user\performanceReportInput.jsp and TRAVERSE_HOME\webapp\admin\performanceReportInput.jsp on the BVE server (TRAVERSE_HOME is the Traverse installation directory). Open the file in notepad/vi or your editor of choice and locate the following section:</p> <p><html:select name="performanceReportForm" property="numItems"><br><html:option value="10">10</html:option><br><html:option value="25">25</html:option><br><html:option value="50">50</html:option><br><html:option value="100">100</html:option><br><html:option value="200">200</html:option><br></html:select></p> <p>You can insert additional selection options before the </html:select> tag like this:</p> <p><html:select name="performanceReportForm" property="numItems"><br><html:option value="10">10</html:option><br><html:option value="25">25</html:option><br><html:option value="50">50</html:option><br><html:option value="100">100</html:option><br><html:option value="200">200</html:option><br><html:option value="500">500</html:option><br></html:select></p> <p>Once you save the files and navigate to Reports -> Custom -> Performance Reports, you should see the new options in the drop-down list.</p> <p>No components need be restarted.</p> <p><strong><br>APPLIES TO<br></strong>All versions of Traverse</p> <p><br><strong>REFERENCE <br></strong><strong>-</strong></p> </article> </main>