When executing a custom report, you may hit a limit of 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 Integrate Flexera One ITAM data with ReportsExecute REST API. This article goes into detail about how to run the REST API execute call and includes an example PowerShell script that will save the results into a CSV file.