I have a long xml file with many < host id> stanzas. Each one of these stanza has an < ip> value associated and many < vulnerability id> stanzas. Each one of these has a set of 3 values made of < score> < port> < protocol>
this is an extract:
<hosts>
<host id="565558" persistent_id="98487">
<ip>85.205.34.28</ip>
<vulnerabilities>
<vulnerability id="2099" custom="0">
<score>8671</score>
<port>0</port>
<protocol>smb</protocol>
</vulnerability id>
</vulnerabilities>
</host id>
<host id="565560" persistent_id="98485">
<ip>85.205.34.27</ip>
<vulnerabilities>
<vulnerability id="552" custom="0">
<score>8</score>
<port>137</port>
<protocol>udp</protocol>
</vulnerability id>
<vulnerability id="1492" custom="0">
<score>0</score>
<port>139</port>
<protocol>tcp</protocol>
</vulnerability id>
</vulnerabilities>
I would like to create searches that:
1) Give me all vulnerabilities with vulnerability id=552 and port=137 and make a result table with fields ip, vulnerability id, port, score
2) Give me all hosts / ips with existing risks with a score higher than 5000 and make a result table with fields ip,score, vulnerability id, port
How can I achieve this?
... View more