Greg Moy gregmoy

gregmoy / gssh

Created August 27, 2019 22:59

EC2 Instance Connect ssh wrapper

	#!/usr/bin/env bash
	#
	# EC2 Instance Connect SSH Wrapper
	#
	# throw this in your path somewhere - /usr/local/bin is fine
	#
	# Author: developer@gregmoy.com

	set -o errexit
	set -o nounset

gregmoy / postgres_queries_and_commands.sql

Created May 7, 2019 19:13 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

gregmoy / README.md

Created February 1, 2018 16:31 — forked from dnozay/_Jenkins+Script+Console.md

jenkins groovy scripts collection.

Simple collection of Groovy scripts to help me maintain some Jenkins systems.

gregmoy / setup-users.groovy

Created January 3, 2018 22:35 — forked from johnbuhay/setup-users.groovy

jenkins init.groovy.d script for configuring users

	import jenkins.*
	import hudson.*
	import com.cloudbees.plugins.credentials.*
	import com.cloudbees.plugins.credentials.common.*
	import com.cloudbees.plugins.credentials.domains.*
	import com.cloudbees.jenkins.plugins.sshcredentials.impl.*
	import hudson.plugins.sshslaves.*;
	import hudson.model.*
	import jenkins.model.*
	import hudson.security.*