How to Export AWS EC2 details to xlsx/csv using boto3 and python?

Christian Josef Aquino 0
Viewed 38

When running this python code that we've created, it runs but the CSV file output only contains 1 detail but I have 100 instances that are assigned to our account. Can I ask on why this it only output 1 instances to csv when running it?

    import boto3
    import csv

    session = boto3.Session(profile_name="profile-name", 
    region_name="ap-southeast-1")

    ec2_re = session.resource(service_name="ec2")
    ec2_cli = session.client(service_name="ec2")

    # using resource object:

    print("Instances info with resource")
     for each_in in ec2_re.instances.all():
    print(each_in.id, each_in.security_groups, each_in.state['Name'])

    fo=open('ec2_inven_new.csv','w',newline='')
    data_obj=csv.writer(fo)
    data_obj.writerow([each_in.id,each_in.security_groups,each_in.state])

    fo.close()
export-to-csv cloud amazon-ec2 amazon-web-services python
1 Answers

Looks like you are writing multiple times the same file. But could be a issue due to badly indentation in the code you shared.

You can try:

import boto3
import csv
session = boto3.Session(profile_name="profile-name", 
region_name="ap-southeast-1")
ec2_re = session.resource(service_name="ec2")
ec2_cli = session.client(service_name="ec2")
# using resource object:
print("Instances info with resource")

fo = open('ec2_inven_new.csv','w',newline='')
data_obj = csv.writer(fo)
for each_in in ec2_re.instances.all():
    print(each_in.id, each_in.security_groups, each_in.state['Name'])
    data_obj.writerow([each_in.id,each_in.security_groups,each_in.state])

fo.close()
Gonzalo Odiard0
Related