Software asset management user allocations report

[jm10000]

Hello all,

I am trying to figure out the best way to display software entitlement (by software product or model) user allocations remaining/available, compared to total count of entitlements purchased (purchased rights). I'm looking for it to be in something presentable (report, dashboard, etc.) and/or just easy to read. Put simply: We have X remaining allocations for Y software, out of Z total purchased entitlements.

I was surprised something like this does not appear to be a OOTB report or on a dashboard, but I could have missed something.

I've tried creating a bar graph report utilizing the software entitlement table, 'group by' software model, 'additional group by' set to purchased rights...and then stacking by software model. This DOES work, however, only for software models with a single software entitlement. So, anything we have multiple mid-term purchases for, shows up with a separate bar for each SE. 

Any suggestion on the best approach for displaying this data? Happy to clarify or provide additional information as needed. Thank you!

[Engelica Adalia]

@jm10000 You can utilize the software asset workspace for this. Once you run the reconciliation, it shows you the current license position of each product. Under the license usage, you can see all Publishers and products you have (showing you if you are compliant or not). It will also show you the licenses you owned (per product) and licenses required (consumed) and licenses available (remaining). I think this is what you are looking for when you mentioned "Put simply: We have X remaining allocations for Y software, out of Z total purchased entitlements."

Here's a sample screenshot of what the "License Metric Results" look like: 

[iamkurt]

@Engelica Adalia- I just created an allocation for a new user on alm_entitlmement_user table and ran the reconciliation but the count does not decrease by 1 in License Metrics in the screenshot you posted. What might I be doing wrong?