DX UIM license data

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

My client wants information regarding UIM license usage, they tried to use the usage_metering probe but the data it shows in the report is from the year 2021 to 2023. Is there any other method to obtain this data? 

Environment

• DX UIM v23.4

Cause

• Guidance

Resolution

Hub, robot, and probe-level licensing requirements have been removed from DX UIM.

"Perpetual License” means a license to use Broadcom Software for an indefinite period subject to compliance with the Agreement.

We have the usage_metering probe which will calculate the number of billable items based on whether QoS or Alarms are generated from probes(If any QoS or alarms are enabled).

usage_metering underlying query:

select
            a.cs_id,a.origin,a.ip,a.name,a.probe_name,a.robot,a.qos,totalcapacity,selectedcapacity
            from (select
            cs_id,origin,ip,name,probe_name,robot,qos,sum(samplevalue) as
            totalcapacity
            from (select
            ccim.ci_metric_id,
            cci.ci_id,
            ccs.cs_id,
            cci.ci_name,
            ccs.ip,
            sqd.origin,
            ccs.name,
            probe_name = sqd.probe,
            cd.dev_id,
            sqd.qos,
            sqd.robot,
            sqs.samplevalue
            from cm_computer_system ccs
            inner join cm_device cd on ccs.cs_id=cd.cs_id
            inner join cm_configuration_item cci ON cd.dev_id = cci.dev_id
            inner join cm_configuration_item_metric ccim on cci.ci_id = ccim.ci_id
            inner join s_qos_data sqd ON sqd.ci_metric_id = ccim.ci_metric_id and
            qos in ('QOS_STORAGE_TOTAL_CAPACITY') and sqd.probe in
            ('hp_3par','netapp_ontap','vnxe_monitor','celerra','clariion','hitachi','ibm-ds','ibm_svc','ibm_ds_next','netapp_ontap','purestorage','vmax','vplex','xtremio','nutanix_monitor','netapp','ceph')
            inner join s_qos_snapshot sqs on sqd.table_id=sqs.table_id and
            sqs.sampletime > dateadd(hour,-24,GETDATE())
            ) as tmp2 group by cs_id,origin,ip,name,probe_name,robot,qos) as a
            left outer join
            (select cs_id,origin,ip,name,probe_name,robot,qos,sum(samplevalue) as
            selectedcapacity
            from (select
            ccim.ci_metric_id,
            cci.ci_id,
            ccs.cs_id,
            cci.ci_name,
            ccs.ip,
            sqd.origin,
            ccs.name,
            probe_name = sqd.probe,
            cd.dev_id,
            sqd.qos,
            sqd.robot,
            sqs.samplevalue
            from cm_computer_system ccs
            inner join cm_device cd on ccs.cs_id=cd.cs_id
            inner join cm_configuration_item cci ON cd.dev_id = cci.dev_id
            inner join cm_configuration_item_metric ccim on cci.ci_id = ccim.ci_id
            inner join s_qos_data sqd ON sqd.ci_metric_id = ccim.ci_metric_id and
            qos in ('QOS_STORAGE_TOTAL_CAPACITY') and sqd.probe in
            ('hp_3par','netapp_ontap','vnxe_monitor','celerra','clariion','hitachi','ibm-ds','ibm_svc','ibm_ds_next','netapp_ontap','purestorage','vmax','vplex','xtremio','nutanix_monitor','netapp','ceph')
            inner join s_qos_snapshot sqs on sqd.table_id=sqs.table_id and
            sqs.sampletime > dateadd(hour,-24,GETDATE())
            inner join
            (select cci.ci_id,count(*) as cnt
            from cm_computer_system ccs
            inner join cm_device cd on ccs.cs_id=cd.cs_id
            inner join cm_configuration_item cci ON cd.dev_id = cci.dev_id
            inner join cm_configuration_item_metric ccim on cci.ci_id = ccim.ci_id
            inner join s_qos_data sqd ON sqd.ci_metric_id = ccim.ci_metric_id and
            sqd.probe in
            ('hp_3par','netapp_ontap','vnxe_monitor','celerra','clariion','hitachi','ibm-ds','ibm_svc','ibm_ds_next','netapp_ontap','purestorage','vmax','vplex','xtremio','nutanix_monitor','netapp','ceph')
            inner join s_qos_snapshot sqs on sqd.table_id=sqs.table_id
            where sqs.sampletime > dateadd(hour,-24,GETDATE()) group by cci.ci_id
            having count(*) > 1) as tmp
            on cci.ci_id=tmp.ci_id) as tmp2 group by
            cs_id,origin,ip,name,probe_name,robot,qos) as b
            on a.cs_id=b.cs_id and a.origin=b.origin and a.ip=b.ip and
            a.probe_name=b.probe_name and a.robot=b.robot and a.qos=b.qos