System Center Orchestrator SQL Query–Runbook Run Count

This will be a short Post, sometimes it can be helpful to get a List of Runbooks and the Count, on how many times the Runbook has been executed.

Maybe if you are looking for most executed Runbook in case of an Performance Issue or you just want to track your environment.

Get Runbook Execution Count from the last Month

use Orchestrator

select	Name, count(policies.UniqueID) as Count from Policies 
inner join POLICYINSTANCES on policies.UniqueID=POLICYINSTANCES.PolicyID 
where POLICYINSTANCES.TimeEnded > DATEADD(mm,-1,GETDATE()) 
group by name 
order by Count Desc


 

(Read more…)

System Center 2019 is here

System Center

System Center

Yesterday Microsoft announced System Center 2019 is generally available.

System Center 2019 is a long term servicing channel (LTSC) release which will be supported for 10 years.

System Center 2019 supports Windows Server 2019 across the board and enables deployment, management and monitoring of Windows Server 2019 at data center scale. The key capabilities of this release include:

(Read more…)

PowerShell BackupScript Version 1.4 released

I have updated my PowerShell Backup Script and want to provide you the new Release

I have added some New Feature, Staging Folder, Exclude Dirs, 7Zip Support and fixed some Bugs.

Please comment and rate the Script on TechNet

IMPORTANT, the Script is now on GitHub: https://github.com/Seidlm/PowerShell-Backup-Script

(Read more…)

Fix SCSM Console Issues

Some time it can happen, that your System Center Service Manager Console is not working like expected.
For example

  • Changes are not visualized in the Console
  • If you open an Element, the new Window is very small
  • Console won’t open
  • some other Problems

So, there are several ways to fix this Problems, please take a note, after some steps, it might be necessary to enter your SCSM Server Information once again, like on the fist startup.

Make sure, you close your Console before trying the next steps.

Clear Console Cache

that’s the easiest one, start your SCSM console with the /cache command, for example
„C:\Program Files\Microsoft System Center 2012 R2\Service Manager\Microsoft.EnterpriseManagement.ServiceManager.UI.Console.exe“ /cache

(Read more…)

How to Alert LaMetric Watch with PowerShell

I have made me a Christmas Present by myself, and ordered a LaMetric Watch a few days ago. If there is someone, who don’t know what this is, take a look here: https://lametric.com/

After some time, configuring and playing around, I got the idea to push Messages to the LaMetric Watch with PowerShell.

It took only a few minutes, reading the API Documentation and write some PowerShell Code, and it worked like a charm.

It took some more time, to write a nice looking PowerShell Code Smileand to write this Article to provide you this Information.

The complete PowerShell Script is available at the Microsoft TechNet Gallery, see the Link at the bottom.

Preparation

Of course, you have to configure your LaMetric Watch and connect it to your Wi-Fi, I will not guide you through this steps Smile

We need the IP and the API Key, the IP should be an easy one, go to your DHCP Server and check the IP, or open the LaMetric APP on your Phone, Settings About, and Wi-Fi, there is your IP

The API Key can be found in the Developer Area at the LaMetric Web Page, in the Device Section: https://developer.lametric.com/user/devices

See this Article for more Help if needed: https://lametric-documentation.readthedocs.io/en/latest/guides/first-steps/first-local-notification.html

Replace the Information at the following Part in the Script

 

Settings and Script

The rest of the Script is straight forward, you have some settings, which are listed in the Script itself, if your interest in some more Details, take a look at the API Docs from LaMetric: https://lametric-documentation.readthedocs.io/en/latest/reference-docs/device-notifications.html

Result

IMG_0897

 

 

 

TechNet Gallery Download: https://gallery.technet.microsoft.com/Send-LaMetric-Watch-Alert-deaedc7a

All my Downloads are here: 1jrYQoA

Rate my Downloads please and tell me your Ideas for the next Release.

Michael Seidl aka Techguy

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

Altaro VM Backup for Hyper-V and VMware

logoIn this Post, i want to take a closer Look at one my Blog Sponsor. Altaro VM Backup is providing a high performance VM Backup Solution. Before we start with some Key Features, let me introduce Altaro VM Backup.

With Altaro VM Backup, you only need to Backup your VM’s, doesn’t matter if it is HyperV or VMware. You need to license only the amount of Hosts, not the amount of Cores. And the best, for 2 VM’s it is absolutely free.

Feature Highlight

Backup every 5 Minutes

With the newest Release, it will be possible to backup your VM’s up to every 5 Minutes. So will loos nearly no Data in Case of a Desaster.

Boot from Backup

Each Backup is only as good as the Restore time. With Altaro VM Backup you will be able to Boot your VM directly from your Backup Vault, without the a Recovery-time.

Support for Azure Cloud

Of course, also Altaro VM Backup is supporting the offsite Backup to the Azure Cloud. So your Backup is really secure and offsite with support for Azure Backup Vault.

And many more…

Of course, above i have only mentioned a few Features, just to name some more:

Augmented Inline Deduplication, vCenter and CSV Support, Backup with zero Downtime, Central Console, automated Tests and lot more.

Summary

As you know, i am a SCDPM Fanboy for a very long time, but some Features are definitely worth trying Altaro VM Backup.

You can download a 30-day trial of Altaro VM Backup. After 30 days, you’ll get forever free backup for 2 VMs

 

PowerShell BackupScript Version 1.3 released

I have updated my PowerShell Backup Script and want to provide you the new Release

I have added some New Feature, Send Log File via Mail, Exclude Dirs, Zip the Content and fixes some Bugs.

Please comment and rate the Script on TechNet

(Read more…)

I am speaking at….

Greenshot 2018-02-19 19.49.56

I have two speaking slots coming in May 2018. One at CDC Germany and one at the Base IT Infrastructure Days.

Let’s start with the first one.

CDC Germany – third year in a row, I am selected by Carsten to speak at CDC Germany, But this will be the first time I am not talking about SCDPM, I wanted to try something new. So I asked Carsten if someone else will speak about SCDPM, and he found one, Charbel Nemnom.

So I am having the Chance to talk about a topic I worked mainly in the last 3 years with, and was having a lot of cool projects. The Title will be „The rising Phoenix – Service Management and Automation with System Center„. But enough said, come to Hanau on the 15th of Mai 2018 and listen my slot, and of course, there are a lot more create speakers there. The Slot will be in german.

Base IT Infrastructure Days – One day after CDC, on May 16th, 2018, I will attend the Base IT Infrastructure Days, so that’s the reason I have to leave early from CDC. I will talk more about Azure, so Azure Backup, OMS Log Analytics, Service Maps and so on. More Details will follow.

So hope to see you in Hanau or Ansfelden in May.

Michael Seidl aka Techguy