FNMS Reports Download Issue

ImIronMan asked a question.

May 9, 2019 at 12:56 PM

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

FlexNet Manager Suite On-Premises

Top Rated Answers

DAWN H (Flexera Software)
7 years ago
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.
Expand Post
Selected as Best

All Answers

ImIronMan
7 years ago
Or any SQL query that I can use to download hardware specs, installed softwares for 170 devices ?
Expand Post
- BradAkers (Flexera Software)
  7 years ago
  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.
  Expand Post
DAWN H (Flexera Software)
7 years ago
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 ccjoin InstalledApplicationInfo appon cc.compliancecomputerid = app.ComplianceComputerIdwhere cc.computername = 'Steelers' -- apply your filterorder by cc.computername
Expand Post
- ImIronMan
  7 years ago
  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
  Expand Post
  - DAWN H (Flexera Software)
    7 years ago
    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.
    Expand Post
- ImIronMan
  7 years ago
  @DAWN
  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.
  Expand Post
  - DAWN H (Flexera Software)
    7 years ago
    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.
    Expand Post
    Selected as Best

Related Product Forums

→ Flexera One

→ Snow Atlas

→ FlexNet Manager

→ Snow License Manager

→ App Broker

Need help finding an answer?

Ask a Question →