Skip to content

Instantly share code, notes, and snippets.

Almero Steyn puttyq

  • South Africa
Block or report user

Report or block puttyq

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
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.