NetSuite: Query for Deleted Records Using SuiteQL

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."