Post Views: 2,175   Many of you asks if we can get a SQL query where you will just run a SQL query to pull the CPU and Memory data in a single query.   I have made a SQL Script which is available here:   https://github.com/souravmahato7/SQL/blob/SCOM/SCOM_CPU_Memory_Data.sql   This query […]

Post Views: 2,264     Solution 1:   You can run the PowerShell Script which is located here: https://github.com/souravmahato7/Codes/blob/SCOM/GroupInfo.PS1   ##################################################################<#Purpose: This script will help you to identify in how many groups the server is part of #># You need to copy this GroupInfo.PS1 file to a location on your […]

Post Views: 2,240     We need to use the following Switch which will recover the management servers.   Setup.exe /silent /AcceptEndUserLicenseAgreement /recover /EnableErrorReporting:Never /SendCEIPReports:0 /UseMicrosoftUpdate:0 /InstallPath:”D:\Program Files\System Center 2016\Operations Manager” /DatabaseName:OperationsManager /SqlServerInstance:<server\instance> /DWDatabaseName:OperationsManagerDW /DWSqlServerInstance:<server\instance> /DASAccountUser:<domain\username> /DASAccountPassword:<password> /DatareaderUser:<domain\username> /DatareaderPassword:<password> /DataWriterUser:<domain\username> /DataWriterPassword:<password> /ActionAccountUser:<domain\username> /ActionAccountPassword:<password> /ManagementGroupName:MGName​