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
Application Life Cycle info (if available) is in the SoftwareTitle view. You can relate that through the "SoftwareTitleID" available on the InstalledApplicationInfo view.
The Status is the SoftwareTitle.SoftwareTitleActionID Column - which can have a value of 1 - 6. 1 = Unmanaged, 2 = Authorized, 3 = Unauthorized, 4 = Ignored, 5 = Inactive, 6 = Deferred.
For additional table information, there is a Schema Reference available from your Online Help Home page with a complete list of objects available for query.
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.
I would try downloading as a CSV rather than Excel for large datasets.
You can join the ComplianceComputer and InstalledApplicationInfo views (on compliancecomputerid) to get the same information.
Example:
select *
from ComplianceComputer cc
join InstalledApplicationInfo app
on cc.compliancecomputerid = app.ComplianceComputerId
where cc.computername = 'Steelers' -- apply your filter
order by cc.computername
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
While there IS an Operator available in Advanced Filters called "Is Any Of" - it does not appear to limit to a list as I expected (in my reference 2018 R2 implementation). Utilizing a set of "OR" operators is likely your best bet at this time.
Application Life Cycle info (if available) is in the SoftwareTitle view. You can relate that through the "SoftwareTitleID" available on the InstalledApplicationInfo view.
The Status is the SoftwareTitle.SoftwareTitleActionID Column - which can have a value of 1 - 6. 1 = Unmanaged, 2 = Authorized, 3 = Unauthorized, 4 = Ignored, 5 = Inactive, 6 = Deferred.
For additional table information, there is a Schema Reference available from your Online Help Home page with a complete list of objects available for query.
