LogParser 2.1 question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: zip (zip_at_zipzak!.com)
Date: 04/20/04 

Date: Tue, 20 Apr 2004 17:57:20 -0400

Hi folks -
Question about logparser 2.1 (this is the closest newsgroup that I could
find)

I am using it to get monthly bandwidth from IIS, using this query:

logparser "Select SUM(sc-bytes) AS TotalBytes FROM
D:\logfiles\w3\W3SVC186\ex0404*.log TO W3SVC186" -i:W3C -o:SQL -server:[sql
server] -driver:"SQL
Server" -database:billing -username:[username] -password:[password] -createt
able:ON

I am running the above for all sites, w3svcx - xxx for instance. In SQL, it
will create a new table for each of the w3svc#'s, which I understand is by
design with this query. Is there anyway to nest all the results of these in
to one table, and have coloumns for the w3svc#'s? So after all those are
run, there would be one table called 'serverx', and in that table all the
above data.

Any help is appreciated! 

-- 
-Streicher

Relevant Pages

  • Re: IIS performance problem and SQLXML.
    ... > using IIS and SQLXML. ... > This server has only this application. ... > The template has this query: ...
    (microsoft.public.sqlserver.xml)
  • Re: Capturing interactive logons from Security Event Log
    ... -Paul Randall ... The problem is that LogParser doesn't resolve the SID in the ... Our security logs are large and processing that query is time consuming. ...
    (microsoft.public.scripting.vbscript)
  • Re: Logparser 2.1 challenge
    ... >>and IMO you should modify your query to let logparser do the work. ... >Take a look at the help file of the iis6.0 reskit tools. ...
    (microsoft.public.win2000.cmdprompt.admin)
  • Re: Logparser 2.1 challenge
    ... >and IMO you should modify your query to let logparser do the work. ... Take a look at the help file of the iis6.0 reskit tools. ...
    (microsoft.public.win2000.cmdprompt.admin)
  • Seeking syntax help with Microsoft logParser
    ... I am trying to query some Exchange 2007 logs using Microsoft ... I cannot query for any field that has a dash character "-" ... The closest match for input format 'W3C' is 'date-time,client-ip,client-hostname ... LogParser -h -i:W3C ...
    (Security-Basics)