Is there a quick way to delete multiple Sonar discovery jobs

jtanquary

I have about a 100 old jobs I need to remove from the network sonar discovery page, if I have to remove them manually that's ok however Id prefer an automated way. Does any one have any suggestions, is there an SQL Table that I can delete them from?

janene16

There is a way but on the SQL Server. From your Orion database, check the list of tables and find the [dbo].[DiscoveryProfiles].

You should see the list of Discovery you see on your web.

Deleting all of them can be done by running this query:

DELETE FROM [dbo].[DiscoveryProfiles]