We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Tabular XML file from nmap tool

Comments

5 comments

  • Avatar
    Adrian Williams

    An example data flow is attached that converts the supplied XML data into tabular format, selects the required fields from the tabular data and then filters the records where the 'host.address.addrtype' field  contains the value "ip4".

     

     

    Attached files

    nmap_XML_to_Tabular_Data - 8 Sept 2021.lna

     

    0
    Comment actions Permalink
  • Avatar
    Karlis Majevskis

    Hello, Adrian. Thanks for very fast response. The problem in your solution is that ipv4 row does not contain the required data and vice versa, the required port and hostname data does not contain ipv4 value in respective column.

    In the picture below i've opened the ml with excel. The red values are not there when you open the file. I've added manually red values to show that these lines (row 7-18) are applicable to the upper level ipv4 addr (row 5). But in XML, the data in columns addrtype and addr for rows 7-18 is not displayed. It is just the way how XML structure is built.

    I want the report to show me addr, name, portid. Basically filldown the values of row 5 col addrype addre down to row 7-18

    0
    Comment actions Permalink
  • Avatar
    Karlis Majevskis

    Here is an example from Data360

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    The values output in the original tabular data represent the contents of the XML tags. If you want to 'copy down' the values from one record and use them in a subsequent record if the fields are Null then you can use the logic in this updated data flow.

     

     

     

    Attached files

    nmap_XML_to_Tabular_Data_v2 - 9 Sept 2021.lna

     

    0
    Comment actions Permalink
  • Avatar
    Karlis Majevskis

    Thanks, mate. It worked!!!

    0
    Comment actions Permalink

Please sign in to leave a comment.