Free script to identify which devices are assigned to a Vendor Certification

Document created by Lutz_Holzbecher Champion on Feb 5, 2016Last modified by SamCreek on Dec 17, 2016
Version 4Show Document
  • View in full screen mode

This document describes a custom Linux bash shell script that retrieves a list of all devices that are assigned to a given vendor certification.


Customers like to know which and how many devices are affected by a particular vendor cert.



  • shell access to one of the Data Repository / Vertica nodes
  • dbUser name (as specified on the DA in /opt/IMDataAggregator/apache-karaf-*/etc/dbconnections.cfg)
  • internal name of the vendor cert (can be full name or a substring)
    the internal name can be retrieved from CA PM user interface:
    on CA PC / Data Aggregator / Vendor Certifications, add the column for Internal Name:

Unpack the zip archive and copy the script file to a directory of choice on any Data Repository / Vertica node.


./ <dbUser name> <internal vendor cert name>



/ dauser HuaweiEntity



Your feedback is appreciated so please post any comments in this thread.  As with all free Infrastructure Management Field Developed Utility postings, inquiries should be made through questions or comments in this thread, and the author, Lutz_Holzbecher will provide a response.


All information downloaded or accessed (including field packs, customized solutions, patches etc.) are provided AS IS and no warranties are provided or made.  For more information you may click here.

2 people found this helpful