Capture Deleted record in update set

[Sndeveloper Adm]

Hi, 

I would like to delete ONLY one record in DEV Which needs to be captured in update set. And eventually this record should be removed from QA and PROD as well. 

As deleted records are not captured in update sets, what is the best way to do this ?

TIA  

[Arun_S1]

I dont see a point to write a script to delete one record. May I ask why you are worried to delete a single record directly and spending so much effort to get that deleted using an update set/script?

Please mark the appropriate response as correct answer and helpful, This may help other community users to follow correct solution.

[Sndeveloper Adm]

@Arun_S1 

Hi Arun,

Yes , I agree with you . Even i did the same.  but I am curious to know the solution 

[Amit Gujarathi]

HI @Sndeveloper Adm ,
I trust you are doing fine.

1. Navigate to the respective table where the record is located. For example, if the record is in the "Asset" table, go to the "Asset" module.
2. Use the ServiceNow query functionality to locate the record you want to delete. Construct a query based on the unique identifiers or specific criteria of the record.
3. Once you have identified the record, select it from the list of results.
4. Before deleting the record, create an update set to capture this change. This will allow you to transport the deletion to other environments (QA and PROD). To create an update set: a. Go to the "System Update Sets" module. b. Click on the "New" button to create a new update set. c. Provide a name and a short description for the update set. d. Set the state of the update set to "In Progress" or "Open."
5. With the update set created, go back to the record you want to delete.
6. In the record view, click on the "Delete" button or the appropriate option to delete the record.
7. Confirm the deletion when prompted.
8. After deleting the record, go back to the "System Update Sets" module.
9. Open the update set you created in step 5.
10. In the update set, you should see the deletion operation captured as a record in the "Update Set" table.
11. Export the update set to an XML file by clicking on the "Export to XML" button.
12. Import the update set XML file into the QA and PROD environments to apply the deletion to those instances as well. To import the update set: a. Navigate to the "System Update Sets" module in QA or PROD. b. Click on the "Import Update Set from XML" button. c. Select the XML file you exported in step 12. d. Follow the prompts to complete the import process.
13. Once the update set is imported successfully in QA and PROD, the record deletion will be applied in those environments too.

[Sndeveloper Adm]

Hi Amit , 

Thank you so much for your effort for replying here. I really appreciate it.

Step 10 : Deleted records doesnot capture in update sets. so I want to know how to handle this .

[Sndeveloper Adm]

@ Ankur Bawiskar 

Hope you are doing good. I would like to seek your expertise help here, Could you please suggest how to capture deleted record in update set. is there a way ? 

TIA.