1 Reply Latest reply: May 15, 2014 10:03 AM by Grant Perkins RSS

    MS Proxy Server Log Files

    MattS _

      Does anyone have a working monarch model they use for MS Proxy Server log files that are comma separated?

       

      below is a sample...

      xx.xxx.xxx.xx and xxx.xxx.xxx.xxx are IP addresses

      XXX\XXXX is domain\user name

       

      -, -, -, N, 12/1/2008, 0:21:56, 1, -, -, gfx2.hotmail.com, -, 80, -, 1657, 93, http, -, -, http://gfx2.hotmail.com/mail/w3/ltr/CPGradientThemed.png[/url], -, Inet, 10004, 0

      xx.xxx.xxx.xx, XXX\xxxxx, -, Y, 12/1/2008, 2:08:38, 1, -, -, tk2.stc.s-msn.com, -, 80, 200, 6179, 608, http, -, -, http://tk2.stc.s-msn.com/br/hp/11/en-us/css/ie_6.css[/url], -, Inet, 200, 27262981

      207.130.120.102, XXX\xxxxxxxx, -, Y, 12/1/2008, 6:21:30, 1, -, -, update.nai.com, -, 80, 60, 3566, 358, http, -, -, http://update.nai.com/products/commonupdater/catalog.z[/url], -, Inet, 200, 8388613

      xxx.xxx.xxx.xxx, XXX\xxx, -, Y, 12/1/2008, 7:49:06, 1, -, -, update.nai.com, -, 80, 30, 393, 852, http, -, -, http://update.nai.com/products/commonupdater/SiteStat.xml[/url], -, Inet, 200, 8388613

      xxx.xxx.xxx.xxx, XXX\xxxxxxxx, -, Y, 12/1/2008, 7:49:06, 1, -, -, update.nai.com, -, 80, 10, 3286, 358, http, -, -, http://update.nai.com/products/commonupdater/catalog.z[/url], -, Inet, 200, 8388613

       

      for the export i really only care about IP, user name, date, time and the full website URL

        • MS Proxy Server Log Files
          Grant Perkins

          MattS,

           

          If you have V9 PRO you can open the csv file as a DATABASE and then select the columns (fields) you want.

           

          If you have V9 Standard there should be other options available.

           

          Since the output seems to be consistently columnar one of the options may be to select the entire line as a single field and then slice and dice it using a SPLIT() function - probably LSPLIT - splitting on commas.

           

          If a single line might exceed 4000 characters other issues will likely come into play ...

           

           

          Does this help at all?

           

           

          Grant

           

          PS: Apologies - I should have also said - Welcome to the forum!