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…




Sign your PowerShell scripts with a code signing certificate

Prerequisite is -> you need an issued and world or domain-trusted code signing certificate. Read more about how to issue a code signing certificate (CSR) and how to issue one using your in house Certification Authority Let’s start a PowerShell Console as admin – then use this command to list available code signing certificates: Get-ChildItem…




Issue a code signing certificate using your in house Windows Certification Authority

Prerequisites Active Directory with Certification Authority installed and configured. Your workstation should be domain-joined. Well, you could issue a code signing certificate on your CA and export the root certificate plus the code signing certificate and later import it in your local certificate store, but that’s another story which i won’t cover in this article….




Enable Code Signing template on your Certification Authority

Open the Certification Authority Microsoft Management Console (MMC) snap-in, and then select your issuing CA. When connected, right-click Certificate Templates, and then click New. in Enable Certificate Templates, select Code Signing Click on OK



WSUS Windows Update Error 0x80244010

Several Windows Server reported this Solution was connecting to SUSDB using Servername: np:\.\pipe\MICROSOFT##WID\tsql\queryStart SQL Server Management Studio elevated or get a Login failed for user Then query for the current value of MaxXMLPerRequest in table tbConfigurationC USE SUSDB GO SELECT MaxXMLPerRequest from tbConfigurationC Then update the value: UPDATE tbConfigurationC SET MaxXMLPerRequest = 0 And check…




Accessing SUSDB (Windows Server Update Services – WSUS) WID Windows Internal Database -> Login failed for user

SQL Server Management Studio installed, tried to connect to a SUS WID using Servername: np:\\.\pipe\MICROSOFT##WID\tsql\query Resulted in: =================================== Cannot connect to np:\\.\pipe\MICROSOFT##WID\tsql\query. =================================== Login failed for user ‘REMOVED\admin.solvia’. (.Net SqlClient Data Provider) —————————— For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476 —————————— Server Name: np:\\.\pipe\MICROSOFT##WID\tsql\query Error Number: 18456 Severity: 14 State: 1 Line Number: 65536 —————————— Program Location: at…



Install-Package : No match was found for the specified search criteria and package name ‘PsWindowsUpdate’. Try Get-PackageSource to see all available registered package sources.

Yeah, thanks M$, that’s what i always think when i just want to execute a basic task and i get a %&รง*% error message. I always install PsWindowsUpdate to manage Windows Updates on Servers and Workstations i’m responsible for because GUIs.. well, they limit you somehow.. Now, i got this error message again .. it’s…




actiTIME time reporting – MySql data and reporting

We’re using actiTIME (free version) for several years now. We’re happy with this time reporting/tracking solution, the only short coming for us are the integrated reports/the possibilities to create custom reports. In this article we’re going to Get an overview of actiTIME and database componentsGet access to the databaseCapture queries made by the actiTIME application…