FNMS DB query
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)
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
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.