Yes I have tried all options as such and have run exhaustively through the xml input parameters. they all return the same error saying the field is not valid. ==rohini

Rohini, I haven't tried it with empty fields but you may onto something. One thing to note is that the default parsing is tree. Have you tried setting fmode parameter to branch or node? Maybe it will help. I don't know.

ummm not sure what you mean, I guess u mean to say u dont understand what I am saying. So.... I have an XML file When I try to do a select statement like this logparser "select nfv1,nfv2,nfv3,nfv4 from myXMLFile.xml" in this XML file the nfv4 field for every row has no value, therefore logparser...

Can you re-post using '[' and ']' instead of '<' and '>' ?

If an xml doc has a field like this for all rows meaning that nfv4 currently does not hold a value logparser will not recognize that as a field? I would still like it to pull it as '' I tried case statement like when null then '' but it wont recognize that as a field? Is this a known issue or is there...

How does the XML look like? Have you done an analysis of its structure and figured out what nodes you want out of the XML?

I have tried to parse Microsoft's XML output with Logparser 2.2 with no luck. I have set the -fMode option to all the different options and have used the -queryinfo switch to see what I can find. Has anyone had any luck parsing the MBSA output?

Do you mind posting how you got this to work ? :-) Other users might be having the same problem...

I would like to detect the data types in an XML file. I have tried several different ways of formating the command. The basic way should be according to the book and parser help. C:\>LogParser -h -i:XML Cities.xml But I keep getting this error: Fields: An error occurred while extracting field names...