License Compilations

Cervage

What will be the best way to compile a count of how many licenses have been assigned in the system to ensure more than purchased LICENSES aren't consumed?

If you have implemented this please share

Admin Console SQL DateBase Query tool Or Creating a special Query to track this?

Thanks!!

Admin

Hi Cervage , are you asking IBM Support or asking other customers? 🙂

For reference, if others need it, here's the current license documentation:

4.5 License metrics and concurrent usage
https://www.ibm.com/docs/en/tap/4.5?topic=management-license-metrics-concurrent-usage

Copying @such , @jeff_long .

Cervage

Admin Customers

I did try this Not exactly what I want

SELECT TO_CHAR(time_snapshot, 'MM-DD-YYYY') AS "Date",

   MAX(users) AS "Total Users",
   MAX(L_3048) AS "IBM Facilities and Real Estate Management on Cloud Approvals and Reporting",
   MAX(L_3050) AS "IBM Facilities and Real Estate Management on Cloud Enterprise",
   MAX(L_3053) AS "IBM Facilities and Real Estate Management on Cloud Occasional Enterprise User",
   MAX(L_3055) AS "IBM Facilities and Real Estate Management on Cloud Connector for Watson Analytics",
   MAX(L_3017) AS "IBM TRIRIGA Application Builder",
   MAX(L_3007) AS "IBM TRIRIGA CAD Integrator/Publisher",
   MAX(L_3021) AS "IBM TRIRIGA Connector for Business Applications"

FROM license_metric
WHERE time_snapshot >= TO_DATE('01-01-2023', 'MM-DD-YYYY')
AND time_snapshot <= TO_DATE('01-31-2023', 'MM-DD-YYYY')
GROUP BY TO_CHAR(time_snapshot, 'MM-DD-YYYY')
ORDER BY TO_CHAR(time_snapshot, 'MM-DD-YYYY');