-
Posted to
General Discussion
by
yellowdog.dave
on
12-03-2008, 4:47 AM
Hi,
I presume that you want to get the entries for the same day as you want the filename to be which, in your instance, is derived from your system date.
LogParser "SELECT TimeGenerated, SourceName,EventCategoryName, EventID, EXTRACT_TOKEN(strings, 0, '|') AS Comptes, Message INTO D:\logs\%mydate%.txt FROM Security WHERE ...
-
Posted to
General Discussion
by
yellowdog.dave
on
12-01-2008, 6:13 AM
Hi,
See if any of the suggestions here http://forums.iis.net/p/1146050/1851262.aspx help.
Good luck.
Cheers, Dave
-
Posted to
Input Formats
by
yellowdog.dave
on
11-24-2008, 4:59 AM
Hi,
You are probably not coming right because your file name has spaces in it. To remedy this you can either run the command in the directory that you want to analyse and not specify the full path, use 8.3 filename notation, or you can put single quotation marks around the file name as follows;
logparser "select * from 'C:\Documents ...
-
Posted to
General Discussion
by
yellowdog.dave
on
11-05-2008, 1:09 AM
Hi Maq,
You really should start familiarising yourself with the application by reading the compiled help file in the install directory. The examples in there should easily help you solve this, as well as numerous other posts on this site.
Anyhow, here is an example specific to your request;
logparser "select Date, cs-uri-stem, count(*) ...
-
Posted to
General Discussion
by
yellowdog.dave
on
11-04-2008, 4:53 AM
Hi Martin,
I have made it a little more generic for you to process wildcards directly. I don't know how au fait you are with batch files, so I have paraphrased what each line is doing.
I trust that this helps.
Cheers, Dave
1. Set echo off so that commands are not echoed back to the screen
2. Get to the drive from where we our batch ...
-
Posted to
General Discussion
by
yellowdog.dave
on
11-03-2008, 7:58 AM
Hi Martin,
Had this problem and you may want to use this little workaround I did. I presume that you are scheduling your queries via a batch file or something similar. What I do is put in a simple check to see if the file has incremented in size since last run - if not, just exit - sample below.
This is not foolproof, as if your file grew ...
-
Posted to
Advanced Topics
by
yellowdog.dave
on
10-28-2008, 5:05 AM
Hey Kewl,
This is a similar request to one that I posted an answer to here http://forums.iis.net/t/1152561.aspx
Below is a batch file that will achieve what you requested by creating a csv output file called Concurrency.csv in the working directory.
Create the batch file in a new directory - I must warn you that it cleans up all ...
-
Posted to
General Discussion
by
yellowdog.dave
on
10-24-2008, 3:02 AM
Hi Dave,
Something like this would be useful for obvious reasons, one does not know what one does not know, and we need to start somewhere.
There are the jump-out-and-bite-you logs that are typically supported by default in LP, but I did find this list quite useful - it is pertinent specifically to Small Business Server, but the ...
-
Posted to
General Discussion
by
yellowdog.dave
on
10-23-2008, 8:01 AM
Hi Tom,
What you seem to be trying to do here is create a kind of pivot table/matrix report of the response times - to my knowledge this is not done in a simple single query. I have written a little batch file for you that will achieve what you have described here - it is pasted below.
Take the following and paste it into a batch file and ...
-
Posted to
Input Formats
by
yellowdog.dave
on
10-22-2008, 6:05 AM
Hi Brink
Then you may want to just do the replace_str I described in my previous post as a pre-process and then take that as input to another logparser.
Cheers, Dave