Skip to content

Instantly share code, notes, and snippets.

Almero Steyn puttyq

  • South Africa
View GitHub Profile
@puttyq
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 = "https://api.github.com/repos/$repo/releases"
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
$tag = (Invoke-WebRequest -Uri $releases -UseBasicParsing | ConvertFrom-Json)[0].tag_name
$download = "https://github.com/$repo/releases/download/$tag/$file"
$msi = "$name-$tag.msi"
@puttyq
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
$getList.USERLIST = New-Object SAP.BAPIUSNAME
# Execute function call
$getList = $proxyUser.BAPI_USER_GETLIST($getList)
@puttyq
puttyq / ps-sap-integration-structure.ps1
Last active Aug 3, 2018
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
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
cls
# database Details
$dbServer = "xxxxxxx"
$dbDatabaseName = "xxxxxxxx"
$dbTable = "xxxxxxxx"
# loading modules
Import-Module SQLPs
@puttyq
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
Get-VpnConnection
# Create VPN Connection to Office L2TP
Add-VpnConnection -Name "Test" `
-ServerAddress "xxxxxxxxxx" `
-TunnelType L2TP `
-L2tpPsk "xxxxxxxxxxxx" `
-EncryptionLevel Optional `
-AuthenticationMethod MsChapv2 `
@puttyq
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
View keybase.md

Keybase proof

I hereby claim:

  • I am puttyq on github.
  • I am puttyq (https://keybase.io/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:

You can’t perform that action at this time.