Post Views: 6,121     For the Orphan instances to clean, please follow the below process.   Script is located here: https://github.com/souravmahato7/SQL/blob/SCORCH/SCORCH_Orphan_Data_Purge.sql   1. Take full backup of Orchestrator database.   – Need to stop the Runbook services on the Runbook servers.   2. Execute below SQL queries to check […]

Post Views: 3,226         I have written some useful SQL queries which will help to get data from Orchestrator database.   Query 1: The following query will help us to get the job details for a Runbook. Select RB.Name, RB.Path, RT.Id, RT.RunbookServerId, A.Computer , RT.Status, RT.Parameters, RT.LastModifiedTime, […]