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
‎Nov 05, 2020 03:40 AM
Please would you mind elaborating on why you want to run database queries instead of using the solution's UI and reporting capabilities?
Thanks,
‎Nov 09, 2020 02:23 AM
‎Nov 09, 2020 07:04 AM
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,
‎Nov 10, 2020 04:07 AM
‎Nov 17, 2020 02:38 AM
‎Nov 20, 2020 02:46 AM