#Prisma Cloud CSV account checker
Version: 1.0 Author: Marc Hobson
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: 012345678901, 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.
Input:
Id |
---|
01234 |
Output:
Id | InPCS |
---|---|
01234 | yes |
56789 | no |
-
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
-
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/
python main.py