Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

need help with a query please

Status
Not open for further replies.
mst3k

mst3k

IS-IT--Management
Apr 29, 2002
41
US

I am tying to get logparser to work with sending the total of sc-bytes to a sql database, and I am having pretty good luck, but was hoping for some help..

When I run the code below (for each domain) it creates a table called 'w3svc1', I run that command from a batch file, and there are many sites that it does this on, I would much rather have this thing send all the data to the same table, and just have two columns, bandwidth & w3svc#, that way when I export to excel or whatever it's not all individual worksheets.
I am hoping that makes sense :) Here's the code I use:

logparser "Select SUM(sc-bytes) AS TotalBytes FROM D:\logfiles\w3\W3SVC1\ex0312*.log TO W3SVC1" -i:W3C -o:SQL -server:x.x.x.x -driver:"SQL Server" -database:billing -username:billing -password:**** -createtable:ON


Thanks!
 
Status
Not open for further replies.

Similar threads

MathiasB
  • Locked
  • Question
Parameterised sql server query
Replies
8
Views
494
Chriss Miller
C
f0rg3tfu1
  • Locked
  • Question
PLSQL Package Help
Replies
0
Views
581
f0rg3tfu1
f0rg3tfu1
peac3
  • Locked
  • Question
convert hierarchy structure to parent children pair please... 1
2
Replies
22
Views
2K
mikrom
mikrom
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
2K
Chris Miller
Chris Miller
Billz66
  • Locked
  • Question
need to udate table entry with number containing a *
Replies
11
Views
590
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top