Just playing around today and thought I’d make this little post on how to return discovered inventory in Command Shell.  This one in particular will return all disk sizes discovered, convert to GB and round to the nearest 1. get-MonitoringClass ...

Back in the MOM days the data was synchronized to the Data Warehouse by means of DTS jobs.  Data would be synchronized from the operational database to the Data Warehouse database on a schedule.  Using the scheduled DTS method of synchronizing...

I’ve seen plenty of questions come up in the forums and from customers regarding the Health Service Heartbeat Failure monitor, and its associated diagnostics and recoveries. I spent a little time digging further into these workflows and thought...

Every now an then someone will ping me and ask me why they are not seeing any new alerts.  My first question is, do you expect an alert for some reason?  Sometimes there may be an issue with SCOM.  But every now and then we find that SCOM...

/* Return Health Service instances hosting one or more instances contained in system.group */ USE OperationsManagerDW SELECT vManagedEntity.DisplayName AS Computer FROM  vManagedEntity INNER JOIN               ...

Thanks to Daniel Savage for helping with this one. /* Get all groups from Data Warehouse */ USE OperationsManagerDW SELECT DISTINCT DisplayName FROM  vManagedEntity WHERE (ManagedEntityTypeRowId IN                   ...

I had a question today about uninstalling an agent using the command line.  The options referenced here are great for installing, configuring and modifying an agent and all possible options.  Here are some additional notes that may come in handy...

UPDATE: Monitoring the operational database grooming procedure is now included in the SCOM management pack since version 6.1.7672.0. I will keep this post up as an example of how to create a monitor based on a script that queries a database. Okay,...

UPDATE: Monitoring the operational database grooming procedure is now included in the SCOM management pack since version 6.1.7672.0. I will keep this post up as an example of how to create a monitor based on a script that queries a database. Often...

This was initially published by Kevin , and Steve added row count.  I just changed the column names and posted it here for easy access to customers I work with.  Anytime I engage in a tuning effort or a case where there are database issues,...

A few months ago, after re-installing my workstation operating system and getting all my applications and tools loaded, I fire up Operations Manager Command Shell.  Since I use the tab expansion function frequently, I noticed immediately that for...

Every day I have a number of fleeting thoughts that I hope every Operations Manager administrator knows.  With all the emerging blogs about Operations Manager over the past year offering up a wealth of knowledge, sometimes I assume the majority of...

Return state of a group foreach($a in get-monitoringobjectgroup){if($a.DisplayName -eq " group name "){$a.HealthState}} Return contained instances of a group and state of each instance foreach ($group in get-monitoringobjectGroup) {if($group...

/*Number of alerts raised per day for last 28 days.*/ USE OperationsManagerDW SELECT CONVERT(VARCHAR(10), DBCreatedDateTime, 101) AS Date, COUNT(*) AS Alerts FROM  Alert.vAlert WHERE (DBCreatedDateTime BETWEEN DATEADD(day, -27, GETDATE()) AND GETDATE...

/*Number of events collected per day for last 28 days.*/ USE OperationsManagerDW SELECT CONVERT(VARCHAR(10), DateTime, 101) AS Date, COUNT(*) AS Events FROM  Event.vEvent WHERE (DateTime BETWEEN DATEADD(day, - 27, GETDATE()) AND GETDATE()) GROUP...

/*Number of state change events per day for last 28 days.*/ USE OperationsManagerDW SELECT CONVERT(VARCHAR(10), DateTime, 101) AS Date, COUNT(*) AS 'State Changes' FROM  State.vStateRaw WHERE (DateTime BETWEEN DATEADD(day, - 27, GETDATE()) AND GETDATE...

/*Number of unit monitor state changes per day for last 28 days.*/ USE OperationsManagerDW SELECT CONVERT(VARCHAR(10), DateTime, 101) AS Date, COUNT(*) AS 'State Changes' FROM  State.vStateRaw INNER JOIN               ...

/*Top 50 alert generating rules and monitors in last 7 days, sorted by alert + repeat count.*/ USE OperationsManagerDW SELECT TOP (50) Alerts.AlertName, SUM(1) AS 'Alert Instances', SUM(Alerts.RepeatCount + 1) AS 'Alert + Repeat Count',               ...

/*Top 50 alert generating rules and monitors in last 7 days, sorted by alert instances.*/ USE OperationsManagerDW SELECT TOP (50) Alerts.AlertName, SUM(1) AS 'Alert Instances', SUM(Alerts.RepeatCount + 1) AS 'Alert + Repeat Count',               ...

/*Top 50 event inserts in last 7 days.*/ USE OperationsManagerDW SELECT TOP (50) COUNT(*) AS Count, Event.vEvent.EventDisplayNumber AS 'EventId', vRule.RuleDefaultName AS 'Collection Rule',               ...

/*Top 50 Performance Sample Inserts for last 10 days by default.*/ USE OperationsManagerDW SELECT TOP (50) COUNT(*) AS Count, vPerformanceRule.ObjectName AS Object, vPerformanceRule.CounterName AS Counter,               ...

/*Top 50 state changing unit monitors in last 7 days.*/ USE OperationsManagerDW SELECT TOP (50) COUNT(*) AS Count, vMonitor.MonitorDefaultName, vManagementPack.ManagementPackDefaultName FROM  State.vStateRaw INNER JOIN               ...

These were initially published by Daniele Grandini and have been a great tool for finding noisy discoveries.  Only small modifications to time window has been made. /*Top discovery rules in the last 24 hours*/ USE OperationsManagerDW SELECT ManagedEntityTypeSystemName...

/*Operational groom settings*/ USE OperationsManager SELECT ObjectName, DaysToKeep AS Days FROM  PartitionAndGroomingSettings ORDER BY ObjectName Back to SQL queries main menu

/*Data Warehouse retention settings*/ USE OperationsManagerDW SELECT Dataset.DatasetDefaultName AS Dataset, StandardDatasetAggregation.MaxDataAgeDays AS Days,                CASE StandardDatasetAggregation...