How to export all rows of a WMI query to a file?

wmi wmi-query
AAsk picture AAsk · Mar 8, 2011 · Viewed 27k times · Source

Given a query such as 

SELECT * FROM WIN32_PROCESS
  1. Is there a way to interrogate the result object for the names of the columns returned?
  2. Write all the rows in the result object to a text file, say

Answer

Helen picture Helen · Mar 9, 2011

Is there a way to interrogate the result object for the names of the columns returned?

Yes. Each WMI object has the Properties_ collection that provides information about that object's properties. To get the names of properties available in an object, enumerate the Properties_ collection and check each item's Name.

Write all the rows in the result object to a text file, say

Enumerate all the rows and use the FileSystemObject to write them to the desired text file. Pseudocode:

create a text file and open it for writing

for each object in the result set
  for each property in the object
    write the property value to the file

close the file


Alternatively, you could use wmic to do all the work for you:

wmic /output:e:\processes.txt process get /all
wmic /output:e:\processes.csv process get /all /format:csv

Related questions

How can I retrieve a Windows Computer's SID using WMI?

I'm not looking for User SIDs. I'm looking for the computer SID, which active directory would use to uniquely identify the computer. I also don't want to query the active directory server, i want to query the computer itself.

Read More
How to construct WMI query

I'd like to find results that Name starts with param1, and ends with param2 but my code doesn't work string wmiQuery = string.Format("SELECT CommandLine FROM Win32_Process WHERE Name LIKE '{0}%' AND Name LIKE '%{1}'", param1, param2); …

Read More
"The RPC server is unavailable" using WMI query

I have a workgroup of web servers running Server 2008 R2 in which I'm trying to manage a script that checks the disk space of all of them. I had set this up a few months ago when the servers were …

Read More