Bulk Delete Device from DB

Owned by Conor McCann
Last updated: Oct 19, 2018

When you want to delete devices in bulk

The following stored procedure will add the DeviceID 3, 4, 5, 6, 7, 8, 20, 35, 23 to queue to delete the device. (Deletedby is to mimic what the UI would do)

Example:
Exec [model].[sendDeviceToDeletionQueue] @deviceID = 3, @deletedBy = test
Exec [model].[sendDeviceToDeletionQueue] @deviceID = 4, @deletedBy = test
Exec [model].[sendDeviceToDeletionQueue] @deviceID = 5, @deletedBy = test
Exec [model].[sendDeviceToDeletionQueue] @deviceID = 6, @deletedBy = test
Exec [model].[sendDeviceToDeletionQueue] @deviceID = 7, @deletedBy = test
Exec [model].[sendDeviceToDeletionQueue] @deviceID = 8, @deletedBy = test
Exec [model].[sendDeviceToDeletionQueue] @deviceID = 20, @deletedBy = test
Exec [model].[sendDeviceToDeletionQueue] @deviceID = 35, @deletedBy = test
Exec [model].[sendDeviceToDeletionQueue] @deviceID = 23, @deletedBy = test

To check the status of the devices that are currently queued.

SQL Statement:

select * from Model.DeviceDeletionQueue


To view all the data that is deleted

select * from model.DeviceDeletionDiagnostics with (nolock)


The Delete can still be used in the UI as the same stored procedure runs when you confirm the deletion from the UI.


Delete Device from UI