Post Views: 6,208 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: 905 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: 2,177 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: 5,193 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: 1,039 Issue: Found that after installing the UR5 patch for Runbook servers, Runbook service account is getting reverted back to its old account when we have already changed the account with a new one. Workaround: Firstly, we need to change the below registry key value for […]
Post Views: 2,636 TLS 1.2 is the secure way of communication suggested by Microsoft with best-in class encryption. SSL and early TLS are not considered strong cryptography and cannot be used as a security control. Microsoft has added official support for TLS1.2 security protocols in SCORCH 2012 R2 […]
Post Views: 1,981 I have seen many posts in common forum and it seems that many of you are having challenges when it comes to moving the SCOM database to a new SQL database instances. The process is bit complex, so it’s become a bit challenges to […]
Post Views: 1,006 Error while accessing the connector tab in SCOM We have recreated the connector in SCOM to forward the alert to ticketing system. But while accessing the connector tab, we are getting the below error. Application: Operations Manager Application Version: 7.2.12150.0 Severity: Error Message: […]
Post Views: 1,556 There was an alert on my SCOM Lab while I was configuring SMA monitoring in SCOM. Now checked the health explorer and found that the alert is raised for the below Monitor While looked at the alert configuration, it is […]
Post Views: 7,209 procedure to install the SCOM agent on Workgroup Server To install a SCOM agent on a workgroup server, we need to follow three steps Manual SCOM agent installation Certificate installation steps Bind the certificate with healthservice using Momcertimport.exe tool Manual SCOM […]