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…