{"id":55123,"date":"2008-09-03T02:19:00","date_gmt":"2008-09-03T02:19:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2008\/09\/03\/hey-scripting-guy-how-do-i-use-windows-powershell-to-run-the-same-wmi-queries-against-multiple-computers\/"},"modified":"2008-09-03T02:19:00","modified_gmt":"2008-09-03T02:19:00","slug":"hey-scripting-guy-how-do-i-use-windows-powershell-to-run-the-same-wmi-queries-against-multiple-computers","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/hey-scripting-guy-how-do-i-use-windows-powershell-to-run-the-same-wmi-queries-against-multiple-computers\/","title":{"rendered":"Hey, Scripting Guy! How Do I Use Windows PowerShell to Run the Same WMI Queries Against Multiple Computers?"},"content":{"rendered":"

<\/p>\n

<\/p>\n

\"Hey, <\/h2>\n

Hey, Scripting Guy! I need to run the same WMI queries against multiple computers on our network. Can I do this with Windows PowerShell?<\/p>\n

– KB<\/p>\n

\"Spacer\"\"Hey, <\/p>\n

Hi KB,<\/p>\n

Not only can you do this with Windows PowerShell, but you will be surprised at how easy it is to do. If you can create a text file in Notepad, you can run your multiple queries against multiple servers. Well, actually, you need two text files and a script, but other than that it is really simple. Here is the code:<\/p>\n

$aryquery = Get-Content -path c:\\fso\\query.txt\n$computer = Get-Content -path c:\\fso\\servers.txt\nForeach ($query in $aryQuery)\n{\n Get-WmiObject -Query $query -computername $computer\n}\n<\/pre>\n
The script begins by reading two separate text files and storing the results into an array of text strings. It then uses a ForEach<\/b>statement to walk through each of the queries, and then it performs the query.<\/p>\n
To read the text files we use the Get-Content<\/b> cmdlet and specify the path to the text file. The first text file we read stores the queries we intend to run. Query.txt<\/b> is seen here:<\/p>\n
\"query.txt <\/p>\n
 <\/p>\n
As you can see, the query.txt<\/b> file is nothing really special. It is simply a collection of WMI queries. As an added bonus, you do not even have to surround the queries in quotation marks, and you don’t need to worry about case-sensitivity issues. The syntax of these queries is exactly the same as you would have used when writing VBScripts. In fact, if it were me (wait, it is<\/i> me), I would steal some queries from some of my old VBScripts and avoid reinventing the wheel (or in this case the query). You can see the query I stole from my own BLOCKED SCRIPT<\/p>\n
\"VBScript <\/p>\n
 <\/p>\n
The next file we need to use is the servers.txt<\/b> file. This file will contain the names of the servers we wish to query. As seen here,servers.txt<\/b> file is nothing special either. It is literally a list of server names. No commas are required and neither are quotation marks. By the way, IP addresses would also work in this file:<\/p>\n
\"servers.txt <\/p>\n
 <\/p>\n
With our two files out of the way, it is time to begin processing the files. This is a fancy word for “opening them up and taking a gander.” And we don’t mean stealing geese. We use Get-Content<\/b> to read the content of the text files. Because there are two files, we will be using the Get-Content<\/b> cmdlet twice, as seen here: <\/p>\n
$aryquery = Get-Content -path c:\\fso\\query.txt\n$computer = Get-Content -path c:\\fso\\servers.txt\n<\/pre>\n
We store the content of the query.txt file in the variable $aryquery<\/b>, and we store the contents of the server.txt<\/b> file in the $computer<\/b>variable. You may be wondering why I named one variable $aryquery<\/b> and the other $computer<\/b>. Patience, scripthopper. You will understand this soon. When we use Get-Content<\/b> it always returns an array. In VBScript, when you hear the word “array,” you thinkFOR EACH NEXT<\/b>. Well, in Windows PowerShell, when you hear the word “array,” you should think ForEach<\/b>. Because we have an array of WMI queries, we will need to use the ForEach<\/b> statement to walk through our array of queries. As we go through the array, we will execute one query at a time. We use the variable $query<\/b> to hold the individual query from our array. This is seen here:<\/p>\n
ForEach ($query in $aryQuery)<\/pre>\n
To execute the WMI queries, we will use the Get-WmiObject<\/b> cmdlet. We use the -query<\/b> parameter to supply the query we wish to execute. Now here is where things really get cool. The -computername<\/b> parameter in the Get-WmiObject<\/b> cmdlet can take an array! You read this right! It will take an array! That’s three exclamation points! Now four! Okay, I’ll stop. This is why I did not bother to name the contents of the servers.txt<\/b> file with the ary<\/b> prefix. I had no intention of iterating through the array. This line of code is seen here:<\/p>\n
Get-WmiObject -Query $query -computername $computer<\/pre>\n
When you run this script, it could produce a lot of output, and you may want to write the contents to a file. You could use either the redirection arrows (>>) or you could use out-file<\/b>. If you used the >> arrows it would look something like this:<\/p>\n
Get-WmiObject -Query $query -computername $computer >> c:\\fso\\output.txt<\/pre>\n
(If you have a folder named fso<\/b> and are writing to a file named output.txt<\/b>, that’s exactly how the command will look; otherwise, your command will look different.)<\/p>\n
So, KB, this is it. This could be the last WMI script you ever need to write. From here on out, all you need to do is to copy the WMI queries from your old VBScripts and paste them into the query.txt<\/b> file and you are done. Of course, this probably will not be the last WMI script you ever write, because WMI is fun stuff.<\/p>\n
Ed Wilson and Craig Liebendorfer, Scripting Guys<\/b><\/b><\/span><\/font><\/p>\n
<\/b><\/font><\/span><\/font><\/h2>\n
<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! I need to run the same WMI queries against multiple computers on our network. Can I do this with Windows PowerShell? – KB Hi KB, Not only can you do this with Windows PowerShell, but you will be surprised at how easy it is to do. If you can create a text […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[2,3,4,14,45,6],"class_list":["post-55123","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-running","tag-scripting-guy","tag-scripting-techniques","tag-text-files","tag-windows-powershell","tag-wmi"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! I need to run the same WMI queries against multiple computers on our network. Can I do this with Windows PowerShell? – KB Hi KB, Not only can you do this with Windows PowerShell, but you will be surprised at how easy it is to do. If you can create a text […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/55123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=55123"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/55123\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=55123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=55123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=55123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}