Hi,
On a customer request, I've created a report in FNMS Reports section (FNMS 2017R3) - for All Softwares installed, HW configuration across all devices. The number of total rows are around 10,000,00. When I tried to download the report in excel format, it failed.
I tried to download it multiple times applying filters on few columns. In any filter, the number of records are no less than 120,000. Even this report also failed to download.
Is there any specific limit of records that FNMS is capable of exporting to csv or excel ? How can we download the reports if the records are more than 100,000
Regards
Rajesh Ponnala
May 09, 2019 07:56 AM
May 10, 2019 09:10 AM
May 09, 2019 07:58 AM
If this is on prem please check the WebUI log located on C:/ProgramData/Flexera Software/Compliance/Logging/WebUI. This will give you the error. If this is a cloud account please open a support ticket to have the operations team check on the report in the background.
To answer your question there is no hard and fast rule. It is based on the browser that is being used normally. In the WebUI reports will be maxed at 1,000,000 rows.
May 09, 2019 08:35 AM
May 09, 2019 04:25 PM
Thanks @DAWN and @BradAkers for your responses.
I can download the reports with out any issues (not sure why its started working now), but maxed out at 1000000.
This is seems to be excel limitation.
I have a followup question on this reporting that -
When we create a new custom report in Reports section and using advanced filter - Is there any way that I can select multiple devices in a single line against inventory device name, instead selecting inventory device name multiple times with "or" option ? This would really help us running reports for different scenarios
May 10, 2019 06:56 AM
May 10, 2019 08:55 AM
Thanks for the sql query, that really helped me.
Also, against the same previous query, how can we add the
1. applications's status (active/unauthorized/deffered...etc.,)
2. application's life cycle information like start of life, end of sales/support/extended support etc.
May 10, 2019 08:56 AM - edited May 10, 2019 08:58 AM
May 10, 2019 09:10 AM