Skip to content

Instantly share code, notes, and snippets.

View gustavomcarmo's full-sized avatar

Gustavo Muniz do Carmo gustavomcarmo

View GitHub Profile
@gustavomcarmo
gustavomcarmo / find-latest-ubuntu-bionic-ami.yml
Created December 11, 2018 19:26
Ansible playbook to find the latest Ubuntu 18.04 LTS (bionic) AMI in AWS.
---
- hosts: localhost
gather_facts: no
vars:
aws_region: "eu-west-2"
tasks:
- name: Find Ubuntu Server 18.04 LTS AMIs
ec2_ami_facts:
region: '{{ aws_region }}'
owners: 099720109477
@gustavomcarmo
gustavomcarmo / docker-compose.yml
Last active November 6, 2019 11:56
NGINX + WordPress + MySQL Docker Compose
version: '3'
services:
mysql:
image: mariadb:10.3.12
container_name: mysql
restart: always
volumes:
- mysql_data:/var/lib/mysql
environment:
@gustavomcarmo
gustavomcarmo / jenkins-backup.py
Created July 20, 2022 15:44
Jenkins backup by exporting jobs definitions to XML files.
#!/usr/bin/python3
from datetime import datetime
import logging
import os
import requests
def get_params():
if 'JENKINS_URL' not in os.environ or 'JENKINS_ADMIN_USERNAME' not in os.environ or 'JENKINS_ADMIN_PASSWORD' not in os.environ:
@gustavomcarmo
gustavomcarmo / scan-images.sh
Created February 14, 2023 09:16
Docker images vulnerabilities scan with Snyk based on images stored in Sonatype Nexus as private Docker Registry
#!/bin/bash
log_file=snyk-scan-$(date '+%s%3N').log
export SNYK_TOKEN=$1
private_docker_registry=$2
nexus_repo_url=$3
log() {
printf "$(date '+%F %T') - %s\n" "$1"
}
@gustavomcarmo
gustavomcarmo / databricks-pipeline-maintenance-jobs-clusters.kql
Last active July 3, 2023 20:19
Databricks Pipeline Maintenance Jobs Clusters KQL
let ClustersInitializations = DatabricksClusters
| distinct ActionName, Response, RequestParams, TimeGenerated
| where ActionName in ('create', 'start', 'restart') and TimeGenerated > ago(30d)
| extend ResponseTxt = parse_json(Response)
| where ResponseTxt.statusCode == 200
| extend ResponseResultTxt = parse_json(tostring(ResponseTxt.result))
| extend RequestParamsTxt = parse_json(RequestParams)
| project ClusterId = case(ActionName == 'create', ResponseResultTxt.cluster_id,
ActionName in ('start', 'restart'), RequestParamsTxt.cluster_id, ''),
InitializationTime = TimeGenerated,
@gustavomcarmo
gustavomcarmo / databricks-clusters-vms-used-memory-percentage.kql
Last active July 10, 2023 10:39
Databricks clusters VMs used memory percentage KQL
let VMs = Heartbeat
| where OSType == 'Linux'
and Category != 'Azure Monitor Agent'
and ResourceId != ''
| project Computer, TimeGenerated, ClusterId = substring(Computer, 0, 20), VM = tostring(split(ResourceId, "/")[-1])
| summarize arg_max(TimeGenerated, *) by Computer;
let Clusters = DatabricksClusters
| where ActionName in ('create', 'startResult')
| extend ResponseTxt = parse_json(Response)
| where ResponseTxt.statusCode == 200