View puml.sh
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
# Mostly this script exists to simply make it possible/simple to do "puml.sh foo.puml" to create "foo.png" from command line. | |
# | |
# If you want it even simpler - "puml foo.puml" (no ".sh" extension) consider using an alias. | |
# Here is example for .bash_profile: | |
# alias puml=~/bin/puml.sh | |
for ARG in "$@" | |
do | |
if [ "$ARG" = "v" ]; then |
View azipcheck.sh
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
if [ $# -eq 1 ]; then | |
IP="$1" | |
## NEED AN AZURE MAP API KEY | |
## Create an Azure Map account in the Azure portal to get a new APIKEY. | |
AZUREMAP_APIKEY='...' | |
## Azure Map API to look up the COUNTRY (two-char ISO) of the IP |
View azure-activity-log-security.json
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!-- | |
Actual activity-log entry, redacted (...) and anonymized. | |
category = "Security" | |
level = "Informational" | |
The threatName and threatID values under properties match this: | |
https://www.microsoft.com/en-us/wdsi/threats/malware-encyclopedia-description?name=Trojan%3AScript%2FConteban.A!ml&threatid=2147735508 | |
--> | |
{ |
View getRandomInt.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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] |
View myip.py
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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() |
View check-azure-sql-db-logins.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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/', |
View ReportBlockedByCSP
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#r "Newtonsoft.Json" | |
using System.Net; | |
using System.Text; | |
using Newtonsoft.Json; | |
using Newtonsoft.Json.Linq; | |
#r "Newtonsoft.Json" | |
using System.Net; |
View run.csx
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#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; |
View IpTools.psm1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 | |
} |
View gitpush.ps1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
git add --all | |
git commit --all -m "Update" | |
git push |
NewerOlder