Post Views: 573     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: 271     Please find the Script in the below location:   https://github.com/souravmahato7/Codes/blob/Windows/System_Info.PS1   ################################################################## #Author: Sourav Mahato #Created Date:01/05/2015 #Purpose: Script to get the details of the System with a Single PowerShell Script###### ################################################################## $Cur = Get-Location if (Test-path “$cur\SystemInfo.xlsx”) { Remove-Item -Path “$cur\SystemInfo.xlsx” -Force } if […]

Post Views: 252     You can get the Script from the below link.   https://github.com/souravmahato7/Codes/blob/SCOM/Get_All_The_ServiceMonitor.PS1 ################################################################## #Author: Sourav Mahato #Created Date:08/26/2019 #Modified Date:12/22/2019 #Purpose: Script for get all the service Monitor in SCOM #How to run: You just need to run it from SCOM Management Server and create Temp […]

Post Views: 217     Action Plan:   Please upgrade the agent first by running the following command line.   msiexec /i MOMAgent.msi /qn /l*v “C:\New folder\amd64\AgentUpgrade.log” AcceptEndUserLicenseAgreement=1   https://docs.microsoft.com/en-us/system-center/scom/deploy-upgrade-agents?view=sc-om-2019   Now we need to add the management group and management server name by following any of the below process. […]

Post Views: 337     Windows server 2016 Operating System is not supported for SCOM 2012 SP1. So I would recommend to upgrade the OS to Windows server 2012 R2.   https://docs.microsoft.com/en-us/previous-versions/system-center/system-center-2012-R2/jj656654(v=sc.12)   Before proceeding with any of the below action plan, please make sure you have full backup (working) […]

Post Views: 781 Select mh.INSTALLTIME,mh.INSTALLEDBY,bm.displayname,av.isAvailable from dbo.MT_HealthService mhinner join BaseManagedEntity bm on mh.basemanagedentityid=bm.basemanagedentityidinner join dbo.Availability av on av.basemanagedentityid =mh.basemanagedentityidWHERE bm.DISPLAYNAME IN(‘ServerName’)   Query to Update for all Manually installed Agent:   UPDATE MT_HealthService SET IsManuallyInstalled=0 WHERE IsManuallyInstalled=1 Query to Update for specific Manually installed Agent:   UPDATE MT_HealthService SET IsManuallyInstalled=0 WHERE […]

Post Views: 290   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: 819     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 […]