au2mator WEBCAST Recording – Self Service your IT with au2mator

I have done a Webcast a few days ago, on how to use au2mator Self Service Portal, here is the recording, enjoy.

 

Orchestrator SQL Query to get Runbook running-time

Lately, we had a Requirement, at one of our Customers, to alert someone, if a Runbook is longer running than 30 minutes. There is a way to write an Event Log if a Runbook is running longer than XX Minutes, but this has to be configured for each single Runbook, so that wasn’t a good Solution.

So I have created a small SQL Query for that, which I would like to present to you. feel Free to use.

 

The Script

select 
Policies.name,
ins.TimeStarted,
DateDiff(second, ins.TimeStarted, GETUTCDATE()) as Totalseconds ,
DateDiff(second, ins.TimeStarted, GETUTCDATE()) / 3600 as Hours, 
(DateDiff(second, ins.TimeStarted, GETUTCDATE()) % 3600) / 60 as Minutes, 
DateDiff(second, ins.TimeStarted, GETUTCDATE()) % 60 as Seconds

from POLICYINSTANCES as Ins
inner join POLICIES on Ins.PolicyID=POLICIES.UniqueID

 where Ins.Status is null and Name not like '%-MON-%'
order by Totalseconds desc

The Result

image

Some Information

The SQL Script is excluding all Runbooks which contain “-MON-“, cause this are the Monitoring Runbooks, we don’t want to alert, cause they are running all the time.

We are calculating the totalseconds, and additionally the hours, minutes and seconds as a Result.

 

Michael Seidl aka Techguy

Geekschau Webcast about SCOOSP

gast_geekschau_michael_seidl-768x422Hi, i have been invited by Eric Berg and Alexander Benoit to participate at Geekschau and present SCOOSP. We have recorded the Webcast last week, the Video is now online.

Note: the Webcast has been recorded in German

Geekschau: https://geekschau.de/geekschau-scoosp/

Michael Seidl aka Techguy

Geeksprech Podcast Talk about SCSM and Automation

logo_michael_seidlHi, i have been invited by Eric Berg and Alexander Benoit to talk about Service Management and Automation. We have recorded the Podcast last week, now it is available on all the known Platforms.

Podcast is available here: https://geeksprech.de/geeksprech-podcast-folge-24-automatisierung-und-service-management/

Note: thePodcast has been recorded in German

SCOOSP 3.0.811 released

mcstereo300_newSCOOSP is happy to release the Version 3.0.

There has been a lot of work, but we are really happy to announce our new Release.

SCOOSP is providing a Self Servie Portal to start SCO, SMA or Azure Automation Runbooks.

Also very important, tell us what you want to see next: SCOOSP Future Survey.

See this List of Changes

CHANGES:

  • NEW DESIGN
  • NEW FEATURE: Show AD Photos on Team Page
  • NEW FEATURE: Multilanguage for Announcements
  • NEW FEATURE: New Question Type INT
  • NEW FEATURE: Enhanced Logging
  • and a lot more

To try SCOOSP for free, go here: https://scoosp.com/freedownload/

 

Win Tickets for Experts Live Austria and Lowlands Unite Belgium edition

mcstereo300_newSCOOSP, your Self Service Portal for Orchestrator, SMA and Azure Automation is proud to be a sponsor of the following two Events.

Experts Live, Vienna, 7th of November 2017 – http://www.expertslive.at/konferenz.html

Lowlands Unite Belgium, 19th of October 2017 – http://scug.be/events/

As a Sponsor we are happy to provide you with 2 Tickets, for each event.

How to win:

Write a Comment on this Facebook Post, what Event you would like to win a Ticket

Winners will be contacted after the 10th of October via Facebook from SCOOSP.

New_SCOOSP_486x60

 

 

Get a free printed SCO Cookbook 2016

19983349_10213512180022234_3764719510414147102_oHi,
As you may know, I have written the actual System Center 2016 Orchestrator Cookbook.
Now PacktPub is providing me 10 free, printed copies, that’s your chance.
Enter Your Name and Mail Address as a Comment below this Article, the first 10 will get a free Copy.

After that, PacktPub will contact you for the Details.

So hurry up.

Michael Seidl aka Techguy

My First Book, SCO 2016 Cookbook

19983349_10213512180022234_3764719510414147102_oHi all, I am feeling really proud, cause my first book has been published a few days ago.

A few months ago, the guys from PacktPublishing asked me to write the System Center 2016 Orchestrator Cookbook. It took not too long to make a decision and this was positive.

So I have decided not only to write an update, I have done a complete makeover of this book.

I have added a lot of new Recipes and have added a lot of my experience from the past 6 years. In the End, we have a complete new book, so go ahead and get your copy.

http://amzn.to/2t8fZmX

Don’t forget to write a Review on Amazon.

Thanks

Michael Seidl aka Techguy

 

Upgrade to System Center Orchestrator 2016

System Center Orchestrator should be the first Product to upgrade to 2016, so we also will start with SCO.

The Upgrade is straight forward and an easy one, but we have some pre-checks to make sure everything runs smooth.

First we will make a small Health Check to make sure SCO is doing fine, afterwards we proceed with our Backups followed by uninstall 2012 R2 and Installing 2016.

Lets go.

SCO Health Check

We normally use the “Orchestrator Health Checker” to get a quick overview of our environment. You an download the small Tool here:  http://scorch.codeplex.com/releases/view/99063

So take a look at your running and queued Runbooks and make sure nothing important is sill running or not to many Runbooks are in Queue.

After we have made sure that our SCO is healthy, we can take the next step.

(Read more…)

System Center 2016 is here

 

We have been waiting a long time, Microsoft released the new System Center 2016 suite nearly a month ago.

A few days after, also Update Rollup 1 has been released.

As I am mainly related to SCDPM, SCSM and SCO, I will show you all the news around these three Products

So lets take a look, what’s new with System Center 2016.

Service Manager 2016

  • Time to create and update Work Item is reduced
  • Workflows are faster
  • Group and queue calculations improved
  • Faster SCCM and Active Directory Connector
  • Grooming improvements

    (Read more…)