Performance Management Inventory per Item and Device

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

We are looking for the ability to find out item count total, per device and what device type is utilizing the most items in Performance Management Data Aggregator.

Environment

All supported Performance Management releases

Resolution

Performance Management inventory can be counted per Device or per Item. Each individual polled item, often referred to as component items, whether a device item or a lower component item under the device, are counted as one item in Inventory.

For example if we look at a 'standard' Router or Switch, basic items expected would be the device itself, CPU, Memory and Interfaces. For this example we'll assume the device has 4 CPUs that create 4 CPU items, 2 memory items and 10 interfaces. The items would total out to:

• 1 device item
• 10 interfaces items
• 4 CPU items
• 2 memory items
  • 17 items total

Note that there isn't a simple or direct way to align these. To start these are some of the sample queries that show Inventory via the Data Repository database.

They include sample output from a support lab system. Each query ends with "limit 20" to limit the results to the top 20. Can remove it to get all results, or change the limit count as needed to increase or lower the resulting output.

To list out devices and how many component items each has discovered we'd use the following vsql command.

• select device_item_id, device_name, count(*) from dauser.v_poll_item where item_id in (select item_id from dauser.v_item_facet where facet_qname like '%Virtual%') group by device_item_id, device_name order by 3 desc limit 20;

Sample output:

dradmin=> select device_item_id, device_name, count(*) from dauser.v_poll_item where item_id in (select item_id from dauser.v_item_facet where facet_qname like '%Virtual%') group by device_item_id, device_name order by 3 desc limit 20;

device_item_id |           device_name            | count

----------------+----------------------------------+-------

         5528 | <DeviceName>        |   495

           5672 | <DeviceName>        |   267

           5613 | <DeviceName>        |   125

           5582 | <DeviceName>        |    24

           5609 | <DeviceName>        |    22

           5488 | <DeviceName>        |    21

           5615 | <DeviceName>        |    17

           5693 | <DeviceName>        |    16

           5654 | <DeviceName>        |     7

           5490 | <DeviceName>        |     4

           5577 | <DeviceName>        |     3

           5495 | <DeviceName>        |     3

           5506 | <DeviceName>        |     3

           5731 | <DeviceName>        |     3

           5719 | <DeviceName>        |     3

           5726 | <DeviceName>        |     2

           3989 | <DeviceName>        |     2

          84111 | <DeviceName>        |     2

           1378 | <DeviceName>        |     2

           5596 | <DeviceName>        |     2

(20 rows)

This will list out item counts per Metric Family. The name at the end, NormalizedReachabilityInfo for example, is the internal name of the Metric Families.

• select REPLACE(facet_qname, '{http://im.ca.com/normalizer}', '') facet_qname, count(*) from dauser.v_item_facet where facet_qname like '%normalizer%' group by 1 order by 2 desc limit 20;

The internal name can be exposed as a column in the UI Metric Families page to align with the UI Metric Family names.

Sample output:

dradmin=> select REPLACE(facet_qname, '{http://im.ca.com/normalizer}', '') facet_qname, count(*) from dauser.v_item_facet where facet_qname like '%normalizer%' group by 1 order by 2 desc limit 20;

                facet_qname                | count

-------------------------------------------+-------

 NormalizedReachabilityInfo                |    75

 NormalizedPortInfo                        |    64

 NormalizedAvailabilityInfo                |    64

 NormalizedSystemInfo                      |    62

 NormalizedDevicePollingStatistics         |    62

 NormalizedMemoryInfo                      |    58

 NormalizedCPUInfo                         |    58

 NormalizedAddressInfo                     |    57

 NormalizedAlternatePortInfo               |    51

 NormalizedChassisTemperatureEnvSensorInfo |    50

 NormalizedChassisFanEnvSensorInfo         |    49

 NormalizedChassisPowerSupplyEnvSensorInfo |    47

 NormalizedProcessCpuUsageInfo             |    43

 NormalizedPartitionsInfo                  |    40

 NormalizedUDPInfo                         |    24

 NormalizedJitterInfo                      |    24

 NormalizedTCPInfo                         |    24

 NormalizedICMPInfo                        |    24

 NormalizedRTTMonHTTPInfo                  |    24

 NormalizedPathEchoInfo                    |    24

(20 rows)

This will list out item counts per Vendor Certification. The name at the end, ICMPReachability or IfXTableMib for example, are the internal names of the Certifications.

• select REGEXP_REPLACE(facet_qname, '{http://im.ca.com/certifications/.*}', '') facet_qname, count(*) from dauser.v_item_facet where facet_qname like '%certifications%' group by 1 order by 2 desc limit 20;

The internal name can be exposed as a column in the UI Vendor Certifications page to align with the UI Vendor Certification names.

dradmin=> select REGEXP_REPLACE(facet_qname, '{http://im.ca.com/certifications/.*}', '') facet_qname, count(*) from dauser.v_item_facet where facet_qname like '%certifications%' group by 1 order by 2 desc limit 20;

         facet_qname         | count

-----------------------------+-------

 ICMPReachability            |    75

 systemMib                   |    64

 SNMPDevicePollingStatistics |    62

 IfXTableMib                 |    58

 ipAddrTableMib              |    57

 AlcatelEthernetDOT3Mib      |    47

 CiscoISOProcessMib          |    39

 CiscoCPUMibRev              |    38

 IfTableMib                  |    30

 CiscoFRUPowerSupplyMib      |    29

 CiscoCPMMemMib              |    29

 CiscoFlashPartitionMib      |    27

 CiscoFRUFanMib              |    25

 CiscoSysEnvSenTemp          |    25

 CiscoRttMonStatsMib         |    24

 RttMonHTTPMib               |    23

 CiscoSysEnvPowerSupply      |    21

 CiscoSystemEnvTempCel       |    21

 CiscoIPSLAJitterMib         |    18

 CiscoMemMib                 |    18

(20 rows)