Published on July 27, 2021.
A NetSuite user on the NetSuite Professionals Slack Community recently asked if there was a way to determine who deleted a task record.
Using SuiteQL, you can query the DeletedRecord table to get that type of information. Here's a simple query that shows all records deleted during the current date.
SELECT TO_CHAR ( DeletedDate, 'DS TS' ) AS DeletedDate, Type AS RecordType, RecordID, BUILTIN.DF( DeletedBy ) AS DeletedBy, BUILTIN.DF( Context ) AS Context FROM DeletedRecord WHERE ( DeletedDate >= TO_DATE ( TO_CHAR ( SYSDATE, 'YYYY-MM-DD' ), 'YYYY-MM-DD' ) )
The result includes the date and time that the record was deleted, the record type and ID, the name of the employee that deleted the record, and the context that they were in when they deleted the record (for example, "UI").
Here's an example result, as it appears when the query is run in the SuiteQL Query Tool.
You can easily adjust the filter used on the DeletedDate to change the date range. For information on working with date and times in NetSuite, check out this blog post: https://timdietrich.me/blog/netsuite-suiteql-dates-times/
Also, this query is now available via the "Remote Library" function in the latest version of the SuiteQL Query Tool. To locate it, simply search for "deleted records."
Hello, I'm Tim Dietrich. I develop custom software for businesses that are running on NetSuite, including mobile apps, Web portals, Web APIs, and more.
I'm the developer of several popular NetSuite open source solutions, including the SuiteQL Query Tool, SuiteAPI, and more.
I founded SuiteStep, a NetSuite development studio, to provide custom software and AI solutions - and continue pushing the boundaries of what's possible on the NetSuite platform.
Copyright © 2025 Tim Dietrich.