Generate List of Devices using Vendor Cert

Products

• Network Observability
• CA Performance Management

Issue/Introduction

We are wondering if it's possible to generate a list of devices that are using a specific vendor certification. The reason being we want to evaluate the impact on modifying the order of a metric family.

Query for Vendor Certificates associated with devices

Is there a mechanism to query a vendor certificate associates with a device? API call or mysql query?

Need to move priority of Cisco vendor cert for memory, I would like to know if vendor certs will be changed on what devices.

Environment

All supported DX NetOps Performance Management releases

Resolution

The recommended method to generate lists of devices using target Vendor Certifications (VCs) is the Data Aggregator OData OpenAPI queries.

Using the Query Builder this is a sample basic query.

The VendorCertDisplayName value is the VC name seen in the Portal UI. The one in the sample would return any VC with the word 'memory' in it.

Additional Information

These Data Repository based VSql queries can be used to see all devices that have ever at any time had support for a given VC. Devices can, over time due to a variety of reasons, support 2 or more Vendor Certifications under a given Metric Family. They normally only support one at a time, which is what makes the Odata queries are more accurate showing only what is currently used by the device.

This query will return all devices that have ever supported the UCDavisCPUMib VC. It uses the VC Internal Name.

• select distinct vif.item_id, i.item_name from item i JOIN poll_item pi ON pi.device_item_id=i.item_id JOIN v_item_facet vif ON vif.item_id=pi.item_id where vif.facet_qname = '{http://im.ca.com/certifications/snmp}UCDavisCPUMib';

This query returns all devices and all VC's they've supported. Can filter the data to find lists of devices as needed.

• select i.item_id, i.item_name, ai.string_value from v_current_list_attribute_instance ai join item i on i.item_id=ai.item_id join device d on d.item_id=i.item_id where ai.attribute_id=(select attribute_id from v_attribute where attr_qname='{http://im.ca.com/normalizer}NormalizedMemoryInfo.SourceFacetTypes');