Month: June 2020

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…




Publish ASP.NET Web App to IIS using import publish settings in Visual Studio

You can use the Publish tool to import publish settings and then deploy your app directly out of Visual Studio. These steps apply to ASP.NET, ASP.NET Core, and .NET Core apps in Visual Studio. In this tutorial, you will: Configure IIS so that you can generate a publish settings fileCreate a publish settings fileImport the…



IIS – create Web Site using PowerShell

In this article i’ll quickly document ‘how to create a web site using PowerShell’. IISAdministration vs WebAdministration Modules You have two options for managing IIS. You can use WebAdministration or IISAdministration. But which one should you use? If you’re using IIS IIS 10.0 or higher, the newer IISAdministration module offers a lot of improvements over the older…