Category: Coding

Wake-on-LAN using PowerShell

Wake-on-LAN and the Magic Packet The format of a Wake-on-LAN (WOL) magic packet is defined as a byte array with 6 bytes of value 255 (0xFF) and 16 repetitions of the target machine‚Äôs 48-bit (6-byte) MAC address. (See Wikipedia article) Wake-on-LAN works by broadcasting the magic packet to all network devices in a network. The…



Chocolatey on Windows

Introduction Chocolatey is a Windows counterpart to the Linux apt package manager or yum package manager. The software offers a CLI-based package installation and management in Windows with the community-maintained package repository. In this tutorial, you will learn to install Chocolatey on Windows 10 and learn basic Chocolatey commands. Prerequisites Windows 7+/Windows 2003+ (including Server Core, but excluding…




PowerShell – Quickly create a GPO report

Someone asked me today how to easily export a readable report of all GPOs applied to a system (they were doing a security audit and needed a simple way to script this). Of course, I immediately thought of PowerShell! So here is how to export a readable report of all GPOs applied to a given…



How to view/inspect the generated SQL by Entity Framework Core using .NET Core’s build-in logging

Referring: https://docs.microsoft.com/en-us/aspnet/core/fundamentals/logging/?view=aspnetcore-5.0 This blog post is about how to view the SQL generated by Entity Framework Core. This method uses Microsoft’s built-in logging for .NET Core. This method is an alternative to profiling the SQL with something like SQL Server Management Studio. This will work with an ASP.NET Core application, which should cover the vast…



Publishing an ASP.NET Core Web Application to IIS using Visual Studio 2019

I’m a developer at heart, so I’m constantly keeping up with the latest technologies. currently I’m developing ‘Time and Bill’, an ASP.NET Core Web Application. The application is based on Microsoft .NET Core 5.0 (5.03 to be exact). Well, developing the application is one thing, the other thing is to publish the application on an…



How to access an Exchange Online mailbox without a license

An Office 365 or Microsoft 365 Admin will hopefully have a separate admin account to perform higher level (privileged) tasks, compared the their standard user account. As a result, admin accounts should not need any license, because they are not used as a normal user. A person should not need to have two sets of…




Microsoft Teams – Quickly add a Webhook to a Teams channel and send a message using PowerShell

I just discovered the possibility to add Webhooks to a Teams Channel. Since webhooks are nothing new to me, i wanted to know if my PowerShell Scripts i created when i was playing last time with Webhooks if they’re working with the Teams API as well – surprise, i created a Webhook and sent a…




Get your WAN/public IP address using PowerShell and ipify.org

I just discovered the ipify.org service to quickly get your public / WAN IP address. https://www.ipify.org/ – API Usage for IPv4 So to get the WAN / public IP address using PowerShell (New-Object System.Net.WebClient).DownloadString(‘https://api.ipify.org’) Or get it as JSON and ConvertFrom-Json-it (New-Object System.Net.WebClient).DownloadString(‘https://api.ipify.org?format=json’) | ConvertFrom-Json Yeah, i know, my WAN IP is visible in the…




File in use / Use PowerShell to find out witch process is locking a file

When we tried to upgrade to the latest Nextcloud Client (Version2.6.5), we were confronted with the following error message. The file C:\Program Files\Nextcloud\shellext\OCOverlays.dll is in-use and can’t be overwritten -> (if you think about it, it’s already clear that the Explorer Proess ‘locked’ this file, as this library is most likely used to overlay the…




PowerShell Active Directory Module – Cheat Sheet

Retrieve all Windows Server Computer Get-ADComputer -Filter ‘operatingsystem -like "*server*" -and enabled -eq "true"’ ` -Properties Name,Operatingsystem,OperatingSystemVersion,IPv4Address | Sort-Object -Property Operatingsystem | Select-Object -Property Name,Operatingsystem,OperatingSystemVersion,IPv4Address Retrieve all Windows Client Computer Get-ADComputer -Filter ‘operatingsystem -notlike "*server*" -and enabled -eq "true"’ ` -Properties Name,Operatingsystem,OperatingSystemVersion,IPv4Address | Sort-Object -Property Operatingsystem | Select-Object -Property Name,Operatingsystem,OperatingSystemVersion,IPv4Address Retrieve all Domain-Controllers (w/o Member…