Endpoint Protection

 View Only
  • 1.  Convert ersecreg-l.log to xml

    Posted May 29, 2015 12:55 PM

    We have a ton of entries in our ersecreg-1.log and extracting IP addresses is cumbersome.

    Any ideas on how to convert the .log file to .xml? I'm googling, but not finding anything substantial.



  • 2.  RE: Convert ersecreg-l.log to xml

    Posted May 29, 2015 12:58 PM

    You can drop this straight into excel as is and filter that way. I had to do this same thing in the past. I assume you're looking for duplicate HWIDs?

    You can also convert a CSV to XML. There are a few free sites out there that will do it.

    http://www.office-converter.com/Convert-to-XML



  • 3.  RE: Convert ersecreg-l.log to xml

    Posted May 29, 2015 01:21 PM

    Brian,

     

     

    I tried the site, it returned gobbly gook. :-(

     

    We're not looking for DUPhwid, but categorizing computers that are unable to check-in.

     

    It seems we'll have to do this for a period of days, so I was looking for simple way to 

    1. convert the file to xml

    2. read the info



  • 4.  RE: Convert ersecreg-l.log to xml
    Best Answer

    Posted May 29, 2015 01:51 PM

    You might be able to pull it off with powershell

    http://coders-corner.net/2013/07/03/powershell-csv-to-xml/



  • 5.  RE: Convert ersecreg-l.log to xml

    Posted May 29, 2015 02:00 PM

    This is good starting point, thanks.



  • 6.  RE: Convert ersecreg-l.log to xml

    Posted May 29, 2015 02:08 PM

    Welcome