QuickTricks: Get a count of alerts per day in OpsMgr 2007 R2 and 2012 or estimating ticket volume in Service Manager (#SCOM, #SCSM, #SYSCTR, #SQL)

As part of a dashboard project I was working on in OpsMgr 2007 R2 I created a series of SQL queries which can gather information from the OperationsManager database (not recommended) or from the OperationsManagerDW (recommended). These are available for download at: http://www.systemcentercentral.com/Downloads/DownloadsDetails/tabid/144/IndexID/86822/Default.aspx  Recently we had a request to identify an estimated number of tickets…

QuickTricks: Migrating subscriptions between Operations Manager environments (#SCOM, #PowerShell, #SYSCTR)

Recently during an OpsMgr 2007 R2 to OpsMgr 2012 engagement we needed to migrate all subscriptions, subscribers and channels  from the existing OpsMgr 2007 R2 production environment to the newly built OpsMgr 2012 QA and Production environments. The following is the process that we used which worked extremely well (though I’m not sure if it’s…

The Top-5 benefits of combining Operations Manager and SharePoint? [#SCOM, #SYSCTR, #SharePoint]

Environments which have SharePoint available gain several benefits from using SharePoint together with Operations Manager. The following is my Top-5 list of these benefits. Benefit #5: Using SharePoint as a process repository SharePoint document libraries provide an excellent way to store documents within document libraries which can easily be searched using the built-in SharePoint functionality.…

How do I integrate SQL databases into Service Manager 2012 as Configuration Items? [#SCSM, #SCOM, #SYSCTR, #SQL]

During a recent client engagement, there was a request to add databases to Service Manager as CI’s. This was in addition to previous requests to add both network devices and VMware servers from OpsMgr into Service Manager. As background the following two articles documented the first attempts I made at synchronizing information from OpsMgr 2012…