blob: daa71da32e2d682f3033bfa6e74ace1b0603f502 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
|
#+title: README
* Background
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.
** Scope
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.
#+begin_src shell
tree -I ".git*|venv"
#+end_src
#+RESULTS:
├── CODEOWNERS
├── LICENSE
├── README.org
├── applications
│ ├── github
│ │ ├── README.org
│ │ ├── github_admins.py
│ │ ├── github_audit_log.py
│ │ ├── github_branch_protections.py
│ │ └── github_commits.py
│ └── gitlab
│ ├── README.org
│ ├── approvals.py
│ ├── branch_protections.py
│ ├── passwords.py
│ ├── provisioning.py
│ └── users.py
├── databases
│ ├── administrators
│ │ ├── mssql_admins.sql
│ │ ├── mysql_admins.sh
│ │ ├── mysql_admins.sql
│ │ ├── mysql_admins_alt.sql
│ │ ├── oracle_admins.sql
│ │ └── oracle_admins_alt.sql
│ └── passwords
│ └── sql
│ ├── data.csv
│ ├── get_data.sql
│ └── test.py
├── project_management
│ ├── alteryx
│ │ └── project_email_reminders.yxmd
│ ├── dash
│ │ └── app.py
│ └── powerbi
│ └── project_dashboard
│ ├── project_dashboard.pbix
│ └── project_data.xlsx
├── requirements.txt
└── sampling
├── README.org
├── sample-html.png
├── sample.html
└── sample.py
* Development
** Python
For the Python scripts, use the following to activate a virtual environment for
consistent packing:
#+begin_src sh
python3 -m venv venv
source ./venv/bin/activate
pip install PACKAGE_NAME
python3 ./PYTHON_SCRIPT.py
#+end_src
|
