« Previous Next »

Thread: Converting Perfmon csv string time/date input to timestamp

Last post 10-04-2006 3:30 PM by LogParser User : wswenson. 1 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (2 items)

Sort Posts:

  • 08-14-2006, 1:11 PM

    Converting Perfmon csv string time/date input to timestamp

    Page 20 of the Logparser toolkit gives an example of using the -TSFormat:"MM/dd/yyyy hh:mm:ss.ll" string to cause the timestamp to be parsed as (T) for time rather than (S) for string.

    I have applied this example to my perfmon csv file, but the timestamp is still being parsed as a string.  I need to get this data parsed as a timestamp.  Is there something wrong with the example, or is it not possible to use this tool in this way?

    To get the perfmon to CSV, I have opened the file in Perfmon, filtered on the process counters of interest and then saved to csv.  I have attached the csv file to this posting.

  • 10-04-2006, 3:30 PM In reply to

    RE: Converting Perfmon csv string time/date input to timestamp

    -TSFormat:"MM/dd/yyyy hh:mm:ss.lxx" works for me.
Page 1 of 1 (2 items)
Microsoft Communities