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

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.