How to Remove Clipboard Formating with PowerShell

Often there is a need to eliminate formatting in the clipboard. This can be done with Microsoft Office – but of course also with PowerShell – and very easily. I found this on Twitter, and its like that:

#Correct Version 
Get-Clipboard | Set-Clipboard

# Short
gcb | scb

And sometimes you might not have a PowerShell Window open. So hit < Windows-r > and run one line of this:

#PowerShell 7
pwsh -nop -c "&{gcb|scb}"

#Windows PowerShell
powershell -noprofile -command "& {gcb|scb}"

So this is the easy PowerShell way to remove format information in the clipboard. Since I need it really often I just said New Link – with the command in the properties – and put the link into the task bar- so I only need to click it – and the formating is gone. Simply great!

Students cannot access Azure Lab Services VM

We had an temporary issue on Azure Lab Services. So our students are getting “the bear” insted of their Vm. If you try it some minutes later, it could be, that you see your vm, or again the bear.

It was possible to connect to the virtual machines the whole time, when the machine was started and you know the name and port of your machine.

We did not find anything in the logs about this behavior.

Azure Status

Sometimes you simply want to know the status of the Azure Service you are using. There are several ways to find out, what is going on.

At first, of course, the official sites:

• https://status.azure.com/de-de/status
• https://portal.office.com/servicestatus
• https://portal.office.com/adminportal/home?#/servicehealth
• https://twitter.com/msft365status

So sometimes, it seems, that everything is fine, but is it really ok? So you can ask the community:

• US Community Azure: https://downdetector.com/status/windows-azure/
• US Community O365: https://downdetector.com/status/office-365/
• DE Commuinty Azure: https://xn--allestrungen-9ib.de/stoerung/windows-azure/
• DE Community O365: https://xn--allestrungen-9ib.de/stoerung/office-365/
• AT Community O365: https://xn--allestrungen-9ib.at/stoerung/office-365/ (had to mention this one 😉

And finaly, there is someone, who collects all the issues and presents it on a website:

• Azure: https://statusgator.com/services/azure
• O365: https://statusgator.com/services/microsoft-office-365

As you see, there are some possibilities to find out, what’s going on on Azure – and if you are the only one experiencing an error. And remember, if you find an Azure outage, let the community know and click the appropriate link above!

Azure Lab Services – publish a lab does not work

These days I have the issue, that Azure Lab Services does not work as expected.

I’ve opened a Question at Stackoverflow, but now I think it is better to document it in my blog.

The publication takes between 5 and 6 hours and has no result – the lab is not published afterwards. (normally the publishing lasts less then 1 hour – and it is published afterwards) If you look into the log, you only see the entry that the publication has started. The only message you see is in german “Veröffentlichung aufgehoben” – in english there is text “Unpublished”

At first we thought the behavior might depend on the user, but now we think it is the order of creating the lab. It simply do not work creating the lab with the idle settings set. It seems like it works best with:

1. Create the lab
2. Publish the lab
3. Try to set the settings

The first two steps will complete in the given timeframe, but the last one lasts very long and gives an error:

An error occurred while updating shutdown policy settings. Please refresh the page and try again.

This ist the unsatisfiying status – will be updated.

3:26 pm : We are using an Image, which will join with our domain – so next I try one with the join disabled.

Start learning Azure SQL

There is a new learning scenario for Azure SQL – starting today. I got that hint from Anna Hoffmann – and I think they produced really great stuff. Especially have a look at the Channel 9 Bootcamp – with the option to get questions answerd by Microsoft directly.

After completing the video series, learning path, or workshop, you will have a foundational knowledge of what to use when, as well as how to configure, secure, monitor, and troubleshoot Azure SQL. 

They provide a learn Azure SQL landing page and some more resources to mention

1. Microsoft Learn: Azure SQL Fundamentals http://aka.ms/azuresqlfundamentals – 6 course learning path
2. Youtube: 61 Youtube videos http://aka.ms/azuresql4beginners
3. Github: 1-2 day workshop Azure SQL including hands-on labs https://aka.ms/sqlworkshops
4. Channel 9 Live Bootcamp from 17th August to 20th August 4PM – 6PM GMT. http://aka.ms/azuresqlbootcamp
5. Official announcing tweet

Anna Hoffmann and Bob Ward

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.