Search results matching tag 'TPL output target'

Re: Template file output not written when 0 elements output

jose_gisbert — Fri, 15 Feb 2008 12:15:15 GMT

i solve this problem with something like this in .bat file:

Rem *** Example

logparser "select * into xxx.html from ... " -i:.. -otpl -tpl:...

if not exist xxx.html copy xxx2.html xxx.html

rem *** End example

where xxx2.html is an static html page with the legend "No Data Found"

Enjoy!

RE: elements output

LogParser User : allenbi — Sat, 27 Jan 2007 04:49:00 GMT

[QUOTE User="LogParser User : allenbi"]Quote: Well, you could produce a dummy file with all of the possible event numbers in, then report on the dummy file and your main file together. As far as putting the date in the filename, thats easy, use...[/QUOTE]
I am trying to get the current system date or time into my LogParser output file name. Here is the query I am trying:

C:\PROGRA~1\LOGPAR~1.2>logparser -i:TSV -iSeparator:spaces "SELECT system_time()
, field1 AS %Utilization INTO *chart.gif FROM xfrsGLOBAL.asc" -headerRow:off -ch
artType:Column3d -chartTitle:"Global CPU Utilization"

Here is the error I am getting in addition to the file name not being created like I want:

Task completed with errors.
Unexpected internal error calling chart object method ExportPicture:
Exception occurred.

Where am I going wrong. Does anyone have an example of how to do this correctly?

RE: Error: detected extra argument helpppppppp

LogParser User : DEinspanjer — Wed, 01 Nov 2006 12:02:00 GMT

The problem with using DATE and TIME directly is that they aren't truly environment variables. they are special variables that are handled by the command interpreter (cmd.exe) directly. So when LP requests them from the environment, they don't exist.

RE: Error: detected extra argument helpppppppp

LogParser User : Allan Pike — Tue, 31 Oct 2006 20:48:00 GMT

I added "set DateTime=%DATE% %TIME%" to the batch file that kicks everything off and used the %DateTime% variable in my .TPL file and it worked ! Thanks heaps guys It's just strange that I couldn't use %DATE% and %TIME% in my .TPL file.

BTW: running Logparser 2.2.10 on Windows 2000 Server SP4

RE: Error: detected extra argument helpppppppp

LogParser User : DEinspanjer — Tue, 31 Oct 2006 10:59:00 GMT

Using %DateTime% in your template should certainly work. Is there any chance you aren't using the latest version of Log Parser (2.2.10)?

RE: Error: detected extra argument helpppppppp

LogParser User : Allan Pike — Mon, 30 Oct 2006 20:55:00 GMT

Yes, am running from a batch file - this is it:

logparser.exe file:Tat.sql -o:TPL -tpl:EventMonitor.tpl -direction:BW

sql file like this:

Select ComputerName,
EventLog,
EventTypeName AS EventType,
EventID,
EventCategory AS Category,
Sourcename,
Message,
TimeGenerated

INTO c:\web\*.html

FROM \\server1\System, \\server1\application

WHERE TimeGenerated >
SUB( TO_lOCALTIME(SYSTEM_TIMESTAMP()),
TIMESTAMP('0000-01-04 00:00:00', 'yyyy-MM-dd hh:mm:ss'))
AND EventTypeName='Error event'

OR TimeGenerated >
SUB( TO_lOCALTIME(SYSTEM_TIMESTAMP()),
TIMESTAMP('0000-01-04 00:00:00', 'yyyy-MM-dd hh:mm:ss'))
AND EventTypeName='Warning event'

ORDER BY TimeGenerated

Jeff - easy enough to do "set DateTime=%DATE% %TIME%" but how do I then add %DateTime% ? All attempts to add user variables to my .TPL file ends up displaying the variable name instead of it's contents in my HMTL file.

RE: Error: detected extra argument helpppppppp

LogParser User : Jeff — Mon, 30 Oct 2006 18:02:00 GMT

Unfortunately, %DATE% and %TIME% aren't actually environment variables, so Logparser can't pick them up. Also, it appears that Log Parser does use UTC time for the %SYSTEM_TIMESTAMP% and there doesn't seem to be a TO_LOCAL() call that would work in the LPHEADER field.

Best bet would be to make the batch file that says something like:

set DateTime=%DATE% %TIME%

logparser -o:tpl ....

and have %DateTime% added.

RE: Error: detected extra argument helpppppppp

LogParser User : DEinspanjer — Mon, 30 Oct 2006 11:10:00 GMT

No, it probably just doesn't pick up those variables since they are special. Are you running LP from a batch file?

RE: Error: detected extra argument helpppppppp

LogParser User : Allan Pike — Sun, 29 Oct 2006 23:57:00 GMT

Thanks for that. I have tried my own variables in the past but the output HTML page showed the variable name and not it's contents. The %DATE% and %TIME% system variables did the same - the output is "Generated 0n %DATE% at %TIME%" which was generated from this part of my .TPL file

<CENTER>
<div style="font-family: Georgia; font-size: 28pt; color: #000000;">
<p>Error & Warning Events from System and Application Log</a></p>
<p class="style1">Generated 0n %DATE% at %TIME%</p>
</div>
</CENTER>
<BR><BR>

Am I doing something wrong ?

RE: Error: detected extra argument helpppppppp

LogParser User : DEinspanjer — Sun, 29 Oct 2006 23:14:00 GMT

Oops. Been a while since someone told me to go read the help file. Yeah, I can see where SYSTEM_TIMESTAMP is in UTC format. So you tried DATE and TIME and they didn't work? They are built in environment variables which the TPL format should support..