Devices that are not associated to certain SNMP profiles

Products

• DX NetOps
• CA Performance Management - Usage and Administration

Issue/Introduction

You just finished migrating devices to new snmpv3 profiles but you think there's a few devices left on the old profiles. Is there a way of getting a report of all the devices running on the old profiles?

Environment

Dx NetOps Performance Management any version

Resolution

1. Go to http://<YOUR DA>:8581/rest/profiles  - Make a list of profile names and corresponding profile item_id's (between the <ID> </ID> tags)
2. In Vertica, connect to vsql through adminTools and run the following commands:
   • \o /tmp/export.log ..... to save to a file

   • select item_id, name from dauser.v_item where item_id in (select item_id from dauser.v_attribute_instance where attr_qname = '{http://im.ca.com/inventory}ManageableDevice.SNMPProfileID' and long_value not in (466,465));

   • Where 466 and 465 would be the SNMP profile id's you want associated to the devices

This will give you a list of devices and id's that are NOT associated to those SNMP profile id's so you can update them as needed.