SCOM 2012 R2 APM and Visual Studio TFS 2013 Integration

If you are interested to see how Application Performance Monitoring (APM) and the TFS integration looks in SCOM 2012 R2, then check this short video out. In the video, I demo how three .Net applications are monitored using APM and how alerts from each of them are synchronized to TFS as work items, either to the default project or specific projects and areas. One of the applications that I use for this demo is our Coretech Dashboard for SCOM 2012 and up. Screenshots from the video: APM alerts in SCOM....   …and a work item record in TFS with the [...]

By |2014-06-06T11:30:08+01:00June 6th, 2014|Operations Manager (SCOM)|Comments Off on SCOM 2012 R2 APM and Visual Studio TFS 2013 Integration

Execute permission error in SCOM when running Localsystem

I have seen this error a couple of times at different customers. Please always remember to implement a Service Account for both your Data and Config Services. If you are having more than one Management Server and are still running Localsystem, your Report service could give you errors whenever you try to choose a Group in the drop-down field. Another symptom are if you choose a Server and click a report it will not bring the computer fqdn to the report.   From SCOM 2012 SP1/R2 your could change the Service Account pretty easy, – Remember to add the user [...]

By |2014-05-19T21:03:19+01:00May 19th, 2014|Operations Manager (SCOM)|Comments Off on Execute permission error in SCOM when running Localsystem

SCOM 2012 R2 and SQL Server 2014

**** This is not supported by Microsoft and should only be done in a Test Environment **** *** Not even in the staging environment – Please *** Some customers have asked me about the gain for using SQL 2014 in the SCOM environment – And I did some fast tests – In my test envronment (7 servers, NLB, 2 MS, 2 Web/Report) which shows that out-of-the-box it will actually be faster just to upgrade to SQL 2014. And both an Upgrade and New Install does work with SCOM 2012 R2. Configuration: Virtual Machine: 4 gb memory VHD on SSD drive [...]

By |2014-05-15T15:54:26+01:00May 15th, 2014|Operations Manager (SCOM), SQL|2 Comments

Where is the alert history?

This error has been there before in OpsMgr 2007 and also resolved, however it has been re-introduced in SCOM 2012 and is still an issue in SCOM R2 UR2. If you have active alerts without any alert history or only a recent entry, then it is due to this bug. Until a fix comes out the workaround is to update the store procedure that takes care of alert grooming. I recommend you raise a support case with Microsoft to get the workaround from Microsoft. But the workaround will be this one. Important – test this in your SCOM test environment [...]

By |2014-05-08T15:35:16+01:00May 8th, 2014|Operations Manager (SCOM)|Comments Off on Where is the alert history?

Presenting your IT Services to the right Audience

I am doing a 3 hours session in Stockholm about Presenting/Visualizing IT Services to the organization or your Customers. Sign up and participate – @Labcenter will give a beer while I give you enough knowledge to make great dashboards… We will touch stuff like: Widgets, Powershell, the SDK, Reports, Visio, SLA, SLO. Sign up: See you

By |2014-04-30T10:57:23+01:00April 30th, 2014|Operations Manager (SCOM)|Comments Off on Presenting your IT Services to the right Audience

Check if a resolution state is in use before deleting it

  1. Go to Administration –> Settings and Alerts 2. Check the ID of the Resolution State you wish to delete   Notifications   1. Export Notifications Internal Library 2. Open the exported XML in Notepad 3. Search for <Value>ResolutionStateNumber</Value>, for instance: <Value>30</Value> 4. Copy the GUID, without the “ “     5. Open Operations Manager Shell and execute the following query: Get-SCOMNotificationSubscription –Name TheGuidFromXML     You then get which subscription uses the Resolution State Views 1. Open SQL Management Studio and connect to your SCOM instance 2. Execute the following query, with your Resolution State number:   [...]

By |2014-04-28T14:36:22+01:00April 28th, 2014|Operations Manager (SCOM)|Comments Off on Check if a resolution state is in use before deleting it

Find OpenSSL files with SCOM (Heartbleed)

OpenSSL for Windows are two DLL files which could be installed on some of your windows servers. The two files are: libssl32.dll or libssl64.dll and I am not saying these should be removed – but perhaps updated.   Powershell Script You could find the two files either by a powershell script like this one: – Start the script like : FindFile.ps1 libssl32.dll, libssl64.dkk and it will create an event for every finle found. 1: Param([String[]] $FileName) 2:   3: $api = new-object -comObject 'MOM.ScriptAPI' 4:   5: $Drives = Get-psdrive -psprovider "FileSystem" | select name 6: ForEach ($File in $FileName) [...]

OLE DB Data Source Monitor error: ORA-00900 invalid SQL statement

  There are no free management packs for monitoring Oracle databases in SCOM 2012. However, a free solution is to use the OLE DB Data Source monitor and install Oracle client on the watcher node. There are several blogs about how to set this up, so I’m not going to write about that.   What I am going to write about is the “ORA-00900 invalid SQL statement” error one might receive from these monitors. Some weeks ago I was at a costumer who wanted to monitor some Oracle databases and I configured the monitor without a query, which worked fine. [...]

By |2014-02-10T16:08:23+01:00February 10th, 2014|Operations Manager (SCOM)|1 Comment

Upgrading to SCOM 2012 R2

Over the past months I have collected a number of “pitfalls” when upgrading to R2 – please be sure to have a backup before you start and check the following before you begin upgrading to SCOM 2012 R2 Installation Account must be a member of the local administrators group on: a. SQL Server (both in cluster or always-on) b. Management Servers c. Reporting Servers Install Account must be a member of the Sysadmin role on the SQL Server On the SQL Server the Modal Database must not be more than 100 MB The Operationsmanager database must have 50% free space [...]

By |2014-01-28T03:56:01+01:00January 28th, 2014|Operations Manager (SCOM)|1 Comment

Nordic Infrastructure Conference 2014

Conference done = everybody’s happy about hopefully new and good knowledge – I did two sessions – One called Be a Hero another one called Create a ScomBot in Azure – Unfortunately they didnt record them – But I have attached both Slideshows to this blog. Agenda for Be a Hero: Introduction to Services Ready Steady – GO! Present SLO and SLA in a Dashboard Bottlenecks – SCOM Performance Whats New in R2 Use cases Agenda for Crete a SCOMBot for Windows Azure Automating everything Internal SCOM Monitoring Real world sample Using and Monitoring Azure Global Service Monitoring Visual Studio [...]

By |2014-01-18T14:35:39+01:00January 18th, 2014|Operations Manager (SCOM)|1 Comment

Visual Studio Web Test – without Visual Studio Ultimate

Using the Web Application Transaction Monitor is absolutely one of my favorites in SCOM. Adding GSM to this is nothing but brilliant. I know a lot of companies that wants to monitor their websites from outside the organization, and GSM does the job. But… It is not possible to create a Web App. Transaction monitor with GSM out of the box in SCOM. To do this one needs Visual Studio Ultimate. This is not one of the cheap ones. As a workaround one can you Fiddler2 and Notepad, which does the job. When using Fiddler2 you get a big load [...]

By |2014-01-13T11:34:30+01:00January 13th, 2014|Operations Manager (SCOM)|2 Comments

Visualization – Put SLA on a Group

A group in SCOM contains anything: Servers, websites, databases and/or network devices. Normally you are using the group to do views, overrides, disables or as base for notification. But a nice feature is to visualize this Group objects in a way where you are able to do a Rollup of all the objects in the group to present it in the new Coretech Dashboard or give it an SLA. To present the group follow this step-by-step blog.   Logon to the SCOM Server and start the SCOM Console Click Authoring Right click Groups and create a new group called “Grp.All [...]

By |2013-12-30T09:55:04+01:00December 30th, 2013|Operations Manager (SCOM)|Comments Off on Visualization – Put SLA on a Group

FAQ for Coretech SCOM Dashboard

Installation Q: Which rights does the account running the Application Pool need? A: The account running the Application Pool must be member of the "Operations Manager Read-only Operators" group in SCOM. Furthermore, the account needs write permission to the CTOMDashboard folder   Q: What are the prerequisites? A: The SCOM Operations Console and Internet Information Services must be installed on the server   Q: When i install, i receive "1001 . Object reference not set to an instance of an object" A: You might receive this when using another website than the Default Web Site when installing. Please use the Default Web Site until [...]

By |2013-12-17T10:24:01+01:00December 17th, 2013|Operations Manager (SCOM)|1 Comment

See overrides for a period

Ever wondered the best way to see which overrides created in your Management Group the last 7 days? This solution is pretty easy: 1. Click My Workspace 2. RightClick and click New.Overrides Summary View 3. Add conditions and give it a name 4. Here you go – Overrides for the last week:   Have a great december and remember to download our new Dashboard… Kåre

By |2013-12-11T13:36:10+01:00December 11th, 2013|Operations Manager (SCOM)|2 Comments

SCOM 2012 Web Console prompts for credentials – new

  When accessing the web console from the server hosting the web site there is no problem, but when accessing it from another server, you get the following message:     This issue is pretty common and I have already blogged about it here: As written in the blog post, this is due to Kerberos double hop. But what to do when that solution doesn’t do the trick?   I made sure that everything was as supposed:   Only Windows Authentication was enabled:   In Providers, NTLM had been moved up, which normally is the fix:   I then [...]

By |2013-11-27T11:17:36+01:00November 27th, 2013|Operations Manager (SCOM)|15 Comments

Upgrade to SCOM 2012 R2: Unable to proceed

  The upgrade time has truly come!   During an upgrade at a costumer site I got the following error when trying to upgrade the secondary management server:   Unable to Proceed Setup could not detect the current Data Warehouse Scenario. Please ensure that the SQL Server service for the Data Warehouse is running, and the current user has permission to access the Data Warehouse.     I checked the services and I had already upgraded the RMS emulator server so i was sure it wasn’t a permission issue.   Time to dig a little deeper…   I start by [...]

By |2013-11-07T11:05:07+01:00November 7th, 2013|Operations Manager (SCOM)|5 Comments

SCO/SCOM 2012: Get Alerts / Monitor Alerts – How to Filter on empty/null property

When using orchestrator, a lot of activities contain a filter Get Alert / Monitor Alert is some of them. The following workaround is tested for the above 2 activities, but i think it does apply to other filter activities too. (have not had the time to test yet, comments are welcomed!).   I ran into an unexpected behavior today: I was using a filter saying “TicketId Does not equal No Automatic Escalation”, and i was expecting to get alle alerts that did not have this text in the field. but I did not get all of them!. I only got [...]

By |2013-10-29T14:35:07+01:00October 29th, 2013|Automation, Operations Manager (SCOM)|1 Comment

Autogrowth Setting in SCOM 2012 R2 are pretty static

After running System Center Operations Manager 2012 R2 for a week, I began getting these errors: Ops DB Free Space Low – And amazingly the default setting on the Operations Manager database are Autogrowth = None, which will work in a production environment for about 17 minuttes. So remember to change this when you do the installation or afterwards – by changing the InitialSize (MB) to appr 50 GB (The largest OperationsManager database I’ve ever seen at a customer where 180GB)       Change it according to your database size calculations or at least!!   Have a great day [...]

By |2013-10-25T10:11:43+01:00October 25th, 2013|Operations Manager (SCOM)|2 Comments

How to edit default Resolution States

  Resolution States is an area in SCOM that is highly underestimated in my eyes. These can really be used to a lot – scoping, viewing, alerting, subscriptions etc. I do see a lot using it, and those who do have seen the light in this magnificent “tool”.   However, with SCOM 2012 Microsoft has added some default Resolution States:     The Acknowledged state is fairly useful, but the rest… I don’t really know. But these are all predefined, so we can’t delete them. But we can actually!   To edit these it requires manually changes to the database, [...]

By |2013-09-17T16:32:34+01:00September 17th, 2013|Operations Manager (SCOM)|Comments Off on How to edit default Resolution States

Exchange 2010 MP – be aware of events!

  I admit it, the Exchange 2010 has been fairly improved comparing to its younger sibling, the Exchange 2003 mp. We still have a load of Rules and Monitors, it’s still noisy and we still have to run all the Test-Something.ps1 scripts. There i one thing that one should be aware of though. The mp generates a LOT of events. I was at a costumer site last week configuring the mp, and i got this: 45202 events! In 10 days! The events are pretty usefull when testing the Test-Something scripts, as they run with 5 min. interval, you will get [...]

By |2013-09-16T13:41:09+01:00September 16th, 2013|Operations Manager (SCOM)|Comments Off on Exchange 2010 MP – be aware of events!

Which management pack contains my group or Distributed Application?

  Which management pack contains my group or Distributed Application? A couple of days ago I got a question, which I thought could be the 1$ question on Who Wants To Be A Millionaire, but I was actually a bit wrong.   While you can always see directly in the UI in which management pack rules, monitors, overrides have been saved, it is not exactly the same with Groups and Distributed Applications.   Neither in the Groups view nor in the properties of the group can you see anything about the management pack in which it has been saved. Same [...]

By |2013-07-23T11:35:05+01:00July 23rd, 2013|Operations Manager (SCOM)|1 Comment

SNMP trap/probe – with or without the dot in the OID?

  I was setting up some UPS monitoring at a costumer, and i got into a “discusison” with a collegaue about the first dot in a OID. We were discussing whether or not you need the dot before the first number when creating monitors/rules in SCOM 2012. We went ahead and created two simple monitors – one with the dot and one without: UPS Battery Temperature: .   UPS Battery Temperature – WITHOUT DOT:   I faked a temperature alert and i got:   I got two alerts! So actually, apparently it doesn’t make a living difference if you [...]

By |2013-07-22T14:52:09+01:00July 22nd, 2013|Operations Manager (SCOM)|2 Comments

SCOM 2012 Linux discovery: Unexpected DiscoveryResult.ErrorData type. Please file bug report. ErrorData:

  Today at a costumer site I was installing some Linux agents, when I got a pretty weird and non-saying error:   Unexpected DiscoveryResult.ErrorData type. Please file bug report. ErrorData: Microsoft.SystemCenter.CrossPlatform.ClientLibrary.MPAbstractions.InvalidWSManTaskResponseException Failed to parse output from WSMan discovery. Output from task was: <DataItem type=”Microsoft.SystemCenter.WSManagement.WSManData” time=”2013-02-26T15:35:00.1849706+02:00″ sourceHealthServiceId=”16F56055-5671-604C-AF9D-088444BA4B6E”><WsManData><ErrorCode>0x800703fa</ErrorCode><ErrorMessage>Illegal operation attempted on a registry key that has been marked for deletion. </ErrorMessage></WsManData></DataItem>. at System.Activities.WorkflowApplication.Invoke(Activity activity, IDictionary`2 inputs, WorkflowInstanceExtensionManager extensions, TimeSpan timeout) at System.Activities.WorkflowInvoker.Invoke(Activity workflow, IDictionary`2 inputs, TimeSpan timeout, WorkflowInstanceExtensionManager extensions) at Microsoft.SystemCenter.CrossPlatform.ClientActions.DefaultDiscovery.InvokeWorkflow(IManagedObject managementActionPoint, DiscoveryTargetEndpoint criteria, IInstallableAgents installableAgents)     This really didn’t give me any clues about the issue. Started Googling the issue, [...]

By |2013-06-20T11:06:46+01:00June 20th, 2013|Operations Manager (SCOM)|Comments Off on SCOM 2012 Linux discovery: Unexpected DiscoveryResult.ErrorData type. Please file bug report. ErrorData: