Post Views: 471 Before any action to be taken, please make sure we have database full back up in place. First we will run the below query to identify how many data we have on each of the following tables. Select Count (*) From POLICYINSTANCES WITH (NOLOCK) […]
Post Views: 6,083 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: 1,740 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: 1,858 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,324 https://blogs.technet.microsoft.com/momteam/2009/09/25/some-sample-reports/#comments So I have modified the MP and tested it in my Lab and it worked fine. You can download the MP from the below link. https://github.com/souravmahato7/Management-Packs/blob/master/Sample.Report.Library.xml https://gallery.technet.microsoft.com/Custom-Report-for-Overall-526d8fc3 The report would be looks like below.
Post Views: 2,564 I have written some useful SQL queries which will help to get data from Orchestrator database. Query 1: The following query will help us to get the job details for a Runbook. Select RB.Name, RB.Path, RT.Id, RT.RunbookServerId, A.Computer , RT.Status, RT.Parameters, RT.LastModifiedTime, […]