DX Infrastructure Manager

Expand all | Collapse all

How to delete profiles from snmpcollector

Jump to Best Answer
  • 1.  How to delete profiles from snmpcollector

    Posted 08-23-2016 11:16 AM

    Is there a way to efficiently delete multiple profiles from snmpcollector?



  • 2.  Re: How to delete profiles from snmpcollector
    Best Answer

    Posted 08-23-2016 11:44 AM

    Hi Recarter,

    There isn't any GUI way to do that apparently (afaik). However, If you are using snmpcollector 3.2x (requires UIM 8.4) you can delete the devices running a delete query against the H2 database that contains the snmpc configuration. Please, before making any change ensure that you backup your entire snmpcollector folder. I have tested this on a small subset of devices and it worked fine - However, this is undocumented and not an out of the box feature, consider it as a work around and please prepare for a rollback if needed.

     

    go to http://<snmpcollector_robot_ip_or_hostname>:9715/database click OK without entering any password. It now connects to the H2 DB.

    Run the query below to see your devices on the table:

     

    SELECT * FROM SNMPDEVICE

     

    Then create a delete query at your need:

     

    DELETE FROM SNMPDEVICE where <identifying_attribute> = '<value>'

     

    thanks,

    Marco



  • 3.  Re: How to delete profiles from snmpcollector

    Posted 08-23-2016 04:52 PM

    That works - Thanks!!



  • 4.  Re: How to delete profiles from snmpcollector

    Posted 03-10-2019 03:56 AM

    Hi Marco,

     

    When I use the above command, it is giving me message "database may be already in use: null. Possible solutions: close all other connection(s); use the server mode [90020-194] 90020/90020.

     

    Should I stop the snmpcollector probe and then use?

     

    Regards,

    Waseem Ahmed



  • 5.  Re: How to delete profiles from snmpcollector

    Posted 03-10-2019 09:25 PM

    Hi 

     

    Can try that .

    Also can check with callback "remove_smmp_device" to remove the profile



  • 6.  Re: How to delete profiles from snmpcollector

    Posted 08-23-2016 12:09 PM

    Hello,

    There is an existing idea with regards to this.

    CA UIM 8.2 /SNMP Collector 2.xx and greater - Allow selection of multiple profiles in SNMP Collector for Deletion or Force Re-discovery

    The only option is to do it manually that can be an arduous process.

    Thanks.

    Regards

    -Sayeed



  • 7.  Re: How to delete profiles from snmpcollector

    Posted 08-23-2016 04:52 PM

    I voted this up!