I have been an auditor for years, starting with operational/financial audits and quickly transitioning to technology audits early in my career.
While performing technology audits, attestations, etc., you will find that it requires a lot of manual effort if you don’t use the right tools to automate as much as possible.
This repository serves as my personal collection of audit tools that I want to save and re-use later.
While I created the scripts and tools within this repository specifically for the applications I use, I am working to include edge-cases and niche tools as I can.
For now, refer to the tree below for application coverage.
tree -I ".git*|venv".
├── applications
│ ├── github
│ │ ├── github_admins.py
│ │ ├── github_audit_log.py
│ │ ├── github_branch_protections.py
│ │ ├── github_commits.py
│ │ └── README.org
│ └── gitlab
│ ├── approvals.py
│ ├── branch_protections.py
│ ├── passwords.py
│ ├── pipelines.py
│ ├── provisioning.py
│ ├── README.org
│ ├── repositories.py
│ └── users.py
├── CODEOWNERS
├── databases
│ ├── mongo
│ │ ├── admins.py
│ │ └── README.org
│ ├── mysql
│ │ ├── mysql_admins_alt.sql
│ │ ├── mysql_admins.sql
│ │ ├── passwords.sql
│ │ └── README.org
│ ├── oracle
│ │ ├── oracle_admins_alt.sql
│ │ ├── oracle_admins.sql
│ │ └── README.org
│ ├── postgres
│ │ ├── admins.sql
│ │ ├── passwords.sql
│ │ └── README.org
│ └── sql
│ ├── admins.sql
│ ├── passwords
│ │ ├── example_data.csv
│ │ ├── passwords.py
│ │ └── query.sql
│ └── README.org
├── LICENSE
├── os
│ └── linux
│ ├── passwords.sh
│ ├── README.org
│ └── ssh_root_login.sh
├── project_management
│ ├── alteryx
│ │ └── project_email_reminders.yxmd
│ ├── dash
│ │ └── app.py
│ └── powerbi
│ └── project_dashboard
│ ├── project_dashboard.pbix
│ └── project_data.xlsx
├── README.org
├── requirements.txt
└── sampling
├── README.org
├── sample.html
├── sample-html.png
└── sample.py
For the Python scripts, use the following to activate a virtual environment for consistent packing:
python3 -m venv venv
source ./venv/bin/activate
pip install PACKAGE_NAME
python3 ./PYTHON_SCRIPT.py