Extracting data from xml format in python

Question

I have the following nmap output as xml format:

<ports><extraports state="closed" count="991">
<extrareasons reason="conn-refused" count="991"/>
</extraports>
<port protocol="tcp" portid="22"><state state="open" reason="syn-ack" reason_ttl="0"/><service name="ssh" method="table" conf="3"/></port>
<port protocol="tcp" portid="25"><state state="open" reason="syn-ack" reason_ttl="0"/><service name="smtp" method="table" conf="3"/></port>
<port protocol="tcp" portid="139"><state state="open" reason="syn-ack" reason_ttl="0"/><service name="netbios-ssn" method="table" conf="3"/></port>
<port protocol="tcp" portid="443"><state state="open" reason="syn-ack" reason_ttl="0"/><service name="https" method="table" conf="3"/></port>

I want to get port numbers that are open:

print 'Port Number: '+host.find('ports').find('port').get('portid')

But the result is just 22.

How can I have the results:

falsetru · Accepted Answer · 2014-12-15 15:52:45Z

1

Find all port elements, and get portid attributes.

Using Element.findall and list comprehension:

>>> import xml.etree.ElementTree as ET
>>> root = ET.fromstring('''
<ports><extraports state="closed" count="991">
<extrareasons reason="conn-refused" count="991"/>
</extraports>
<port protocol="tcp" portid="22"><state state="open" reason="syn-ack" reason_ttl="0"/><service name="ssh" method="table" conf="3"/></port>
<port protocol="tcp" portid="25"><state state="open" reason="syn-ack" reason_ttl="0"/><service name="smtp" method="table" conf="3"/></port>
<port protocol="tcp" portid="139"><state state="open" reason="syn-ack" reason_ttl="0"/><service name="netbios-ssn" method="table" conf="3"/></port>
<port protocol="tcp" portid="443"><state state="open" reason="syn-ack" reason_ttl="0"/><service name="https" method="table" conf="3"/></port>
</ports>
''')
>>> [port.get('portid') for port in root.findall('.//port')]
['22', '25', '139', '443']

answered Dec 15, 2014 at 15:52

falsetru

371k69 gold badges769 silver badges659 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

falsetru Over a year ago

@MortezaLSC, Iterate the port elements: for port in root.findall('.//port'): print('port: {}'.format(port.get('portid')))

MLSC Over a year ago

I am really sorry...but I do state=[port.get('state') for state in root.findall('.//port')] for checking states and then it doesn't return me open and say none

falsetru Over a year ago

@MortezaLSC, state attribute is not an attribute of port element, but an attribute of state. You need to use this: [port.get('state') for port in root.findall('.//port/state')]

Collectives™ on Stack Overflow

Extracting data from xml format in python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related