cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Is there a query I can run to replace all "Top 0" with "100000"

bob_zins
Helper

After upgrading NAM to latest version I receive the following message on many reports. "Top must be positive number. Top 0 is replaced by top 100 000". It would take a lot of time to edit all the sections that I have a zero in the top rows setting. Is there a query I can run to replace all "top zeros" with "100000".


3 REPLIES 3

Erik_Soderquist
Dynatrace Pro
Dynatrace Pro

I've done it in the past with exporting the reports, a sed script, and importing the modified reports.


I'm not aware of a supported SQL script to do it.


-- Erik



I'm testing the process in my non-prod env. I exported the reports.xml and did a search on max rows "0" and replaced it with max roes "100000" . Do I just import the updated file? Will it replace the Sections & reports that are there without creating duplicates? .


Hi Bob,


As long as report names are not changed, existing reports will be overwritten by fixed ones. However, it might happen that you'll need help with importing built in reports. My hint would be to ask Support Team for help in such case.


Best Regards


Jacek