Bill Wilder codingoutloud

## getRandomInt.js
// Return a random integer in [0..max] (inclusive, so 0 and max are valid values).
// Assumes (but does not validate) that max is a non-negative integer less than Number.MAX_SAFE_INTEGER.
// Does not use a Cryptographically Secure Pseudo-Random Number Generator (CSPRNG).
function getRandomInt(max) {
  return Math.floor(Math.random() * (max + 1));

  // How it works:
  //       Math.random()            → returns a floating point number at least zero but less than one: [0..1)
  //       Math.random() * (max+1)  → returns a floating point number at least 0 but less than (max+1): [0..max+1)
  // floor(Math.random() * (max+1)) → returns an integer at least 0 but could be as high as max: [0..max]

## myip.py
# OpenDNS resolves "myip.opendns.com" to the caller's publicly-facing IP.
# To use this feature, resolve that DNS name against an OpenDNS name server.

# https://github.com/rthalley/dnspython
# pip install dnspython

import dns.resolver

resolver = dns.resolver.Resolver()

## check-azure-sql-db-logins.sql
-- Turn on Audit Logging to Blob for your Azure SQL Database. Then you can query who has logged in.
-- The example below assumes DB Server-level audit logging. Details will vary slightly for Database-level audit logging.
-- The example below shows who logged in so far today.
-- Change "-0" to "-1" to look at yesterday (from a UTC perspective, not your local timezone).
-- Change "-0" to "-100" to look at 100 days ago.
SELECT FORMATMESSAGE('%s (%s)', CAST(DATEADD(day, -0, CONVERT(date, SYSUTCDATETIME())) as varchar),
                      DATENAME(WEEKDAY, DATEADD(day, -0, SYSUTCDATETIME()))),
       server_principal_name,
       COUNT(server_principal_name) as 'Logins'
FROM sys.fn_get_audit_file(FORMATMESSAGE('https://<MYBLOB>.blob.core.windows.net/sqldbauditlogs/<MYDBSERVER>/<MYDB>/SqlDbAuditing_ServerAudit/%s/',

## ReportBlockedByCSP
#r "Newtonsoft.Json"

using System.Net;
using System.Text;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;

#r "Newtonsoft.Json"

using System.Net;

## run.csx
#r "Newtonsoft.Json"

using System.Net;
using System.Net.Http;
using System.Text;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Primitives;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;

## IpTools.psm1
# put this in some shared module folder, such as /usr/local/share/powershell/Modules
Function Get-IpCountry {
   param([String]$ip="9.9.9.9")

   $country = Invoke-RestMethod -Method GET -Uri https://ipinfo.io/$ip/country
   return $country
}

## gitpush.ps1
git add --all
git commit --all -m "Update"
git push

## Publish-CertFromKeyVaultToWebApp.ps1
Login-AzureRmAccount
Select-AzureRmSubscription -SubscriptionName AzureFAQ # subscription where the Web App resides

$webAppName = "pageofphotos" # Web App resource Name, (Get-AzureRmWebApp)[0].Name
$fqdn = "pageofphotos.com" # what is the DNS address? could be admin.pageofphotos.com if that's what's mapped

$vaultName = "GlobalOpsVault"
$certificateName = "MySSL"

$passwordLength = 50

## AzureFunctionRandomQuote.js
var request = require('request');

module.exports = function (context, req) {
    context.log('JavaScript HTTP trigger function processed a request.');

    var html = "<html><body><h1>didn't work</h1></body></html>"
    var movieApiUrl = 'https://andruxnet-random-famous-quotes.p.mashape.com/?cat=movies&count=10';
    // go get your own API key: https://market.mashape.com/andruxnet/random-famous-quotes#get-endpoint
    var movieApiKey = process.env['MOVIE_API_KEY'];
    // context.log('MOVIE API KEY = ' + movieApiKey);

## http-get-repeatedly.sh
#!/bin/bash

URL="https://prod-24.southcentralus.logic.azure.com:443/workflows/62d71dadbb0b451bb8de9f27c9e51f93/triggers/manual/paths/invoke?api-version=2016-06-01&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=8HpJbLEcF078jtVgBZoMpWA65sZDI8_nowFVINX8HK0"

for i in `seq 1 $1`;
do
    echo $i
    curl "$URL"
done
	// Return a random integer in [0..max] (inclusive, so 0 and max are valid values).
	// Assumes (but does not validate) that max is a non-negative integer less than Number.MAX_SAFE_INTEGER.
	// Does not use a Cryptographically Secure Pseudo-Random Number Generator (CSPRNG).
	function getRandomInt(max) {
	return Math.floor(Math.random() * (max + 1));

	// How it works:
	// Math.random() → returns a floating point number at least zero but less than one: [0..1)
	// Math.random() * (max+1) → returns a floating point number at least 0 but less than (max+1): [0..max+1)
	// floor(Math.random() * (max+1)) → returns an integer at least 0 but could be as high as max: [0..max]
	# OpenDNS resolves "myip.opendns.com" to the caller's publicly-facing IP.
	# To use this feature, resolve that DNS name against an OpenDNS name server.

	# https://github.com/rthalley/dnspython
	# pip install dnspython

	import dns.resolver

	resolver = dns.resolver.Resolver()
	-- Turn on Audit Logging to Blob for your Azure SQL Database. Then you can query who has logged in.
	-- The example below assumes DB Server-level audit logging. Details will vary slightly for Database-level audit logging.
	-- The example below shows who logged in so far today.
	-- Change "-0" to "-1" to look at yesterday (from a UTC perspective, not your local timezone).
	-- Change "-0" to "-100" to look at 100 days ago.
	SELECT FORMATMESSAGE('%s (%s)', CAST(DATEADD(day, -0, CONVERT(date, SYSUTCDATETIME())) as varchar),
	DATENAME(WEEKDAY, DATEADD(day, -0, SYSUTCDATETIME()))),
	server_principal_name,
	COUNT(server_principal_name) as 'Logins'
	FROM sys.fn_get_audit_file(FORMATMESSAGE('https://<MYBLOB>.blob.core.windows.net/sqldbauditlogs/<MYDBSERVER>/<MYDB>/SqlDbAuditing_ServerAudit/%s/',
	#r "Newtonsoft.Json"

	using System.Net;
	using System.Text;
	using Newtonsoft.Json;
	using Newtonsoft.Json.Linq;

	#r "Newtonsoft.Json"

	using System.Net;
	#r "Newtonsoft.Json"

	using System.Net;
	using System.Net.Http;
	using System.Text;
	using Microsoft.AspNetCore.Mvc;
	using Microsoft.Extensions.Primitives;
	using Newtonsoft.Json;
	using Newtonsoft.Json.Linq;
	# put this in some shared module folder, such as /usr/local/share/powershell/Modules
	Function Get-IpCountry {
	param([String]$ip="9.9.9.9")

	$country = Invoke-RestMethod -Method GET -Uri https://ipinfo.io/$ip/country
	return $country
	}
	Login-AzureRmAccount
	Select-AzureRmSubscription -SubscriptionName AzureFAQ # subscription where the Web App resides

	$webAppName = "pageofphotos" # Web App resource Name, (Get-AzureRmWebApp)[0].Name
	$fqdn = "pageofphotos.com" # what is the DNS address? could be admin.pageofphotos.com if that's what's mapped

	$vaultName = "GlobalOpsVault"
	$certificateName = "MySSL"

	$passwordLength = 50
	var request = require('request');

	module.exports = function (context, req) {
	context.log('JavaScript HTTP trigger function processed a request.');

	var html = "<html><body><h1>didn't work</h1></body></html>"
	var movieApiUrl = 'https://andruxnet-random-famous-quotes.p.mashape.com/?cat=movies&count=10';
	// go get your own API key: https://market.mashape.com/andruxnet/random-famous-quotes#get-endpoint
	var movieApiKey = process.env['MOVIE_API_KEY'];
	// context.log('MOVIE API KEY = ' + movieApiKey);
	#!/bin/bash

	URL="https://prod-24.southcentralus.logic.azure.com:443/workflows/62d71dadbb0b451bb8de9f27c9e51f93/triggers/manual/paths/invoke?api-version=2016-06-01&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=8HpJbLEcF078jtVgBZoMpWA65sZDI8_nowFVINX8HK0"

	for i in `seq 1 $1`;
	do
	echo $i
	curl "$URL"
	done