Documentation / Script Runner / Common Workflows

Common Workflows

Repeatable Script Runner playbooks for multi-server work.

Fleet inventory (read-only)

  1. Create or select a Server Group that includes the instances you manage.
  2. Paste a read-only inventory script (versions, databases, last backup times, etc.).
  3. Set Include Databases if you only need user DBs (exclude system DBs via filter).
  4. Run Validate, then Execute in parallel if the script is lightweight.
  5. Export the result grid to Excel/CSV for the change ticket.

Controlled patch rollout

  1. Put the change script in a Script Folder (or paste it) with clear GO batches.
  2. Target a non-prod group first; use Stop-on-error if later steps depend on earlier ones.
  3. Review the Execution Log for failed batches; fix and re-run only failed targets if needed.
  4. Promote the same script to a prod group after sign-off — do not edit the script between environments if you can avoid it.

Pattern-matched script packs

  1. Name scripts so Pattern Match Routing can map files to the right server groups.
  2. Run the folder against the fleet; confirm each file hit the intended targets in the log.