Olivier Jacques ojacques

Set of commands which are useful to clean after yourself when I tried to delete AWS Cloud Formation stacks when my infrasec role did not had all the needed permissions.

List stacks which can be deleted (DELETE_FAILED status):

aws cloudformation list-stacks | jq '.StackSummaries[] | select(.StackStatus=="DELETE_FAILED") | .StackName'

OR

List stacks which contain a specific string in their name:

aws cloudformation list-stacks | jq '.StackSummaries[] | select(.StackName | contains("bcol")) | .StackName'

A bot in Microsoft Teams is managed through the Bot Framework.

Navigate to https://dev.botframework.com/bots/new.
Fill in the blanks.
Click on Create Microsoft App ID and password.
Save the AppId and the Password, you will need it later.

Create your hubot bot

Use a Dockerfile to create the bot instance. Create the bot

Getting metrics for a GitHub org

https://github.com/benbalter/count-org-loc

Create .env file

GITHUB_TOKEN="abcdefabcdefabcdefabcdef"
GITHUB_ENTERPRISE_URL="https://github.dxc.com/api/v3"

Update loc.rb to exclude certain types and folders:

Get a collection of opened issues within repositories which have the topic "dojo"

{
  search(query: "topic:dojo", type: REPOSITORY, first: 50) {
    repositoryCount
    pageInfo {
      endCursor
      startCursor
    }
 nodes {

Scenario

Let's say that you have an issue on a given Jenkins agent at a given time, but you don't know which build can cause it. Here is how to find out which builds where running on that agent, at that time.

In this case, the agent is an AWS EC2 VM, with a well known instance ID (in this case, i-02d41abc1a375089d).

This works with Jenkins organization folders.

1. find all builds executed on the agent

This GIST shows example on how to authenticate with HP/HPE/Microfocus ALM REST API and run queries.

Note:

By default, the ALM REST API returns XML data. If you want to get JSON data, add -H "Accept: application/json"

Authenticate with ALM and set the LWSSO_COOKIE_KEY cookie

curl -X POST -H "Content-Type: text/xml" --cookie cookies.txt -k --cookie-jar cookies.txt -d "alm_useralm_password" https://alm_host:8443/qcbin/authentication-point/alm-authenticate

Alternatively (same result):

curl --cookie cookies.txt --cookie-jar cookies.txt --user alm_user:alm_password https://alm_host:8443/qcbin/authentication-point/authenticate

Update iPhone movie files date with EXIF data "MediaCreateDate":

exiftool.exe ExifTool "-FileCreateDate<MediaCreateDate" "-FileModifyDate<MediaCreateDate" *.mov`

	import base64
	import urllib
	#import tlslite
	from tlslite.utils import keyfactory
	import oauth2 as oauth

	class SignatureMethod_RSA_SHA1(oauth.SignatureMethod):
	name = 'RSA-SHA1'

	def signing_base(self, request, consumer, token):

	```Dockerfile
	FROM PYTHON:3.7-buster

	RUN apt-get -qq -y update && \
	DEBIAN_FRONTEND=noninteractive apt-get -qq -y install \
	jq \
	curl \
	less \
	git \
	vim \

	This CLI will convert a PEM private key from a GitHub app, so that it can be used in Jenkins, to eventually be injected in K8s values file

	```
	sed ':a;N;$!ba;s/\n/\\\\\\\\n/g' certificate.private-key.pem
	```