Post Views: 183 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 Continue Reading

Post Views: 102     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 Continue Reading