Looking for a way to export script execution logs. In our production account it seems logs are rolled over every day. I wasn't sure if there was a pre-built solution or not, or if I should roll my own.

You can see historical logs by going to customization > scripting > script execution logs

thanks, I hadn't noticed that option before. It's always been a pain to search through execution logs, I was wanting a good way to export them into another system so that I could search through them better

You can query them direclty via suiteql. If you don’t wan to write a script, you can use the tool I (SuiteQL Monaco Editor) or tim dietrich (SuiteQL Query Tool) wrote. Both are public bundles that have export capabilities to run suiteql queries. I don’t know how long logs stay queryable.

SELECT
  log.date,
  log.type,
  scriptDeployment.title as deployment_title,
  log.title as log_title,
  log.scripttype,
  log.detail,
  scriptDeployment.scriptid as deployment_id,
FROM
  ScriptNote as log
  INNER JOIN scriptDeployment ON log.scriptType = scriptDeployment.script
ORDER BY
  log.date DESC

Thanks, I'll check those out. Our logs are only available for about a day

then a scheduled script that exports a file to csv may be your best bet if you want to see more

thanks again, this really helped me get set in the right direction. I ended up selecting from ScriptNote, Script WHERE ScriptNote.scripttype = Script.id I have a lot of scripts with multiple script deployments and was getting the same ScriptNote internal id for each script deployment.

Awesome! Happy to help

another alternative is to push the logs out to a centralized logging API rather than an external system pulling them.

I'd thought about that too, either way is fine. I'm leaning towards an external system to pull so that I can pull via rest api and use a suiteql query to join & format

Aye, for the push approach I'd suspect a very similar SuiteQL query, just run with a script instead and pushing the results to an API. I guess the tradeoff is no external system needed but NS scripting isn't the most robust integration tool.

From the netsuite docs somewhere, wish I'd saved a link to it

Yes, I'd never seen the 'whole server purge' documented by NS but have suspected it for years.

Looks like those quotes were from Eric, quoting a help doc: https://stoic.software/effective-suitescript/14-all-logs/

Thanks @dbaghdanov - maybe I'll have to search NS help myself to confirm

Citation: NetSuite Help "Using the Script Execution Log Tab"

Important

The capacity for script execution logs on the Execution Log tab is shared by customers on the same database. For further protection against excessive logging, script execution logs are governed by a total storage limit on each instance of the NetSuite database. On each NetSuite server, if the database table that stores logs reaches this limit, all logs (across all customers on that server) are purged. This means that you may have logs up to 30 days if the volume is low, but you may have logs of less than a week if the log volume is extremely large. Use the Script Execution Log page for logs up to 30 days, regardless of volume. For more information about governance of script logs, see Governance on Script Logging