Nordine Ben Bachir nordineb

Extract an MSI package

msiexec /a f:\zenworks\zfdagent.msi /qb TARGETDIR=c:\zfd701

Know Issues

Problem with localsystem

Localdb Automatic intances

MSSQLLocalDB
v12.0

(localdb)\ProjectsV12 instance is created by SQL Server Data Tools (SSDT)

Use myget as a NPM registry

npm update npm -g


npm config set strict-ssl true
npm config set ca ""
npm config delete proxy

Run npm install in every folder that contains a package.json file

$originalLocation = Get-Location
$folders = Get-ChildItem $originalLocation -Directory -Recurse -Name `
            | Where {$_ -notlike "*node_modules*"} `
            | Where {$_ -notlike "*jspm_packages*"} `
            | where { test-path (join-path $_ "package.json") }

. npm set progress=false

\sslyze.exe --http_headers   --json_out=JSON_FILE.json xxx.xxx.no:443

My recipe to:

Request Just in time virtual machine (VM) access
Start a PowerShell remote session to the VM

PowerShell Remoting over HTTP (unsecure!)

On the server

Start a Powershell CLI with elevated rights:

Enable-PSRemoting -SkipNetworkProfileCheck -Force
Set-NetFirewallRule –Name "WINRM-HTTP-In-TCP-PUBLIC" –RemoteAddress 172.0.0.0/8

$agw = Get-AzureRmApplicationGateway -Name MYGATEWAY -ResourceGroupName MYRESOURCEGROUP
Remove-AzureRmApplicationGatewaySslCertificate -Name CERTIFICATE-NAME-AS-WRITTEN-ON-THE-RESOURCE -ApplicationGateway $agw
Add-AzureRmApplicationGatewaySslCertificate -Name ANY-NAME -CertificateFile C:\CERTIFICATE.PFX -ApplicationGateway $agw
Set-AzureRmApplicationGateway -ApplicationGateway $agw

#WAIT 15 min

Given a list of windows services

Start each of them
Configure each of them to start automatically, but with a delay
On failure, restart the service

$services = ("OctopusDeploy Tentacle","seq","tcagent","mailhog","freeFTPdService")
foreach ($service in $services){
 Start-Service -Name $Service

	# Credits to https://stackoverflow.com/questions/3487265/powershell-script-to-return-versions-of-net-framework-on-a-machine

	# Get the text from github
	$url = "https://raw.githubusercontent.com/dotnet/docs/master/docs/framework/migration-guide/how-to-determine-which-versions-are-installed.md"
	$md = Invoke-WebRequest $url -UseBasicParsing

	# Replace the weird text in the tables, and the padding
	# Then trim the \| off the front and end of lines
	$map = $md -split "`n" -replace " installed [^\|]+" -replace "\s+\\|" -replace "\\|$" \|

	{
	"$schema":"https://schema.management.azure.com/schemas/2015-01-01/deploymentTemplate.json#",
	"contentVersion":"1.0.0.0",
	"parameters":{
	"certificateName":{
	"type":"string",
	"metadata":{
	"description":"User friendly certificate resource name"
	}
	},