Post Views: 1,526     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: 2,443     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: 7,296 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: 2,702   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: 6,133     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 […]