Hey everyone, Does anyone know if there's a tool, ...
# suitescript
k
Hey everyone, Does anyone know if there's a tool, either within NetSuite itself or an external application, that can help visualize the timing of all map/reduce and scheduled scripts?
e
You mean when they are scheduled to run?
k
Yup, like a holistic view of all schedules and concurrency and priority
e
thankyou 1
k
I found this module to be helpful to understand the overall health of the system but found it a bit high level to determine new schedules
e
Yeah there isn't a good view of the schedules (Suitelet opportunity for enterprising developers). The last time I did a significant analysis, I manually made a spreadsheet containing all the script data. Hopefully someone else has a better solution
k
I am doing excel as well but its starting to get messy lol, might need to put it all together in a better data visualizer tool
Thank you for checking!
c
I was just looking into this. Start time is available in suitescript but not in a saved search so it looks like it'll have to be a scripted solution with a suitelet front end. You could put whatever filters you want at the top for deployment or type (whatever) and then sort by start time to get a decent idea.
r
If you do end up making one, share it with us
s
Where did you find start time? I looked around at this a bit the other day and basically couldn't find the 'schedule' subtab documented.
e
The best I can find is to approximate the planned start times by querying the
ScheduledScriptInstance
for the actual start times, but if that doesn't also include MR scripts, then that's not helpful either
I believe it does though, since one of the columns is
mapReduceStage
s
I would love to find how to access the schedule itself - start, end recurrence parameters, etc.
e
Yeah I'm not aware of a documented way to access it
k
From what I have seen so far, they are all accessible in SDF but not internally within suitescript
e
That's true. I suppose you could write a shell script or node module or whatever you like to crawl the XML, but that might not catch everything deployed in your account (SuiteApps, Bundles)
plusone 1
s
Aye, but that would be outside netsuite. I wish we had access to this info from inside, either as a standard (sub)record or at least via SuiteQL
plusone 1
Unless there's a way with scripting to access the SDF definitions for things?
e
I wish we had access to this info from inside
Same.
This search works fine to get potentially scheduled deployments, but all the relevant fields I try to read off the
Record
instance in the
map
are
undefined
, despite actually having values on the Deployment record.
s
Yes, strange that info hasn't been surfaced to suitescript even after all these years
e
They're documented as available, they just don't actually work facepalm
s
documented as available where? I didn't see anything in the records browser
e
Records Browser > Script Deployment
s
Interesting - even more so that
recurrenceminutes
is marked as a
select
field
c
It definitely isn't popping up on a record to get with suitescript I was looking at fields and not columns. However, it is available using xml=T on a deployment or you can do nlapiGetFieldValue('starttime') in the console and it is available. The solution is probably for the scripts you want to check, get the ID and get the XML from the xml=T URL and parse out the fields you want.
so dark arts
s
so sad
c
there's probably a feature request from 10 years ago you can upvote /s