cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

Is there a quick way to delete multiple Sonar discovery jobs

Jump to solution

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?

sw_sonar.jpg

Labels (1)
0 Kudos
1 Solution
Level 13

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]

View solution in original post

3 Replies
Level 13

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]

View solution in original post

Awesome, thanks

On Nov 6, 2015 9:34 AM, "janene16" <

0 Kudos

No problem, jtanquary‌ glad to have helped.

Can you mark this question as resolved for so other users who have the same question can find this thread.

Thanks!

0 Kudos