Post Views: 304     VMware vSphere integration pack integration pack for VMware vSphere is an add-on for System Center – Orchestrator, it assists you in automating actions in VMware vSphere, enabling full management of your virtualized computing infrastructure.   After following the article https://docs.microsoft.com/en-us/system-center/orchestrator/vsphere-integration-pack?view=sc-orch-2019 to integrate the VMWare with […]

Post Views: 521     I have made the Orchestrator database maintenance activity automated. You can get the following Script in the below GitHub repository.   https://github.com/souravmahato7/Codes/blob/SCORCH/DatabaseMaitenanceScript.PS1   ################################################################## #Author: Sourav Mahato #Created Date:09/25/2019 #Purpose: Script for grooming the data for Orchestrator database # Please save the Script in the […]

Post Views: 257   For DBA Team: Before changing the SQL configuration, we need the following backups. 1.      Please make sure you have the password for all the accounts which are being used in Orchestrator 2.       Back up SQL Server service master key Sqlcmd -Q “BACKUP SERVICE MASTER KEY TO […]

Post Views: 743     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: 306         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, […]