Compliance Custom Scripts

One-off scripts for wrangling the control-benchmark JSON behind compliance plugins — no write-up per script, just the files themselves.

Script Purpose
cm_extract_unique_plugins.py Dedupes Plugin Names across the AWS/Azure/Google/Oracle control-benchmark files (first occurrence wins) into unique_plugins.json.
extract_unique_plugin.py Extracts unique Plugin Name + Description pairs from aws_offline_data.json.
extract_control_names.py Extracts all unique ISO 27001:2022 control names from the AWS offline data JSON.
extract_plugin_more_info.py Pulls Plugin Name + more_info out of azure_offline_data_enriched.json into a new JSON file.
enrich_more_info.py Enriches azure_offline_data.json with more_info from gcp_plugin_info_only.json, matched by Plugin Name.
enrich.py Copies fields (Description, Recommended Action, …) from oracle_offline_data.json into soc.json by matching key.
extract.py Converts an XLSX control-benchmark sheet (default: ISO 27001:2022) to JSON.
convert_json_to_csv.py Converts a JSON file to CSV.
convert_csv_to_xlsx.py Converts a CSV file to XLSX.
google_sheet.js Apps Script bound to a Google Sheet — exports its rows to JSON and saves them to Drive.

Back to top

© 2026 Ayush Aggarwal. Notes are living documents — they change as I learn, update, and reorganize them.