Bulk delete of interfaces created on a particular date

sunvad

Hi,

Is there a way to bulk delete interfaces that were accidentally created on a particular date? I can identify these interfaces (mostly down/shutdown and that were not supposed to be added) via audit table, but I need help to delete them in bulk. We could have managed through the manage entities/nodes page but there hundreds of them. Please help.

SELECT AccountID, DisplayName, NetworkNode, ObservationTimestamp, TimeLoggedUtc FROM Orion.AuditingEvents
Where AccountID = 'admin' AND ObservationTimestamp LIKE '%Oct 12 2024%' AND DisplayName LIKE '%created interface%'
ORDER BY ObservationTimestamp DESC

stuartd

It's not my skillset but if you have a query that works then export that to a spreadsheet and then wrap a delete script in a powershell script to recursively go through the s/s using the API is generally the best approach.

You could of course, fire up DB Manager, set the query window to read/write and then execute your query. Once the results are back, and you are happy just select them all and delete. But play direct in the DB at your own peril, especially if you don't have a backup.