Search results matching tag 'XML output target'

Remove "Date_Created" and "Created_By" in XML Output

LogParser User : epoch1176 — Mon, 21 May 2007 14:32:00 GMT

I was searching the forums for this option and came across a previous post dated 4/12/2005 where Gabriele states that a switch to turn this on an off will be added in the next version.

Has this switch been added in recent versions? I've scoured the User Guide and these forums, but have only come across this post:

http://www.logparser.com/instantforum33/shwmessage.aspx?ForumID=19&MessageID=1642

Thanks.

-Tom

RE: get the filename/path from query

LogParser User : DEinspanjer — Fri, 02 Mar 2007 17:06:00 GMT

Yes. look at the documentation for the XML Input Format.
By default, installed to C:\Program Files\Log Parser 2.2\LogParser.chm

get the filename/path from query

LogParser User : onerrorgoto — Fri, 02 Mar 2007 07:31:00 GMT

Hello
I have 1500 xml files I have to search trough to find some interesting values.

What I also would like to find is the filename of each occuranse.
There should only be on in each file if it exists at all in the file.

This is my query right now:
select datum, medlemsnr, fakturanr, artikelnr, artikelnamn, artikelgrupp,Levererat
from C:\temp\Inforportal_elonstat\xml\*.xml
where artikelnr='101132'
I would like to add the filename or path like this:
select filename,datum, medlemsnr, fakturanr, artikelnr, artikelnamn, artikelgrupp,Levererat
from C:\temp\Inforportal_elonstat\xml\*.xml
where artikelnr='101132'
the filename is not in the xml-file itself.
Is this possible?

/Anders

RE: XML output

LogParser User : imtiaz — Thu, 20 Jul 2006 10:37:00 GMT

Sir,

SQL SERVER is generated trc extention "sdc.trc" i m writing query is mentioned below

LogParser "SELECT * INTO Report.HTML FROM AdmnActvty_20060608_223750.trc" -i:TEXTWORD –o:TPL –tpl:Template.txt

But its not wotking plz send me right script.

Thx for you cooperation.

RE: XML output

LogParser User : DEinspanjer — Thu, 20 Jul 2006 10:17:00 GMT

I do not know what the format of a trace file is, but my first suggestion would be to read through the help file documentation and look at the included sample scripts in the examples directory of your installation.

RE: XML output

LogParser User : imtiaz — Thu, 20 Jul 2006 09:17:00 GMT

Yeah thx its working..plz tell me

Please help me out of what is the query of to create html page from sql server log tace file which extension is .trc".Please tell me full steps to find out reports.

Please direct email to at imtiaz.hussain@citigroup.com

RE: XML output

LogParser User : DEinspanjer — Wed, 19 Jul 2006 16:00:00 GMT

I just tried with both -o:NAT and with -o:XML and didn't see that error in either case. Are you sure you want to be using -o:NAT if you are populating an XML file?

XML output

LogParser User : imtiaz — Wed, 19 Jul 2006 08:55:00 GMT

I am being retrieved an error when run the mentioned below script.

LogParser -i:EVT -o:NAT "SELECT TimeGenerated, EventTypeName, SourceName AS Account INTO Report.xml FROM System"

Error :

Invalid at the top level of the document. Error processing resource 'file:///C:/Program Files/Log Parser 2.2/Report.xml'. Line 1, Position 1

RE: Script to output differing file properties as XML

LogParser User : David Manley — Wed, 28 Jun 2006 09:25:00 GMT

Updated vbs to enable correct handling where file name included a comma (,) or single quote ('). The link in the previous posting now points to an updated zip file with the corrected script.

David.

RE: Script to output differing file properties as XML

LogParser User : DEinspanjer — Sat, 24 Jun 2006 23:34:00 GMT

Neat. This might come in handy at my work too.