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: 222 $Alert = Get-SCOMAlert -Name “Alert Name” $MonitorID = $Alert.MonitoringRuleId $MonitorName = Get-SCOMMonitor -id $MonitorID $managementpack = $MonitorName.GetManagementPack() $managementpackname = $managementpack.DisplayName $managementpackname
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: 190 I was working on a case where live migration was failing for a cluster due to unwanted disk was attached on the virtual machine VM1. Here is the troubleshooting which I did to fix the issue. Issue ======================================================= Live migration is […]
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 […]