AWS Boto3 ec2 inventory script

Question

Hi ,

I am trying to write a code in boto3 to get all ec2 inventory information with tags assigned to particular resources and output it to a csv file.

I want all the tags assigned to a resource to come in the same line with the resource information in csv file,but for every new tag value it is getting printed on the next line.

 any help will be much appreciated.

Thanks,

Aman

Answer 1

Hi@khyatl,

You need to remove the newline character. Like in print function by default newline character is added.

Comments

How to remove that?

---

Can you share your script?

---

import boto3
import csv
aws_mang_con=boto3.session.Session(profile_name='root')
ec2_cli=aws_mang_con.client('ec2')
cnt=1
csv_ob=open("demo.csv","w",newline='')
csv_w=csv.writer(csv_ob)
csv_w.writerow(["S_NO","Instance_Id",'Instance_Type','PrivateIpAddress','Accountid','Name','Application'])
response=ec2_cli.describe_instances()['Reservations']
for each_item in response:
    for instances in each_item['Instances']:
        for tags in instances['Tags']:
                csv_w.writerow([cnt,instances['InstanceId'],instances['InstanceType'],instances['PrivateIpAddress'],each_item['OwnerId'],tags['Value']])
                cnt+=1
csv_ob.close()

Above is the script.

---

Added to the script i am getting output like 

S_NO	Instance_Id	Instance_Type	PrivateIpAddress	Accountid	Name
1	i-0bf174186c4ab9302	t2.micro	172.31.86.32	2.9E+10	python-linux
2	i-0bf174186c4ab9302	t2.micro	172.31.86.32	2.9E+10	Cloudera
3	i-0b9c9a64f048a2022	t2.micro	172.31.93.49	2.9E+10	linux
4	i-0b9c9a64f048a2022	t2.micro	172.31.93.49	2.9E+10	DISCOVERY

 

But i need information like this

1	i-0bf174186c4ab9302	t2.micro	172.31.86.32	2.9E+10	python-linux	Cloudera
2	i-0b9c9a64f048a2022	t2.micro	172.31.93.49	2.9E+10	linux	DISCOVERY

I need all tags information associated with the instance id in the same line it is coming on the different line for every new tag creating more number of information.

---

In your open function remove newline keyword and try once.