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

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

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…)

Update Rollup 8 for System Center 2012 R2 released

Microsoft released the Update Rollup 8 for System Center 2012 R2.

Update Rollup 8 contains Fixes and Updates for SCDPM, SCOM, SCO, SPF,  SCVMM and Windows Azure Pack.

The UR 8 and the Portal for SCSM will be released next week.

As we know, there is the possibility that the actual Update Rollup can contain some Bugs, so maybe wait a few days to install, or try it on a Test Environment.

Get all Information’s about Update Rollup 8 for System Center 2012 R2: https://support.microsoft.com/en-us/kb/3096378

Here are some Details

(Read more…)

Update Rollup 7 für System Center 2012 R2

Seit heute steht das Update Rollup 7 für die aktuelle System Center Familie bereit.

Update Rollup 7 für System Center 2012 R2 bringt viele Fixes für die Produkte SCDPM, SCOM, SCO, SCSM, SCVMM und Windows Azure Pack.

Bitte das Update zuvor in einer Testumgebung installieren, da wir aus der Vergangenheit ja wissen, das solche Update Rollups auch mal Probleme verursachen können.

Am besten auch mal ein paar Tage mit der Installation warten, sollte es Probleme geben, werden diese in den ersten Tagen nach Veröffentlichung ja bekannt gegeben.

Hier die Lister de betroffenen Produkte und der Download zum Update:

(Read more…)

Passwort Reset für Endbenutzer mit SCOOSP, SCO und einer SMS

Mit SCOOSP lassen sich ganz einfach, tolle Lösungen umsetzen. Lange schon geplant, habe ich jetzt eine Lösung erstellt, mit der sich der End User selbst sein Passwort zurücksetzen kann.

Da SCOOSP so aufgebaut ist, kann ein Team Mitglied den Request starten, durch die notwendige SMS Authentifizierung, entsteht hier aber keine Sicherheitslücke.

Aber hier mal die Lösung wie Sie umgesetzt wurde.

Send SMS Runbook

Das erste Runbook dient dazu die SMS zu versenden. Ich nutze dazu den Cloud Dienst Twilio welchen ich per PowerShell ansteuere.

Ihr könnt auch ein lokales SMS Gateway oder einen anderen Dienst verwenden, das spielt hier keine Rolle.

Das RB ist so aufgebaut, das Text und Empfänger per Initialize Data übergeben werden.

(Read more…)