Skip to content

Instantly share code, notes, and snippets.


Almero Steyn puttyq

  • South Africa
View GitHub Profile
puttyq / Tester - Service Status.ps1
Created Nov 18, 2021
Multi-Domain Service Enumerator
View Tester - Service Status.ps1
Tester - Service Status.ps1 - Tester to check the status of all PCNSSVC services on all current domain context DCs.
The scripts will look for all current domain context DC and query the status of the PCNSSVC service.
Possible status messages include:
- running
- stopped
- starting
- unreachable (the server is not avaiable on the network)
puttyq / Resolve-DNS.ps1
Created Jan 24, 2020
PowerShell - Quick Domain Resolution (Resolve-DNSName)
View Resolve-DNS.ps1
$getdns = Get-Content .\dns.txt
$getdns | foreach {Resolve-DnsName -Type NS $_ | Where-Object -Property Type -EQ "NS" | Select Name, NameHost}
puttyq / ps-github-release-download.ps1
Created Dec 6, 2018
Simple script to download the latest GitHub release MSI file
View ps-github-release-download.ps1
$repo = "xxxx/xxxx"
$file = "xxxxx.msi"
$releases = "$repo/releases"
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
$tag = (Invoke-WebRequest -Uri $releases -UseBasicParsing | ConvertFrom-Json)[0].tag_name
$download = "$repo/releases/download/$tag/$file"
$msi = "$name-$tag.msi"
puttyq / ps-sap-integration-import.ps1
Created Aug 3, 2018
Importing data via New-WebServiceProxy from SAP ES with PowerShell
View ps-sap-integration-import.ps1
# Create function object
$getList = New-Object SAP.BAPI_USER_GETLIST
# Create a return object
# Execute function call
$getList = $proxyUser.BAPI_USER_GETLIST($getList)
puttyq / ps-sap-integration-structure.ps1
Last active Sep 18, 2020
Using New-WebServiceProxy to connect into SAP ES via PowerShell
View ps-sap-integration-structure.ps1
# Proxy variables
$username = "xxxxxxx"
$password = "*******"
$uriUserManagement = "http://servername/sap/bc/srt/wsdl/../../../../zfimconnector_user?sap-client=100"
$uriUserManagementClass = "SAP_WSDL"
$uriUserManagementNamespace = "SAP"
# Create secure credential
$secpasswd = ConvertTo-SecureString $password -AsPlainText -Force
puttyq / ps-import-multiple-dynamic-csv-files-to-sqlserver.ps1
Created Aug 3, 2018
Dynamic CSV file importer (many CSV's) to SQL Server
View ps-import-multiple-dynamic-csv-files-to-sqlserver.ps1
# database Details
$dbServer = "xxxxxxx"
$dbDatabaseName = "xxxxxxxx"
$dbTable = "xxxxxxxx"
# loading modules
Import-Module SQLPs
puttyq / ps-connect-l2tp-vpn.ps1
Created Aug 3, 2018
Creating and connecting to a Windows built-in L2TP VPN Connection
View ps-connect-l2tp-vpn.ps1
# Get All VPN Connections
# Create VPN Connection to Office L2TP
Add-VpnConnection -Name "Test" `
-ServerAddress "xxxxxxxxxx" `
-TunnelType L2TP `
-L2tpPsk "xxxxxxxxxxxx" `
-EncryptionLevel Optional `
-AuthenticationMethod MsChapv2 `
puttyq / ps-connect-to-sap-es.ps1
Created Aug 2, 2018
Connecting to SAP ES via PowerShell
View ps-connect-to-sap-es.ps1
# SAP proxy variables
$uriUserManagement = "http://sapserver/sap/bc/srt/wsdl/flv_10002A111AD1/bndg_url/sap/bc/srt/rfc/sap/zfimconnector/010/zfimconnector_user/zfimconnector_user?sap-client=010"
$uriUserManagementNamespace = "SAP"
$uriUserManagementClass = "SAP_WSDL"
# Create a secure credential to pass to the WS-Proxy
$secpasswd = ConvertTo-SecureString $password -AsPlainText -Force
$credential = New-Object System.Management.Automation.PSCredential ($username, $secpasswd)
# Create web services proxy object

Keybase proof

I hereby claim:

  • I am puttyq on github.
  • I am puttyq ( on keybase.
  • I have a public key whose fingerprint is A952 74E6 207E 1BB5 424B 412D 1DEE C67C DD10 FE59

To claim this, I am signing this object: