WMI Code Creator v1.0 – Download Here
Allows you to browse the available WMI classes and create query’s that can be used either through command-line through visual basic script or in your .NET projects.
Once you have your query you can then export the code for Visual C# or Visual Basic.
I used this program to create some code for a quick way of viewing installed printers on a remote print server in Visual C# by populating the results to a datagrid.
try
{
ConnectionOptions connection = new ConnectionOptions();
connection.Username = userName.Text;
connection.Password = password.Text;
connection.Authority = "ntlmdomain:DOMAINNAME";
ManagementScope scope = new ManagementScope(
"\\\\" + serverName.Text + ".FullyQualifiedDomainName\\root\\CIMV2", connection);
scope.Connect();
ObjectQuery query = new ObjectQuery(
"SELECT * FROM Win32_Printer");
ManagementObjectSearcher searcher = new ManagementObjectSearcher(scope, query);
DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone();
row.Cells[0].Value = queryObj["DeviceID"];
row.Cells[1].Value = queryObj["DriverName"];
row.Cells[2].Value = queryObj["Location"];
row.Cells[3].Value = queryObj["Name"];
row.Cells[4].Value = queryObj["Comment"];
row.Cells[5].Value = queryObj["Portname"];
row.Cells[6].Value = queryObj["SystemName"];
dataGridView1.Rows.Add(row);
}
}
catch (ManagementException e)
{
MessageBox.Show("An error occurred while querying for WMI data: " + e.Message);
}
Fast and effective to what I needed – Instead of trying to copy all the printer details out in to excel.