gitfvb

Copy logfile or log bak file into memory and then query on it

When using DuckDB CLI you can directly create an in-memory database with .open :memory:

CREATE TABLE log as 
WITH raw_log
AS (
	SELECT * exclude("Thread")
		,SPLIT("Thread", ',') AS ThreadArr

gitfvb

• Use a tool like clipchamp, snipping tool or xxx and download the mp4 recording.
• Then download ffmpeg from https://github.com/BtbN/FFmpeg-Builds/releases
• Crate a palette png for better colour quality

PS C:\Users\flo\Downloads\ffmpeg-n8.0-latest-winarm64-gpl-8.0\bin> .\ffmpeg.exe -i "C:\Users\flo\Downloads\win\video.mp4" -vf "fps=15,scale=1024:-1:flags=lanczos,palettegen" palette.png

• Convert the mp4 file with the palette.png into a gif

gitfvb

Open PowerShell session with administrator privileges and this example restarts at 6pm

shutdown /r /t ((Get-Date -Hour 18 -Minute 0 -Second 0) - (Get-Date)).TotalSeconds

gitfvb

add-type -path "C:\Program Files\Apteco\FastStats Service\Handel\Newtonsoft.Json.dll"

class DataItem {
    [string]$id
    [string]$name
}

# Define the main response class
class ApiResponse {
    [int]$replyCode

gitfvb

Steps to solve.

• Remove all 1.0.0.1 packages (also x86) from PowerShellGet and PackageManagement module folders
• Replace nuget.exe in C:\Users\<username>\AppData\Local\Microsoft\Windows\PowerShell\PowerShellGet
• Install a current .NET SDK
• When using a German OS, replace this line in C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\2.2.5\PSModule.psm1
• Possibly avoid VPN connection for publishing

 #$stdOut -match "Successfully created package '(.*.nupkg)'" | Out-Null

gitfvb

################################################
#
# INPUT
#
################################################

#-----------------------------------------------
# DEBUG SWITCH
#-----------------------------------------------

gitfvb

Install python (if not already done) and modules

Download and install python: https://www.python.org/downloads/

Then open a powershell window and install flask

pip install flask

gitfvb

To change the priority of the current running powershell process, do it like

#-----------------------------------------------
# SET UP PRIORITY
#-----------------------------------------------

$processId = [System.Diagnostics.Process]::GetCurrentProcess().ID
$currentPriority = ( get-process -Id $processId ).PriorityClass
If ( $currentPriority -ne "High" ) {

gitfvb

# Remove previous jobs first
Get-Job | Remove-Job

$runs = 100
$maxThreads = 10
$start = [datetime]::Now
$c = 0  # completed jobs
$sum = 0 # sum of results

gitfvb

Documentation: https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.diagnostics/get-counter?view=powershell-5.1

Show all available counters, be careful, this seems to be language dependent

get-counter -listset * | Out-GridView
get-counter -listset "*Netzwerk*" | fl
get-counter -listset "*Netzwerk*" | % { $_.Counter }