01
About this report
One row per script deployment, with the script name and id, script type, API version, deployment id, the record it runs on, its status, whether it is deployed, its log level, the script owner and whether the script is inactive. Scripts installed by SuiteApp bundles are included.
Filter Log level to DEBUG to find deployments that fill the execution log in production, or Status to Testing to find deployments that run only for their owner.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Script | Script id | Script type | API version | Deployment id | Record type | Status | Deployed | Log level | Owner | Script inactive |
|---|---|---|---|---|---|---|---|---|---|---|
| Invoice email on approval | customscript_inv_email_ue | USEREVENT | 2.1 | customdeploy_inv_email_ue | INVOICE | RELEASED | Yes | ERROR | Tom Okafor | No |
| Nightly price sync | customscript_price_sync_mr | MAPREDUCE | 2.1 | customdeploy_price_sync_mr | SCHEDULED | Yes | AUDIT | Tom Okafor | No | |
| Order entry helper | customscript_so_entry_cs | CLIENT | 2.0 | customdeploy_so_entry_cs | SALESORDER | RELEASED | Yes | DEBUG | Priya Natarajan | No |
| Legacy label printer | customscript_label_sl | SCRIPTLET | 1.0 | customdeploy_label_sl | TESTING | No | DEBUG | Tom Okafor | Yes |
03
The SuiteQL
This is the query each report runs. Read it, copy it, or change it after import.
SELECT s.name AS script,
s.scriptid AS script_id,
s.scripttype AS script_type,
s.apiversion AS api_version,
d.scriptid AS deployment_id,
d.recordtype AS record_type,
d.status AS status,
d.isdeployed AS deployed,
d.loglevel AS log_level,
BUILTIN.DF(s.owner) AS owner,
s.isinactive AS script_inactive
FROM scriptdeployment d
JOIN script s ON s.id = d.script
ORDER BY script_type, script, deployment_id