It works great !! Thanks a lot... I didn't realize that until i see the post..

rtfm (vbg) -- I only know this cos I got caught too, the backslash is important - <string_constant> Constant values of the STRING type are entered as strings enclosed by single quote characters ( ' ). The single quote character ( ' ) and the backslash character ( \ ) are considered special characters...

Hi all, I am trying to replace the '/' char in the user names with '\'. I am using this CASE statement in select SELECT Time, c-ip, CASE STRCNT(cs-username,'/') WHEN 0 THEN TO_UPPERCASE(cs-username) ELSE TO_UPPERCASE(REPLACE_CHR(cs-username,'/','\')) END AS cs-username, s-sitename, s-computername, s...

Hi There Apologies if i have posted this in the wrong section I am new to the Log Parser tool and have already run into issues. I am trying to run the example queries provided with the standard install, but seem to be doing something wrong. I start log parser and enter and run the following: LogParser...

Note we have a load balance that does health check every 10sec on the site that is creating numerous logs in iis.. I would like to have a command that i can schedule to delete this ip address like c-ip 192.168.17.4 from all the logs in in all the other sites logs automatically just by me scheduling this...

Normally, when someone is asking this question, they are looking for the time the user spent reading one page to the next rather than the time the page took to be transmitted. I agree that for the latter question, it is pretty easy if the field exists in the logs.

Maybe you should enable time-taken, this parameter is available atleast if you run IIS6 and it reports the time it took to execute in miliseconds.

Do you have a sample line or two from an SMTP log?

Is it possible to run a query that returns the Message ID generated by the SMTP server and whether the message was delivered successfully or unsuccessfully?

It isn't a built in format. Whether LP can be adapted to it depends on what the format looks like..