Generating spreadsheet of Sous manifests + owners

query.jq

[
	.[]
	|
		select(
			.NumInstances != 0
			and ( .SourceID.Location | startswith("github.com/sous") | not )
			and ( .SourceID.Location | contains("hack") | not )
			and ( .SourceID.Location | contains("demo") | not )
			and ( .SourceID.Location | contains("sous") | not )
		)
	|
		{
			source: .SourceID.Location,
			owners: .Owners | keys | sort | join("|"),
		}
]

| unique


| .[] | "\(.source)|\(.owners)"

script.sh

sous query gdm -format=json | tee gdm.json
jq -s -f query.jq < gdm.json | jq -r '.' | sed $'s/|/\t/g' > manifests.tsv
pbcopy < manifests.tsv # now paste into Google Sheets