After you have selected the properties (one or more properties, or all of them), you use the From keyword to list which WMI class to query. To choose all properties from a WMI class, you use the asterisk (“*”). Using the Select statementĪ typical WMI query begins by using the Select statement to choose everything or only a few properties from a WMI class. The basic WQL statements that you need to know are Select, From, and Where. There is documentation on MSDN, for example, WQL (SQL for WMI), but it is more or less COM based, and while it is comprehensive, it is more extensive than a typical Net Admin or IT Pro would need to do. So one would think that WQL really is Windows Management Instrumentation Query Language but it probably is not. WMI stands for Windows Management Instrumentation. I am also contributing a chapter to a new book about Windows PowerShell and SQL Server 2012 written by Laerte Junior, Bob Beachumin, and Mark Broadbent. WS, of course I know what WQL is-I wrote the book on WMI: Microsoft Windows Scripting with WMI: Self-Paced Learning Guide. Tonight, the best we can do is go out for dinner and a movie with Brian (one of our Charlotte Windows PowerShell User Group friends). We already have three dates lined up in some of our favorite cities. Unfortunately, it will not be until November, but at least we will escape the heat and get a chance to see many of our Windows PowerShell friends who we have met over the years and those who we want to meet.

With all this heat, we began dreaming of cool places, and so we booked a trip to Germany. It has been hovering around 105 degrees Fahrenheit (40.5 degrees Celsius, according to my conversion module). Things are all in a flutter here in Charlotte, North Carolina in the United States. Microsoft Scripting Guy, Ed Wilson, is here. So back to my question, do you know what WQL is? I mean, General Electric and General Motors sound alike, but they do not have much in common. Hey, Scripting Guy! What is WQL? It sounds like SQL, but that does not always mean very much. Summary: Microsoft Scripting Guy, Ed Wilson, talks about using WMI Query Language and Windows PowerShell to get WMI data.

Wmic select query