[QUOTE User="LogParser User : StanL"]Quote: You don't have an INTO clause specified in your query, so I imagine the output format is trying to get a handle to STDOUT and failing. Try changing your query to "SELECT * INTO foo.xml FROM ." and th...[/QUOTE] My bad, I tried SELECT * FROM . INTO and got an...

You don't have an INTO clause specified in your query, so I imagine the output format is trying to get a handle to STDOUT and failing. Try changing your query to "SELECT * INTO foo.xml FROM ." and then see if your ExecuteBatch works.

Oh, BTW if I simply script oRS = oLog.Execute cSQL, oInput I can query the recordset object using GetColumnCount(), GetColumnName() and toNativeString( "," ) to concatenate a .csv file... but the question remains, why doesn't it accept an output format? Stan

I registered the QBF.wsc and executed the command line logparser "SELECT * FROM ." -i:COM -iprogid:MSUtil.LogQuery.Sample.QFE and it worked. I wanted to 'script' the .wsc and so set up cSQL = 'SELECT * FROM .' oLog = CreateObject("MSUtil.LogQuery") oInput = CreateObject("MSUtil.LogQuery.Sample.QFE")...

Hi, I've had runtime problems when I refer LogParser's COM Objects after registering the DLL in COM+. After removing it from COM+ and registering it using regsvr32 the code executes fine. Does anyone else use COM+ or do you know if LogParser works with it? Thanks, Richard

So that Column Name is not an integer error is coming from the Chart3D. It seems to want the first column to be a number. Did you try a different chart out?

Daniel, Thanks for the reply. I tried that this morning: logparser "SELECT Name, Capacity, MUL(PROPSUM(FreeSpace), 100) AS Percent INTO VolSpace.gif FROM Win32_Volume WHERE Name LIKE '%PSSTATIC%' GROUP BY Name,Capacity ORDER BY Percent DESC" -i:COM -iProgID:LP_ToolKit.WMIQuery -iCOMParams:ComputerName...

I'm not really familiar with the toolkit WMIQuery, but given the information you've provided, it seems like this would work: -i:COM -iProgID:LP_ToolKit.WMIQuery -iCOMParams:"ComputerName=myremoteserver" ...

Good day all, I use a WMI script to retrieve Win32_Volume properties from a remote MS Cluster server, write the results to CSV and email to dept managers. I prefer the output options with Logparser and want to convert the script to the LP_Toolkit COM input but ran into a problem - how do I point this...

Hi Daniel, Thanks for the help. I looked around on the forums and resources pages and found an explanation of how the custom properties structure behaves. I fixed that and things work now! Thanks a lot for pointing me along. regards, -vijai.