Dashboard returns only 100 rows

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

I have a dashboard with a "series' graph. I used a SQL query and it seems that the number of rows that is returned is limited. I used the query "select to_char(time,'YYYY-MM-DD HH24'),count(*)  from nas_transaction_log where prid like 'snmptd' and origin like 'CMZ' and severity like 'major' GROUP BY to_char(time,'YYYY-MM-DD HH24') order by to_char(time,'YYYY-MM-DD HH24')" and the last row returns is: 2019-08-06 19        4671

If I changed my query to: "select to_char(time,'YYYY-MM-DD HH24'),count(*)  from nas_transaction_log where prid like 'snmptd' and origin like 'CMZ' and severity like 'major' GROUP BY to_char(time,'YYYY-MM-DD HH24') order by to_char(time,'YYYY-MM-DD HH24') desc" and the first row is: 2019-08-08 14 so that means that inside the database there's some data for today and yesterday's date.

It seems that the output is restricted to only 100 rows, is it possible? Could we change the value?

Environment

Release : 8.51

Component : UIM - UMP_DASHBOARD

Resolution

The max rows I get back is 100, even if the results should be much more than that. Unfortunately, we do not expose any option to tweak this max row count. 

The CA BI reports may be an option for you. Ad Hoc Reports or Custom reports will allow you to being back more than 100 rows.