System Data Management | Best practice to bulk update or delete data using in ServiceNow
I vividly remember couple of years ago on a rainy Friday. A desktop management team member ran to me and said "I have accidently added 2500+ assets in the cmdb_ci_computer table and I need you to delete those right now". I quickly wrote a Fix script, raised an emergency change and deleted those records from production and the whole process took 3+ hours to execute it and get approvals. I felt like 'I saved the day' for my organization and my colleague.
But the celebration was short-lived. The same guy approached to me panicked and whispered 'I gave you the wrong model ID, here is the correct one'. My heart skipped a beat and I was blurred for a moment. However, armed with determination and several cups of "Masala Chai" (monsoon essential!), I embarked on a data-restoration odyssey. I looked into the 'Deleted Items' to restore the original records and also the related records(that was real pain). It took me hours and hours to revert the change. Fortunately, we were in the emergency change window, that was one less task. Finally, I ran the same fix script with the correct model ID and called it a day.
But I guess this wasn't just a personal lesson, ServiceNow product team knew admins were facing these issues and we needed for a more robust and user-friendly solution. And so, the System Data Management module was introduced in Tokyo release, streamlining bulk actions and offering a safety net for accidental updates or deletions.
-----------------------------------------------------------------------------------------------------
00:00 - Introduction
02:30 - Update Records and Rollback
07:00 - Delete Records and Rollback
-----------------------------------------------------------------------------------------------------
Objects in JavaScript in ServiceNow
• Objects in JavaScript | ServiceNow
Real World Use Case #2 of Flow Designers
• Real World Use Case #2 of Flow Designers i...
Real World Use Case of Flow Designer #1
• Error Handling in ServiceNow: Real-World U...
Iterations in Flow Designer in ServiceNow
• Iterations in Flow Designer in ServiceNow
Sub Flow in Flow Designer
• SubFlows in Flow Designer in ServiceNow (w...
Flow variables in Flow Designer
• Flow Variables in Flow Designer in ServiceNow
Loops in Flow Designer
• Loops in Flow Designer in ServiceNow
Custom Actions in Flow Designer in ServiceNow
• How to create Custom Actions in Flow Desig...
Parallel Flow in Flow Designer
• Parallel Flow in Flow Designer in ServiceNow
Getting started with Flow Designer
• Getting started with Flow Designer in Serv...
Introduction to the Robotic Process Automation(RPA) in ServiceNow
• Introduction to Robotic Process Automation...
How to setup RPA in ServiceNow
• How to do initial setup of Robotic Process...
What are Business Rules in ServiceNow? (Complete Demo)
• What are Business Rules in ServiceNow? (Co...
g_user Object in ServiceNow
• g_user object in ServiceNow
How to request a new ServiceNow Personal Developer Instance(PDI)
• Back to Basics: Ep 1 - Request a new Servi...
How to upgrade your ServiceNow Personal Developer Instance(PDI)
• How to upgrade your ServiceNow PDI
Everything about Tags in ServiceNow
• Everything about Tags in ServiceNow
How to create Reports in ServiceNow
• How to create Reports in ServiceNow
How to create personal Dashboards
• How to create personal dashboards in Servi...
Schema Maps in ServiceNow
• What are Schema Maps and how can we downlo...
Data Policies in ServiceNow
• Data Policies in ServiceNow
What are Business Rules in ServiceNow
• What are Business Rules in ServiceNow? (Co...
Integration in ServiceNow
• Getting started with Integration in Servic...
-----------------------------------------------------------------------------------------------------
Playlists:
Client Scripts
• Client Scripts in ServiceNow
Flow Designer
• ServiceNow Flow Designer Tutorial
Robotic Process Automation (RPA) in ServiceNow Playlist
• Robotic Process Automation (RPA) in Servic...
Emails in ServiceNow Playlist
• Emails in ServiceNow
Integration Playlist
• Integration in ServiceNow
Reporting in ServiceNow
• Reporting in ServiceNow
ServiceNow Admin and Developer Training
• Learn ServiceNow
-----------------------------------------------------------------------------------------------------
Please subscribe to my channel.
/ harditsingh
LinkedIn
/ harditsingh88
Twitter
/ harditsingh88
Email
[email protected]
-----------------------------------------------------------------------------------------------------
#servicenow #servicenowvancouver #vancouver #servicenowutah #utah #servicenowtokyo #tokyo #servicenowsandiego #san #diego #sandiego #servicenowrome #rome #businessrules #servicenowquebec #quebec #automated #automation #javascript #clientscriptsbar