PowerShell 10 Year

PowerShell got 10 years and our usergroup made an contribution to the 10 years anniversary. We had a lots of fun and we finnaly made a really nice video for the Channel 9 stream.

I want to thank all for making the video possible. Thanks to Daniel, who cut the statement video. He also made some Mountain videos – mainly from Upper Austria. These are really nice – so have a look at them.

What will you see in our contribution? Our usergroup members made some statements how PowerShell changed their lives and Roman & friends did an IoT video of his garden sprinklers – with some real nice action in it. Now have a look at the videos on Channel9:

Austrian contribution – Dwarfs and Moods and member statements

10 Year anniversary of PowerShell

Advertisements

Review of our Usergroup Meeting in Linz / Austria

We had our Linzer spring System Center and Powershell Usergroup on 28th of April. We managed to get three top speakers for the event. Our next Usergroup event will be at Microsoft Vienna on 30th of June. Register now!

So when you get interested in the user group, the information we share – find us on Xing or follow us on twitter for the newest information. (@scug_at).

As always we have had a nice location. The photos are this time from Stefan Koell.

Session 1: The role of IT operation in times of SaaS and PaaS

Rainer presented us in a really great and enthusiastic way how they see operations in their company timecockpit. He mentioned that they need very little ops and they need ops to know the service level agreements in the cloud.

He also teased, that Powershell is not necessary anymore, because in a SaaS world it should be only necessary to use the Service.

More about his thoughts is here in the Interview and he also recorded the session.

Session 2: SCOOSP – System Center Orchestrator Service Portal

In the second session Michael Seidl (aka Techguy) presented us SCOOSP – an easy to manage Portal for the System Center Orchestrator. With this portal you can do lots of things with less technical effort than using the System Center Service Manager and its portal. So when you are interested – have a look at it.

Session 3: Attack & Defend mit Powershell

In our last session Alexander Graf from Antares showed us their intrusion detection solution. They assumed an usb stick with maleware on it, which communicates with a command server. So their solution found the suspicious behavior.

So we have had three interesting Sessions from interesting speakers with some networking at the end with a really tasty “Mostviertler Bauernjause” including fantastic juices. Thank you Antares!

How to find out the actual Service Manager version via powershell

It was not that easy to find out the actual Version of our SCSM Installation, since Microsoft does not update the Info Window of Service Manager. So I wrote a powershell line, to find out.

Get-ItemProperty 'HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{7B523367-360B-4EB6-9ED4-D2637816DD0F}' | Select Displayname, Displayversion, installdate

There is an other way with SQL:

select * from servicemanager.[dbo].[__PatchInfo__] WITH(NOLOCK) order by appliedon desc

Import Excel generated csv to SCSM via powershell

If you want to bulk Import data to System Center Service Manager from CSV with german data using powershell, there two things to do right:

  1. Save the Excel spreadsheet as “CSV (Trennzeichen-getrennt) .csv”
  2. Import into SCSM with right encoding
    1. Import-Csv $Filename -Delimiter ‘;’ -Encoding Default
    2. Import-Csv $Filename -Delimiter ‘;’ -Encoding UTF7

That’s it.

SCSM Templates – Get all Workitems with a specific Title in an Activity

I wanted to find out, which Templates use a manual activity with a specific Value in the Title. This can also be used for other properties.

$findMAmatchTitle = ‘IMPORTANT’
import-module smlets
## get all Workitems at the highest level
get-scsmobjecttemplate | %{$so= $_ ; $_.ObjectCollection} | % {$_.Propertycollection} | ? { $_.mixedvalue -match $findMAmatchTitle } | %{$so}
## get all Activities - be aware no cascades like activities in parallel activities.
get-scsmobjecttemplate | %{$_.ObjectCollection} | % {$_.Propertycollection} | ? { $_.mixedvalue -match $findMAmatchTitle } | %{$_}

If you have activities in activities (eg parallel) you won’t get the second level.