PowerShell 7 launch Austria

We’ve had a great PowerShell 7 launch in Austria. See PS7 launch Event Nachlese for more details or see the event video.

Ready for the launch

Steve Lee answering questions

The PowerShell Team also made 10 really good videos for the event. So I really want to mention them:

• https://aka.ms/PS7-Part1
• https://aka.ms/PS7-Part2
• https://aka.ms/PS7-Part3
• https://aka.ms/PS7-Part4
• https://aka.ms/PS7-Part5
• https://aka.ms/PS7-Part6
• https://aka.ms/PS7-Part7
• https://aka.ms/PS7-Part8
• https://aka.ms/PS7-Part9
• https://aka.ms/PS7-Part10

I hope to see you on future events @ expertslive.at.

Azure Heat Map

There is some need to have a look on azure – and what’s hot there. And, Azure Heat Map helps you to find out, where Microsoft is investing into in the cloud. This is, how it looks like today. Surprisingly for my, Azure VM has lot’s of updates. But see yourself.

PS7 launch Event – #PSUGMUNICH

We, the PowerShell Usergroup Munich, had our first online only Meeting. And it was great! Thank you Sydeny!

I tried to save the hints we got during the session in this Blog Post – it was written while the meeting happend – so there is not too much text.

First: Vote for more than 4 concurrent video streams (Link)

Q&A with Sydney Smith

PowerShell 7 Module Compatibility

• https://aka.ms/PSMOduleCompat

Online PowerShell 7 Infos

• from https://www.youtube.com/channel/UCiTuB6HZiupE8CJ71vkMFnA/featured

PowerShell to EXE

• https://gallery.technet.microsoft.com/scriptcenter/PS2EXE-GUI-Convert-e7cb69d5

Download Ignite

Download all Ignite Sessions with PS7:

• https://gist.github.com/ddneves/d408dad507511523b5ddb0c46e2b9b6f

Secret Management

Two articles about Secret Management with PS7.1 and above

• https://myignite.techcommunity.microsoft.com/sessions/83981?source=sessions
• https://devblogs.microsoft.com/powershell/secret-management-preview-2-release/

Jupyter Notebooks

• https://sqldbawithabeard.com/2020/02/07/new-net-notebooks-are-here-powershell-7-notebooks-are-here/
• https://sqldbawithabeard.com/2020/02/22/use-jupyter-notebooks-to-hxelp-people-on-stackoverflow/

Error View

Link

Azuer Learning

• https://github.com/ddneves/awesome-azure-learning

The Barman Microsoft Teams background

• https://www.xsplit.com/de/vcam

ITNetX Service Manager Portal tells “no rights”

After a boot yesterday the ITNetX System Center Service Manager Portal was no longer available. The Website only returned, there are no rights – even as administrator.

The error message – as text at the bottom of this post

The Solution

In the Internet Information Server I changed the Application Pool to .NET CLR Version 4 – restarted IIS and the Website was back again.

Error message as test (english)

You do not have permissions to access this item or perform the requested task. If you believe you receive this message by mistake, please contact your administrator.
Show more… Copy for itnetX Support

Attempted to perform an unauthorized operation.
•Stack Trace
•Request

at System.Security.Principal.WindowsIdentity.get_AuthenticationType() at itnetX.ITSMPortal.Models.SDK.SdkService.RunImpersonated[T](Func`1 action) at itnetX.ITSMPortal.Models.SDK.SdkService.get_IsEndUserOnly() at itnetX.ITSMPortal.Helpers.MVC.TagHelpers.ModeselectorTagHelper.Process(TagHelperContext context, TagHelperOutput output) at Microsoft.AspNetCore.Razor.TagHelpers.TagHelper.ProcessAsync(TagHelperContext context, TagHelperOutput output) at Microsoft.AspNetCore.Razor.Runtime.TagHelpers.TagHelperRunner.d__0.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at AspNetCore._Areas_EndUser_Views_Shared__EndUserHeader_cshtml.d__48.MoveNext() in /Areas/EndUser/Views/Shared/_EndUserHeader.cshtml:line 10 — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Razor.RazorView.d__14.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Razor.RazorView.d__13.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.ViewFeatures.HtmlHelper.d__60.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.ViewFeatures.HtmlHelper.d__57.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Rendering.HtmlHelperPartialExtensions.Partial(IHtmlHelper htmlHelper, String partialViewName, Object model, ViewDataDictionary viewData) at AspNetCore._Areas_EndUser_Views_Shared__LayoutEndUser_cshtml.d__143.MoveNext() in /Areas/EndUser/Views/Shared/_LayoutEndUser.cshtml:line 62 — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Razor.RazorView.d__14.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Razor.RazorView.d__13.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.ViewFeatures.ViewExecutor.d__18.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.ViewResult.d__26.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__32.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__31.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__29.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__23.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__18.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Builder.RouterMiddleware.d__4.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Localization.PortalRequestLocalizationMiddleware.d__5.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Session.SessionMiddleware.d__9.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.AspNetCore.Session.SessionMiddleware.d__9.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at itnetX.ITSMPortal.Helpers.ExceptionMiddleware.ExceptionGeneralMiddleware.d__4.MoveNext()

General info:
Method GET
URL /
Query

Headers:
Connection Keep-Alive
Accept text/html, application/xhtml+xml, /
Accept-Encoding gzip, deflate
Accept-Language en-US,en;q=0.5
Host servicedesk.bbrz-gruppe.at
User-Agent Mozilla/5.0 (Windows NT 6.3; WOW64; Trident/7.0; rv:11.0) like Gecko
MS-ASPNETCORE-TOKEN c7873e84-107d-487e-ae85-8e634bb73057
MS-ASPNETCORE-WINAUTHTOKEN 444
X-Original-Proto http
X-Original-For 127.0.0.1:49304

Copyright © itnetX AG. All rights reserved v.3.7.5

Error Message as Text (german)

Sie haben keine Berechtigung, auf dieses Element zuzugreifen. Für weiterführende Informationen kontaktieren Sie bitte den Administrator.

Attempted to perform an unauthorized operation.

at System.Security.Principal.WindowsIdentity.get_AuthenticationType() at itnetX.ITSMPortal.Models.SDK.SdkService.RunImpersonated[T](Func`1 action) at itnetX.ITSMPortal.Models.SDK.SdkService.get_IsEndUserOnly() at itnetX.ITSMPortal.Helpers.MVC.TagHelpers.ModeselectorTagHelper.Process(TagHelperContext context, TagHelperOutput output) at Microsoft.AspNetCore.Razor.TagHelpers.TagHelper.ProcessAsync(TagHelperContext context, TagHelperOutput output) at Microsoft.AspNetCore.Razor.Runtime.TagHelpers.TagHelperRunner.<RunAsync>d__0.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at AspNetCore._Areas_EndUser_Views_Shared__EndUserHeader_cshtml.<ExecuteAsync>d__48.MoveNext() in /Areas/EndUser/Views/Shared/_EndUserHeader.cshtml:line 10 — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Razor.RazorView.<RenderPageAsync>d__14.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Razor.RazorView.<RenderAsync>d__13.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.ViewFeatures.HtmlHelper.<RenderPartialCoreAsync>d__60.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.ViewFeatures.HtmlHelper.<PartialAsync>d__57.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Rendering.HtmlHelperPartialExtensions.Partial(IHtmlHelper htmlHelper, String partialViewName, Object model, ViewDataDictionary viewData) at AspNetCore._Areas_EndUser_Views_Shared__LayoutEndUser_cshtml.<ExecuteAsync>d__143.MoveNext() in /Areas/EndUser/Views/Shared/_LayoutEndUser.cshtml:line 62 — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Razor.RazorView.<RenderPageAsync>d__14.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Razor.RazorView.<RenderAsync>d__13.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.ViewFeatures.ViewExecutor.<ExecuteAsync>d__18.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.ViewResult.<ExecuteResultAsync>d__26.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeResultAsync>d__32.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeResultFilterAsync>d__31.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeAllResultFiltersAsync>d__29.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeResourceFilterAsync>d__23.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeAsync>d__18.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Builder.RouterMiddleware.<Invoke>d__4.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Localization.PortalRequestLocalizationMiddleware.<Invoke>d__5.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Session.SessionMiddleware.<Invoke>d__9.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.AspNetCore.Session.SessionMiddleware.<Invoke>d__9.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at itnetX.ITSMPortal.Helpers.ExceptionMiddleware.ExceptionGeneralMiddleware.<Invoke>d__4.MoveNext()General info:

Copyright © itnetX AG. All rights reserved v.3.7.5

Check if all Module Pathes are valid

Wanted to check, if all of my PowerShell module pathes are valid. This little Script helps.

$env:PSModulePath.Split(';') | select @{l='Path';e={$_}}, @{l='Valid';e={Test-Path $_}} 

The output looks like that:

So this a very easy method to check if all pathes are valid.

Visiting ExpertsLiveEU

Visiting the ExpertsLiveEu this year with a datacenter automation point of view.

The beginning…

On the way to the hotel I listened to Jeffrey Snover to get me in the mood. (O365 with Graph).

PowerShell is everywhere, even in Vikings

First the news I’m focusing on are from System Center. Some people of the system center team have been to Prague. So what I’ve heard is, that we will get a System Center Update in spring 2020 – but it will not contain the 64bit update for Orchestrator – therefor you will still have to work around. But in the next larger release – the vNext – which will happen in two or three years (or like that), there will be this update. So this also means, Orchestrator (and System Center) will stay on the stage at least for 12 years. There is no urgent need to discuss a replacement here.

There will be some investment for new features in System Center Operations Manger (SCOM) an Virtual Machine Manger (VMM). It does not seem, there will be a lot in the other System Center products (beside SCCM, which is an other story)

So that are the System Center news I’ve heard.

In reference to the “System Center is dead”, Michael Ruüfli provoked with “Azure Automation is dead”. Microsoft employees in the room have denied this. Michael Ruüfli also compared Azure Functions with Azure Automation. In the end, both have their place in the Azure Cloud. Afterwards he presented an example with Microsoft Forms and Azure Functions – looked very exciting. (link)
What changes in Azure can be seen here: https://azurecharts.com/

Saw some other cool stuff, met lot’s of people and had a great time at the conference. Loved to be there. Thanks to Isidora and Marcel – they did a great job organising this conference.

And of course we also took a photo with all Austrians.

SQL Days Munich

At the SQL Days in Munich I held a session about PowerShell in combination with SQL Server. I was thrilled with the event, the participants and the other trainers. It was a great event and I hope to be there again next year.

PowerShell loves SQL on SQL days conference

My participants asked me to put the PowerShell scripts on Github – I’m happy to do so – it’s the first session on Github, but I think some more will follow.

SCORCH XML Paramters

We use System Center Orchestrator with the Orchestrator Integration Pack. In this Integration Pack there is an Activity “Start Runbook”. Which worked like a charm – till now.

We use this “Start Runbook” activity to start a runbook with parameters. We can use any string parameter in any length except XML strings. If the XML Input gets too long, the call fails. (see screenshot below).

The Integration Pack is on Github, but there is no activity beside the initial upload.

MVP Awards 2019

Last year I found an amazing analysis of the MVP award numbers. (See here) I hope he will publish this analysis this year again.

I’d like to save the numbers, so here we go:

Category	July 2018	July 2019
Development Technologies	780	644
Office Apps and Services	383	491
Azure	366	409
Data Platform	366	332
Cloud and DataCenter Management	302	232
Business Solutions	184	167
Windows Development	186	119
Enterprise Mobility	122	106
AI	?	84
Windows and Devices for IT	?	57
Office Development	?	47

So the two growing categories are Office Apps and Services and Azure.

(Data according to Patrick Guimonet and MVP Site)

Update: So there is a new site tracking MVP numbers. Have a look.

Multiple Microsoft Accounts – suggestion

We discussed lately, that we have troubles using Microsoft Teams with multiple accounts. There is already a Uservoice filed on this.

But I also have a similar situation in Microsoft Azure, Microsoft Outlook (including additional email accounts), and Office applications that refer to various Onedrives.

So I’d like to store all these accounts on one place – preferably in the cloud. And it would be even great, to switch on and off accounts per device.

So now I’ve described my solution to this Szenario – now I’m looking for whom to tell.