How to delete profiles from snmpcollector

[Raymond Carter]

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

[Marco Ippati]

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

[Raymond Carter]

That works - Thanks!!

[Waseem Siddiqui]

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

[Franklin Ravi D'souza]

Hi 

 

Can try that .

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

[Sayeed Islam]

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

[Raymond Carter]

I voted this up!