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 SkipVought 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
0
0
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

f0rg3tfu1
  • Locked
  • Question
PLSQL Package Help
Replies
0
Views
87
f0rg3tfu1
f0rg3tfu1
peac3
  • Locked
  • Question
convert hierarchy structure to parent children pair please... 1
2
Replies
22
Views
280
mikrom
mikrom
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
223
Chris Miller
Chris Miller
Billz66
  • Locked
  • Question
need to udate table entry with number containing a *
Replies
11
Views
115
Chris Miller
Chris Miller
leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
156
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top