John Bevan JohnLBevan

## DBTest.java

import com.microsoft.sqlserver.jdbc.*;
import java.sql.*;

public class DBTest {

    public static void main(String[] args) {
        if (args.length != 1) {
            System.out.println("Please provide a connection string as an argument when calling this method; exactly 1 argument expected; received: " + args.length);
            return;

## Get-MostRecentIISLogDate.ps1
Function Import-IISLog {
    [CmdletBinding()]
    Param (
        [Parameter(Mandatory, ValueFromPipeline)]
        [System.IO.FileInfo]$Path
        ,
        [Parameter()]
        [Microsoft.PowerShell.Commands.FileSystemCmdletProviderEncoding]$Encoding = [Microsoft.PowerShell.Commands.FileSystemCmdletProviderEncoding]::Ascii
    )
    Begin {

## Validate local user's credentials
$username = 'username'
$password = 'password'
$computer = $env:COMPUTERNAME
Add-Type -AssemblyName 'System.DirectoryServices.AccountManagement'
$obj = [System.DirectoryServices.AccountManagement.PrincipalContext]::new('machine',$computer)
$obj.ValidateCredentials("$computer\$username", $password)

## WebDavClient.linq
void Main()
{
    var usr = @"myDomain\myUser";
    var pwd = Util.GetPassword(usr); //linqpad util library
    var uri = "https://webdavendpoint.example.com/somefolder/";
    var fn = @"c:\temp\filetouploadTestData.txt";
    var rn = "remoteFilenameTestData.txt";
    var wd = new BasicWebDavClient(usr, pwd, uri);

    wd.Put(fn, rn);

## PrtgSmtpsCertificateScan.ps1
Param(
    [Parameter(Mandatory = $true)]
    [string]$ComputerName
    ,
    [Parameter()]
    [int]$Port = 25
    ,
    [Parameter()]
    [System.Security.Authentication.SslProtocols]$SslProtocols = [System.Security.Authentication.SslProtocols]::GetValues([System.Security.Authentication.SslProtocols])
    ,

## GetOwernship.bat
:: Recursively take ownership of all files under a folder, and amend their access to grant full ownership to admins.

takeown /R /A /D Y /F c:\temp\path
:: /R = Recursive
:: /A = Ownership to Admins
:: /D Y = answer Yes to any questions (/D N would answer No)
:: /F c:\temp\path = which path to run the command against

icacls c:\temp\path /grant Administrators:F /T /C
:: c:\temp\path The path to run the command against

## Export-X509CertToPemFiles.ps1
Function Export-X509CertToPemFiles {
	[CmdletBinding()]
	Param (
		[Parameter(Mandatory = $true)]
		[System.Security.Cryptography.X509Certificates.X509Certificate2]$Certificate
		,
		[Parameter(Mandatory = $true)]
		[System.IO.FileInfo]$FullChainPath
		,
		[Parameter(Mandatory = $true)]

## Kusto: Find all Azure App Gateway Listeners & HostNames
(
    resourcecontainers
    | where type =~ 'microsoft.resources/subscriptions'
    | project SubscriptionName=name, subscriptionId
) | join kind = inner
(
    resources
    | where type =~ 'microsoft.network/applicationgateways'
    | project subscriptionId, AppGateway=name, httpListeners = properties['httpListeners']
) on subscriptionId

## rainbow.html
<!DOCTYPE html>
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
  <title>Google Demo</title>
  <style type="text/css" media="screen">
.rainbow-text {
  background-image: linear-gradient(to right, red, orange, yellow, green, blue, indigo, violet);
  -webkit-background-clip: text;
  -webkit-text-fill-color: transparent;

## Get-HttpUrlRedirects.ps1
function Get-HttpUrlRedirects {
	[CmdletBinding()]
	Param (
		[Parameter(Mandatory)]
		[ValidateNotNullOrEmpty()]
		[string]$Url
		,
		[Parameter()]
		[AllowNull()]
		[AllowEmptyString()]

	import com.microsoft.sqlserver.jdbc.*;
	import java.sql.*;

	public class DBTest {

	public static void main(String[] args) {
	if (args.length != 1) {
	System.out.println("Please provide a connection string as an argument when calling this method; exactly 1 argument expected; received: " + args.length);
	return;
	Function Import-IISLog {
	[CmdletBinding()]
	Param (
	[Parameter(Mandatory, ValueFromPipeline)]
	[System.IO.FileInfo]$Path
	,
	[Parameter()]
	[Microsoft.PowerShell.Commands.FileSystemCmdletProviderEncoding]$Encoding = [Microsoft.PowerShell.Commands.FileSystemCmdletProviderEncoding]::Ascii
	)
	Begin {
	$username = 'username'
	$password = 'password'
	$computer = $env:COMPUTERNAME
	Add-Type -AssemblyName 'System.DirectoryServices.AccountManagement'
	$obj = [System.DirectoryServices.AccountManagement.PrincipalContext]::new('machine',$computer)
	$obj.ValidateCredentials("$computer\$username", $password)
	void Main()
	{
	var usr = @"myDomain\myUser";
	var pwd = Util.GetPassword(usr); //linqpad util library
	var uri = "https://webdavendpoint.example.com/somefolder/";
	var fn = @"c:\temp\filetouploadTestData.txt";
	var rn = "remoteFilenameTestData.txt";
	var wd = new BasicWebDavClient(usr, pwd, uri);

	wd.Put(fn, rn);
	Param(
	[Parameter(Mandatory = $true)]
	[string]$ComputerName
	,
	[Parameter()]
	[int]$Port = 25
	,
	[Parameter()]
	[System.Security.Authentication.SslProtocols]$SslProtocols = [System.Security.Authentication.SslProtocols]::GetValues([System.Security.Authentication.SslProtocols])
	,
	:: Recursively take ownership of all files under a folder, and amend their access to grant full ownership to admins.

	takeown /R /A /D Y /F c:\temp\path
	:: /R = Recursive
	:: /A = Ownership to Admins
	:: /D Y = answer Yes to any questions (/D N would answer No)
	:: /F c:\temp\path = which path to run the command against

	icacls c:\temp\path /grant Administrators:F /T /C
	:: c:\temp\path The path to run the command against
	Function Export-X509CertToPemFiles {
	[CmdletBinding()]
	Param (
	[Parameter(Mandatory = $true)]
	[System.Security.Cryptography.X509Certificates.X509Certificate2]$Certificate
	,
	[Parameter(Mandatory = $true)]
	[System.IO.FileInfo]$FullChainPath
	,
	[Parameter(Mandatory = $true)]
	(
	resourcecontainers
	\| where type =~ 'microsoft.resources/subscriptions'
	\| project SubscriptionName=name, subscriptionId
	) \| join kind = inner
	(
	resources
	\| where type =~ 'microsoft.network/applicationgateways'
	\| project subscriptionId, AppGateway=name, httpListeners = properties['httpListeners']
	) on subscriptionId
	<!DOCTYPE html>
	<html>
	<head>
	<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
	<title>Google Demo</title>
	<style type="text/css" media="screen">
	.rainbow-text {
	background-image: linear-gradient(to right, red, orange, yellow, green, blue, indigo, violet);
	-webkit-background-clip: text;
	-webkit-text-fill-color: transparent;
	function Get-HttpUrlRedirects {
	[CmdletBinding()]
	Param (
	[Parameter(Mandatory)]
	[ValidateNotNullOrEmpty()]
	[string]$Url
	,
	[Parameter()]
	[AllowNull()]
	[AllowEmptyString()]