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…

News and Updates for Office 365

It has been a pretty busy time for Office 365, and I am not even talking about the Customer Preview of the next major update of the service which includes the 2013 products. Wanted to take a few minutes to highlight a few of the new and improved features for the current version of Office…