jimwillsher 65 Posted March 4, 2015 Share Posted March 4, 2015 Hi is there a way to remove revoked certificates from the console? I've had trouble tonight with certificates so I now have a dozen revoked ones, and I could do with clearing them out to keep things tidy. I can guarantee that there are no agents deployed using these certificates. Happy to remove them via SQL Server if someone can tell me which tables and records. Latest ERA6 (Global). Many thanks Jim Link to comment Share on other sites More sharing options...
ESET Staff michalp 20 Posted March 5, 2015 ESET Staff Share Posted March 5, 2015 Right now it is not possible to hide or remove peer certificates from web console. Peer certificates are stored in 'tbl_certificates' table. There is column 'removed' which controls whether that row will be displayed in web console. Putting '1' instead of '0' will hide specific certificate record. Doing this change manually will skip internal mechanism in ERA server that records changes of every static object in database. For this specific case and your ERA release, it should be safe. But do it at your own risk. Link to comment Share on other sites More sharing options...
jimwillsher 65 Posted March 5, 2015 Author Share Posted March 5, 2015 Thanks michalp, I think I'll leave them there for a while - or hide them but then re-enable them before the next release in case it breaks something. Link to comment Share on other sites More sharing options...
dcarey 2 Posted March 5, 2015 Share Posted March 5, 2015 Good info as i also have botched certs I'd like to hide. -Dave Link to comment Share on other sites More sharing options...
verus 4 Posted March 11, 2015 Share Posted March 11, 2015 Do you have to revoke the certificates when using new ones or can you just leave them as they are (even if they have the same name but of course another serial) ? Link to comment Share on other sites More sharing options...
jimwillsher 65 Posted March 11, 2015 Author Share Posted March 11, 2015 You can probable leave them, but it would get very confusing when you have to pick one. I've hidden them via SQL to simplify things. Link to comment Share on other sites More sharing options...
ESET Staff michalp 20 Posted March 12, 2015 ESET Staff Share Posted March 12, 2015 You don't have to revoke them. Revocation is meant to be used when you want specific certificate to be not valid. Link to comment Share on other sites More sharing options...
jimwillsher 65 Posted March 12, 2015 Author Share Posted March 12, 2015 ok, but I would like to hide them somehow. Link to comment Share on other sites More sharing options...
ESET Moderators Peter Randziak 1,130 Posted March 19, 2015 ESET Moderators Share Posted March 19, 2015 Hello Jim, we plan to add such functionality in future releases. P.R. Link to comment Share on other sites More sharing options...
Planetshadow 0 Posted June 17, 2015 Share Posted June 17, 2015 Hi! I have several certs that I would like to hide as well... Could you give me the SQL Queries to accomplish this in the ESET Database? Link to comment Share on other sites More sharing options...
jimwillsher 65 Posted June 17, 2015 Author Share Posted June 17, 2015 There's a table called [tbl_certificates]. Just set the removed field to 1 for the ones you don't want to see. Do this at your own risk - though it seems to work perfectly well. Jim Link to comment Share on other sites More sharing options...
Recommended Posts