Sort WMI query

[greg0303]

I am querying a server's WMI to find all the printers installed locally on it. This query returns all the printers, which I want:
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
Set colPrinter = objWMIService.ExecQuery("Select * from Win32_Printer")

For Each objPrinter in colPrinter
msgbox objPrinter.caption
Next
However I want them in order of the printer name, so I tried putting in the query "Select * from Win32_Printer order by Caption" but this gave an error code 80041017 which suggests the caption field is null. Anyone know how to sort a WMI query?

 

[dm4ever]

Even though WQL has similarities to SQL, it is not the same. You can not have it return your collection in a sorted manner. You will need to use some alternate scripting technique to accomplish this; whether you use .NET array, disconnected recordset, bubble sort, or some other method.

--------------------------------------------------------------------------------
dm4ever
My philosophy: K.I.S.S - Keep It Simple Stupid

 

[dm4ever]

sorting FAQ's you can find here

http://www.tek-tips.com/faqs.cfm?fid=4836

http://www.tek-tips.com/faqs.cfm?fid=3362

.Net Array:

http://www.microsoft.com/technet/technetmag/issues/2007/01/HeyScriptingGuy/default.aspx

--------------------------------------------------------------------------------
dm4ever
My philosophy: K.I.S.S - Keep It Simple Stupid

 

[monksnake]

Can you do

 Set colPrinter = objWMIService.ExecQuery("Select [!]Caption[/!] from Win32_Printer")

From what I've read, it should automatically put the list in alphabetical order.

<.

 

[greg0303]

The script in faq329-4836 post works beautifully!

Thanks for your help.

 

[dm4ever]

No, that will not return it in an ordered fashion. That will just return the caption for any instances of the Win32_Printer class.

--------------------------------------------------------------------------------
dm4ever
My philosophy: K.I.S.S - Keep It Simple Stupid

 

[monksnake]

Hmm ok thanks dm4ever

<.