Useful SCCM 2012 Queries

Below is a list of useful SCCM SQL queries for reporting or Collection creations. Unfortunately, I am unable to recall where I complied all these queries from. I cannot take credit for them, however if you know where they came from please feel free to reply below and I will be happy to update citing the […]

PowerShell Scipt: Restart OpsMgr 2012 Services

So I have been having a pesky time tracking out exactly why after normal OS patching and reboot SCOM 2012 email notifications get hung up. It doesn’t happen every time the server reboots and it doesn’t occur on service restarts either. Nothing in the event logs to show why they wouldn’t be working properly. Since […]

GUID Translate Script – PowerShell

Wrote a quick little PowerShell script to translate the GUID OpsMrg 2012 spits out and give you the display name. Note: This script is designed to be ran from the Operations Manger 2012 Shell / PowerShell Just a little time saver hope it helps. -Good Luck!

SQL Query – OperationManager Database Statistics

Thanks for taking my Poll! OperationManager Database Statistics A good friend of mine provided me with this SQL Query that will give you a bunch of Statistics about your Operations Manager Database. This is such great information I asked him if I could share it with the world and he said it was ok. Below […]

SCOM 2012 Disaster Recovery SQL Server Restore

Intro Recently I had the need to perform a test of my SCOM 2012 SQL Disaster Recovery Database Restore Process. This setup has to be an exact copy of previous SQL configuration that occurred before. The following steps are what I followed to get the SCOM back online successfully. Please note that this is for […]

Windows Server 2012 No Security Tab in SNMP

I recently started working on some Windows Server 2012 systems and came across some systems that had SNMP installed but the Security, Agent, and Traps tabs were missing. If you haven’t heard yet, Microsoft has deprecated SNMP in Server 2012. (http://technet.microsoft.com/en-us/library/hh831568.aspx) This does not mean its not available, just that you have to install it as […]

SCOM 2012 – Agent Stuck in Pending Managment

Recently in preparation for SCOM 2012 SP1 update I noticed that I several devices that were showing up under “GET-SCOMPendingManagement” but NOT showing up in the Pending Management section of the Console. I am not sure what may have caused this to occur but I suspect that this a carry over from my CU1 failure […]

Alert History Grooming bug in OpsManager 2012

Thanks to Natascia Heil over at http://systemcentertipps.wordpress.com/ for updating us on the fix for the Alert History Grooming bug that was repeated in System Center Operations Manager 2012. Below is my personal documentation on applying the change she listed. Open Microsoft SQL Server Management Studio. Expand Databases > OperationsManager > Programmability > Stored Procedures > […]

OpsMgr / SCOM 2012 MP Backup PowerShell Script

Recently I came across a post that someone in the Operations Manger Community had posted about the new SCOM 2012 PowerShell command that allows you to export all your Management Packs to XML files. http://om2012.wordpress.com/2011/12/07/om12-rc-how-to-backup-all-scom-mps/ Get-SCManagementPack | Export-SCManagementPack -path C:\MPDUMP This was great starting place for creating a PowerShell Script that could run a daily […]

OpsMgr 2012 & 2007 R2 – Detect Noisy Discovery

This is something that has been around for a while and I think a lot of OpsMgr Admins have had posts about this in the past, but I believe that is is always good to keep up good practices. This last week I have spent a great deal of time performance tuning my SCOM 2012 […]