pcs-compare-csv-accounts-to-tenant
#Prisma Cloud CSV account checker
Version: 1.0 Author: Marc Hobson
Summary
This script will ingest a .csv
file with a header named Id
and the following entries in that column being
cloud account ID's; ex. AWS: 0123456
, GCP: project-123, and compare the .csv
to the accounts already onboarded
into a Prisma Cloud tenant. The script will then create a new .csv
with an additional InPCS
header and
mark yes
or no
in that column if it has already been onboarded.
CSV Table example:
Input:
|Id|
|--------|
|01234|
Output:
|Id|InPCS|
|--------|--------|
|01234| yes |
|56789| no |
Requirements and Dependencies
-
Python 3.7 or newer
-
OpenSSL 1.0.2 or newer
(if using on Mac OS, additional items may be nessessary.)
- Pip
sudo easy_install pip
- Requests (Python library)
sudo pip install requests
- YAML (Python library)
sudo pip install pyyaml
Configuration
-
Create CSV file with header
Id
and paste the cloud account ID's below that header in the same column. -
Place the CSV file to be checked in the
/main
directory of this repository after pulling down from GitHub. -
Navigate to
config/configs.yml
-
Fill out your Prisma Cloud access key/secret, stack info, and CSV filename to be scanned.
To determine stack, look at your browser when access console (appX.prismacloud.io, where X is the stack number.
Change this to apiX.prismacloud.io and populate it in the configs.yml.
Or go here for more information: https://api.docs.prismacloud.io/
Run
python main.py