...
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)
| Code Block | ||
|---|---|---|
| ||
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 |
...
| Code Block | ||
|---|---|---|
| ||
select * from Model.DeviceDeletionQueue |
To view all the data that is deleted
select * from model.DeviceDeletionDiagnostics with (nolock)
| Note |
|---|
The Delete can still be used in the UI as the same stored procedure runs when you confirm the deletion from the UI. |
...