Welcome to "how to do crazy stuff for Operations Manager using SQL, XML and PowerShell" (that was the original name for this blog post before I decided to make this into a series of blog posts which will focus on doing off the wall crazy stuff to meet business requirements in Operations Manager). Please realize…
Microsoft today launched a new website covering the roadmap for Office 365, http://office.microsoft.com/en-us/products/office-365-roadmap-FX104343353.aspx. This is great, now you can see what new features and functionality has been launched, is rolling out and in development. One of the cool new features that is in the Rolling Out section is the ability to opt in to being…
I was recently faced with an interesting requirement to provide monitoring for a series of SQL 2005 servers which had several hundred databases on them. The official support limits for this management pack is at 50 databases (Per the management pack guide: "We recommend that you monitor no more than 50 databases and 150 database…
In multi-homed migrations for Operations Manager one of the last steps is to remove the Operations Manager 2007 monitoring from the system. The migration process is discussed here but that does not provide details on how to actually perform the agent removal. Our initial tests did not work to perform an uninstallation of the agent…
If you’ve been having a hard time finding the Hyperlinks report in SharePoint Designer 2013, you’re not alone. Up until now, I thought it was removed from the product! Thanks to Heather Masters for pointing this out. The steps below will get you to the report. With a SharePoint site open, find and edit a…
I maintain a rollup table of project metrics, which get updated on a frequent basis. This table contains a lot of calculations and data from multiple sources, which first populates a TABLE variable. Once all of the calculations and aggregate data sources have been completed, I want to update my project metrics table with the…
I had a colleague of mine recently ask me a question that we have gotten for years now in Operations Manager. Specifically: "What’s the best way to get all the rules and monitors out of an MP so someone can view what’s being monitored by Operations Manager?" There are two approaches that I can recommend…
Did you know that you can use a SQL Query to join together a SQL Table with a Table-valued Function into a single result set? Here’s how: I have created a Function that contains several calculations and returns some standard Project Metrics: CREATE FUNCTION [dbo].[fnGetProjectMetrics] ( @ProjectId int ) RETURNS @results table ( [ActivityStartDate] datetime , [ActivityEndDate] datetime ,…
Recently I had the pleasure of being invited on "Getting Down to Business" with David Weatherford (http://gdtb.biz/). This is a radio program based out of Anchorage, Alaska, but syndicated in Seattle and Spokane, Washington, and focuses on today’s news and current events for business owners in the Pacific North West area. David invited me on…
In most environments where an offline Root CA is used, it must come back online once every 7 months to provide the Subordinate CA’s with an update CRL list. If this does not happen, the Subordinate CA will stop issuing certificates. The actual CA service on the Subordinate will no longer startup and the…
Catapult uses cookies to enhance your experience, to display customized content in accordance with your browser settings, and to help us better understand how you use our website. By continuing to browse or closing this banner, you indicate your agreement. To learn more about the cookies we use and to set your own preferences, see our Privacy and Cookie Policy.