This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Does anyone know a way to pull a history of saved searches run by a particular user?  I know I can go into each search one by one in the UI and look at execution log, but we have thousands of searches so this is not practical.

I don't think there's a way, though if you find one, I'd be interested. I don't think anything related to the Execution Log is stored anywhere.

I think even something like Strongpoint doesn't have this level of tracking.

<@U4TPAFXEC> You can query the usrsavedsearchexec table. Something like this:
```SELECT TOP 10
	TO_CHAR ( usrsavedsearchexec.dateexecuted, 'DS TS' ) AS DateTime,
	BUILTIN.DF( usrsavedsearchexec.internalid ) AS Search,
	Entity.altname AS User,
	Role.Name AS Role
FROM 
	usrsavedsearchexec 
	INNER JOIN Entity ON
		( Entity.ID = usrsavedsearchexec.executedentityid )
	INNER JOIN Role ON
		( Role.ID = usrsavedsearchexec.executedroleid )
ORDER BY 
	usrsavedsearchexec.dateexecuted DESC```

Oh nice <@U856E2SEA>. Is that table exposed via SuiteQL or is that through <http://netsuite2.com|netsuite2.com> via SA Connect? That table isn't in <http://netsuite.com|netsuite.com>. I'm guessing it's available in SuiteQL?

wow.  <@U856E2SEA> how do you figure this stuff out when it’s not documented?

this is not the right table for my needs, I don’t think.  It only has 25 results _in total_  (i.e. `SELECT * FROM usrsavedsearchexec` returns 25 results only) though we run hundreds of searches daily and have been operating for 15 years on NetSuite.

and some of the search internal ids have very odd values, e.g. `-5050347871433095`

the ids are deceiving, look at it from the ui <https://system.na0.netsuite.com/app/common/report/dataset.nl?recordType=usrsavedsearch>