FNMS DB query

[raghuvaran_ram]

Hi,

Can anyone help me to identify DB query to extract the below details.

Publishers value (sum of PO - Budget)
Count of publishers (for which PO is created and managed)
Count of applications
Publisher vs application count (applications mapped to the inscope publishers)
Status of publishers (compliant/non-comp)
Status of application (compliant/non-comp)
License type and its count
Under utilized license less than 80%
Renewal due for next 30/60/90 Days
License type (Per/sub)
Unprocessed Purchases

[JohnSorensenDK]

@raghuvaran_ram 

Please would you mind elaborating on why you want to run database queries instead of using the solution's UI and reporting capabilities?

Thanks,

[raghuvaran_ram]

The details available in flexra management view dashboard is not editable and for us its not a true picture. so in order to customize that I need these datas from DB.

[JohnSorensenDK]

@raghuvaran_ram 

Flexera's management dashboard will become editable, please refer to Early preview of Configurable Management Dashboard did you try this?

If you have found dashboard widget that produces incorrect results then please create a support case so that it can be corrected.

For creating your own database queries, please refer to FlexNet Manager Suite Schema Reference 

Thanks,

[raghuvaran_ram]

Hi JohnSorensenDK,

we are using 2020 R1 and I could not find any option for editing or creating a new dashboard. Can you guide me where and which one to choose.

[JohnSorensenDK]

@raghuvaran_ram 

Please refer to the subsections to Customizable Management Dashboard 

Thanks,