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,297 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,213   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 […]