Hello, everyone! I am currently analyzing scripts in NetSuite. In NetSuite > Customization > Scripting > Scheduled (Map/Reduce) Script Status, I can see both the script and deployment IDs. However, when I query SuiteQL, I am unable to find these in the scheduledscriptinstance table. The taskid appears as something like

MAPREDUCETASK_026XXXXXX_XXXX

. I am wondering if it is possible to use this value to locate the relevant information, or if there is another method I should use. Could you please advise on how to retrieve this information?

Use N/search instead

Thanks battk. As you said, ‘search query’ is also an alternative. LLMs and Celigo AI also recommended search query. But I want to find out how the data is stored and processed internally.

thats not going to be a useful line of thinking. NetSuite does not want to expose that information. You get things like the searches and queries, which are ways they expose their data to you. They probably are similar to their actual database tables, but there is no guarantee there

I understand your opinion. However, most of the information is already stored in the

scheduledscriptinstance

, except for the script or script_deployment key. The only issues are with the internalid and taskid, and I initially thought I just couldn’t find the data that was already saved. I’ll investigate further, and if I still can’t find it, I’ll consider using the search module. Thank you.