When executing a custom report, you may hit a limit at one million rows of data returned within the Flexera One UI. To combat this, the following workarounds are available:
- Create multiple custom reports using advanced filters to reduce the number of expected results.
For example, a report showing all installed applications within Flexera One could easily hit the limit of one million results. As a workaround, you can create multiple reports with different filters to show specific applications.
The report below shows only applications with names between "A" and "B," so only applications starting with the letter “A” will be shown.
- Run a custom report via the REST API, which has no limit on the results returned.
For more details, see The New Generic ITAM REST API for querying any web report is available! A PowerShell example. This article goes into detail about how to run the REST API execute call and includes an example PowerShell script which will save the results into a CSV file.
