Previous Next

• 05-20-2008, 9:54 AM

  kewlapps Joined on 12-20-2007, 9:40 AM Posts 17 kewlapps

  Response Time count - Format output Reply Contact Hi, I am in need of a report in the below format which can give me the count of web pages with response time (RT) split into the buckets. Following is a sample format for your reference Date                 1s         5s         10s       20s       40s       Other --------------------------------------------------------------------------------------------- 2008-05-01     100      40        5          2          0          3 2008-05-02     100      10        1          1          0          2 2008-05-03     100      64        2          2          0          1 2008-05-04     100      25        3          0          0          0          2008-05-05     100      11        1          0          1          3   where  1s is  RT < 1 sec  5s is  1 sec < RT < 5sec 10s is  5 sec < RT < 10sec 20s is 10 sec < RT < 20sec 40s is 20 sec < RT < 40sec Other is > 40 sec Appreciate any help in this regard Cheers,

• 05-25-2008, 12:35 PM

  In reply to

  Christian Paparelli Joined on 07-01-2006, 2:58 PM Switerland Posts 87 Christian Paparelli	Re: Response Time count - Format output Reply Contact follow this document http://technet.microsoft.com/en-us/magazine/cc160953.aspx Christian Paparelli [Microsoft MVP Window Server - IIS] http://mvp.support.microsoft.com http://italy.mvps.org My job: http://www.ithost.ch My blog: http://blogs.aspitalia.com/cp
  	Tags: logparser pivot

• 05-25-2008, 1:52 PM

  In reply to

  Christian Paparelli Joined on 07-01-2006, 2:58 PM Switerland Posts 87 Christian Paparelli

  Re: Response Time count - Format output Reply Contact there is the complete solution SELECT  date,  SUM(_1) AS 1s,  SUB(SUM(_5),SUM(_1)) AS 5s,  SUB(SUM(_10),SUM(_5)) AS 10s,  SUB(SUM(_20),SUM(_10)) AS 20s,  SUB(SUM(_40),SUM(_20)) AS 40s,  SUB(SUM(_Other),SUM(_40)) AS Other USING  CASE quantize(time-taken,1000) WHEN 0 THEN 1 ELSE 0 END AS _1,  CASE quantize(time-taken,5000) WHEN 0 THEN 1 ELSE 0 END AS _5,  CASE quantize(time-taken,10000) WHEN 0 THEN 1 ELSE 0 END AS _10,  CASE quantize(time-taken,20000) WHEN 0 THEN 1 ELSE 0 END AS _20,  CASE quantize(time-taken,40000) WHEN 0 THEN 1 ELSE 0 END AS _40,  1 AS _Other FROM  EX*.LOG GROUP BY  date     Christian Paparelli [Microsoft MVP Window Server - IIS] http://mvp.support.microsoft.com http://italy.mvps.org My job: http://www.ithost.ch My blog: http://blogs.aspitalia.com/cp

• 05-26-2008, 10:58 AM

  In reply to

  kewlapps Joined on 12-20-2007, 9:40 AM Posts 17 kewlapps	Re: Response Time count - Format output Reply Contact Tried the Technet article for status code and based I wanted to format the RT also. Did not realize  that quantize can be used for time-taken. Thanks much this is what I was looking for. The potential of LogParser is mind boggling and is limited only by creativity.