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 design and build custom software for businesses running on NetSuite — from mobile apps and Web portals to Web APIs and integrations.
I’ve created several widely used open-source solutions for the NetSuite community, including the SuiteQL Query Tool and SuiteAPI, which help developers and businesses get more out of their systems.
I’m also the founder of SuiteStep, a NetSuite development studio focused on pushing the boundaries of what’s possible on the platform. Through SuiteStep, I deliver custom software and AI-driven solutions that make NetSuite more powerful, accessible, and future-ready.
Copyright © 2025 Tim Dietrich.