OWL IT

Welcome to OWL IT a company run by Oskar Landman working as a freelance consultant on Management and Automation located in Rotterdam the Netherlands.

On this site you will find my contributions I have delivered throughout the years and recent blogs on my main focus Management and Automation.(Azure Automation, Microsoft Operations Management Suite, Service Management, Automation and System Center)

Cheers,

Oskar Landman

Geplaatst in Uncategorized | Een reactie plaatsen

SCSM (notification) workflows not working, workflow doesn’t run although criteria are met. (when using “does not contain” empty fields will NOT be evaluated!)

Today I ran into an issue with sending out notifications.

The issue was “some” notifications where not received for review activities.

The some is the one which always triggers me, like the workflow randomly doesn’t run….nope unless you specifically tell it to randomly not run! Winking smile

The end user may explain it to be randomly because he or she has no knowledge what lies beneath but there is no random failure! Smile

 

Time for trouble shooting

Service Requests

When investigating the issue I looked at Service Requests affected and corresponding review activities, nothing special there. All Service requests where form the SSP by request offering.

So no user intervention which makes trouble shooting easier since we can expect same behavior again an again.

Workflow status

Always a good idea to see if there are issues like missing email on user accounts or other problems.

 

image

No errors, the workflow is working and email addresses and template can be generated when sending out the notifications.

There was definitely activity and no workflow instances needed attention, so the workflow simply wasn’t triggered!

Next step Workflow configuration

Workflow Configuration

Time to look at the workflow Configuration, there where 3 workflows 2 specific for a certain review activity and 1 general workflow for all other activities.

Which should function like a catch ‘m all except…

Let’s open up the configuration of the catch ‘m all:

image

Check Enabled –> OK and “When an object is updated”.

Next tab the Criteria:

 

image image
   

which translates:

Any review activity which goes to the status in progress AND

where approval condition is NOT Automatic AND

Description DOES NOT CONTAIN new user request.

 

so only when a review activity is automatic and description contains new user request should NOT trigger this workflow.

I checked the review activity (of the not send out notification)

image

It was set to percentage and didn’t contain new user request in the description.

When looking at the criteria again this review activity should trigger the workflow, correct?

Issue

After testing with several review activities I finally found the issue:

The description field is empty!

When you use DOES NOT CONTAIN apparently SCSM will only check this criteria when there is something in the field description! And then it will match DOES NOT CONTAIN

When the description field is empty it simply skips or fails this check which doesn’t trigger the workflow.

I would expect  DOES NOT CONTAIN = true when there is nothing, but apparently SCSM thinks otherwise.

 

Solution

When using DOES NOT CONTAIN make sure there is something to evaluate otherwise it won’t work.

I used a little extra information in the description like:

 

image

 

Cheers,

Oskar Landman

Geplaatst in Uncategorized | 2 Reacties

Installing System Center 2016 eval with SQL 2016 running in Windows server 2016 eval

First of all I installed a brand new windows server 2016 and promoted it to a DC.

My second server will be a Database server, I always install a separate SQL server dedicated for System Center.

Since I don’t have tons of memory this will give me the best performance results , granting the Database server with enough memory.

SQL 2016 installation.

Just run the setup as you are used to do and install the correct database components for SCOM.

A nice added feature during installation is you can now configure your temp db’s during setup ! Smile

 

image

For reference on tempdb configuration – https://technet.microsoft.com/en-us/library/ms175527(v=sql.105).aspx

 

After installation there is one more thing, the SQL Server Management tools are no longer in the setup.

image

You need to download the tools and install them separately.

For more information on SQL Server Management Tools 2016 and download link – https://msdn.microsoft.com/library/mt238290.aspx

And the new features – https://www.mssqltips.com/sqlservertip/3683/new-features-in-sql-server-management-studio-for-sql-server-2016/

image

The installation:

image image

 

Setup of SQL server 2016, .net framework 3.5 dependency …finally gone ! Smile (so yes! it can be done but more on that later)

SCOM 2016 Installation

The installation is similar as we know, select your components and go ! For reference on the report viewer, I have also added a PowerShell Script which installs or downloads these components for you.

 

prerequisites for   console:

Reportviewer 2015 – https://www.microsoft.com/en-us/download/details.aspx?id=45496

SQL CLR Types 2014  – https://download.microsoft.com/download/1/3/0/13089488-91FC-4E22-AD68-5BE58BD5C014/ENU/x64/SQLSysClrTypes.msi

 

Or simply use my updated PowerShell prerequisites script – http://www.owl-it.nl/uncategorized/scom-2016-2012-prerequisites-on-windows-server-2016-2012/

clip_image001 clip_image001[4]
clip_image001[6] clip_image001[8]
clip_image001[10] clip_image001[12]
clip_image001[14] clip_image001[16]
clip_image001[18] clip_image001[20]
clip_image001[22] clip_image001[24]

Okay install!

clip_image001[26]

Nooo Come on not again! I have had my share of failed installations during my days believe me …GRR Sad smile

okay here we go to trouble shooting endlessly and ……hmmm wait to soon … just a remark about eval …pffff Smile

Reporting

Installation of the reporting console

Don’t forget to configure and test the reporting websites prior to installing!

clip_image001[1] clip_image001[3]
clip_image001[5] clip_image001[7]
clip_image001[9] clip_image001[11]
clip_image001[13] clip_image001[15]
clip_image001[17] clip_image001[19]
image  

 

Up next the web console….

Web Console

I started the installation for the web portal part.

I decided to use the prerequisites script from my SCOM buddy Kevin Green –

And changed it to Windows Server 2016, Where you have the option to choose if 2016 or not.

If yes it will install the 2016 prerequisites if No the “old” version of the script is used.

When I was testing this the installation kept complaining about missing component:

image

 

Figured since it is all based on .net framework 4.5 now no longer .net 3.5 is required, right?

Nope Sad smile still .Net Framework 3.5 required…….really !?!!?

So you still need the Windows Server 2016 bits to install .net framework 3.5 just for the console.

I decided not to even bother with the Web Console and when I decided this I noticed a blog post from my SCOM buddy Marnix Wolf – http://thoughtsonopsmgr.blogspot.nl/2016/09/scom-2016-web-console-no-more.html?utm_source=twitterfeed&utm_medium=twitter

And couldn’t agree more with Marnix!

Still on .net framework 3.5 dependency and to top this… still the legacy, crappy old silverlight… noooo

My recommendation….just go with the squared up version – https://squaredup.com/ there is even a free community version now Smile

If you want to install the WebConsole you can use my updated PowerShell prereq script –

 

Issues

After installation I started up the console and no big changes except for the maintenance schedules.

Clicking it immediately gave me an error message stating my data access account had not enough access to run a sp on the msdb database.

EXECUTE Permission was denied on the object ‘sp_help_jobactivity’ database ‘msdb’ schema ‘dbo’

 

clip_image001[28]

a temporary fix for this was granting the Data access account sys admin on the SQL server.

This is quick and dirty fix just for lab purposes but this should be fixed I assume in the final release version.

After checking the maintenance I opened the Administration console to check the management packs and other settings.

opened the Tune Management packs pane and again struck by an error message:

image

Not sure what caused this but after closing the console and re-opening it didn’t appear anymore, maybe I was to fast Winking smile

 

Will post more on the new features and new stuff soon Smile

 

Cheers,

Oskar Landman

Geplaatst in Uncategorized | Één reactie

SCOM 2016 / 2012 Prerequisites on Windows Server 2016 / 2012

Since Windows Server 2016 has a slightly different setup for the roles and services (application role no longer available).

I have rewritten the script from Kevin Green to quickly install SCOM 2016 prerequisites.

Thanks Kevin Green , and Steve Beaumont and Tim McFadden to be precise!

It will ask if you are installing on Windows Server 2016, if yes the installation will use the Windows Server 2016 specific settings.

And if you are installing SCOM 2012 or SCOM 2016.

 

download – https://gallery.technet.microsoft.com/SCOM-2012-2016-Prerequisite-bf084c0a

Script “SCOM2012_2016_Prerequisites.ps1” – all

Script ““DownloadOnly_SCOM2012_2016_Prerequisites.ps1” only for downloading prerequisites

image

 

image

image

image

It will download the installation files automatically.

 

If you prefer to download the installation files on another location just use below script  “DownloadOnly_SCOM2012_2016_Prerequisites.ps1”and copy folders to the installation server:

image

 

 

That’s it!

 

Cheers,

Oskar Landman

Geplaatst in Uncategorized | Een reactie plaatsen

SCOM Health Check Reports V3–SCOM 2012 Supported!

This is just a quick post on an update on the SCOM health check reports V3.

Several people asked for a 2012 version, since there were references to newer packs the pack needed to be updated. ( or downgraded to be honest Winking smile

Sorry for the delay this one has been laying around for a while. Received this version but “forget” to upload the version. My bad Sad smile

 

I would like to thank Natascia Heil for her great work on making a 2012 compatible version of the management pack.

All credits go to Natascia!

Please check her awesome work on her blog System Center Tipps –  https://systemcentertipps.wordpress.com/

 

oh and for the updated version, I have attached it to the download.

 

Cheers,

Oskar Landman

Geplaatst in Uncategorized | Een reactie plaatsen