{"id":17661,"date":"2010-07-24T00:01:00","date_gmt":"2010-07-24T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2010\/07\/24\/weekend-scripter-where-exethe-what-why-and-how\/"},"modified":"2010-07-24T00:01:00","modified_gmt":"2010-07-24T00:01:00","slug":"weekend-scripter-where-exethe-what-why-and-how","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/weekend-scripter-where-exethe-what-why-and-how\/","title":{"rendered":"Weekend Scripter: Where.exe—The What, Why, and How"},"content":{"rendered":"

Microsoft Scripting Guy Ed Wilson here. The sounds outside seems amplified by the inky darkness that grudgingly gives way to the early morning sun. I am sitting on the front porch sipping a cup of English Breakfast Tea, munching on a freshly baked cinnamon scone, and hanging out on Twitter via my laptop. Having wireless access throughout our house makes possible an Internet life without boundaries. Of course, in my office, I have a gigabit switched ethernet network, but from general roaming around The House That Scripting Built, the 54 Mbps I get from my Wireless G (802.11g) broadband router is sufficient.<\/p>\n

As I sipped my morning cup of tea, I reflected on the “work week” that recently passed. Another week on the calendar seems to slip into the sands of time. One hundred and twenty hours are gone—and what was accomplished? Well, let’s see. I spent nearly eight hours in meetings, and at least as much time answering email. I wrote a series of articles on using Windows PowerShell and the Active Directory cmdlets that were pretty cool. I also spent some time on Facebook, and hanging out on Twitter. <\/p>\n

Speaking of Twitter, I had an intriguing conversation with a person who is a system administrator and Windows PowerShell scripter from Rotterdam who was talking about the performance of the Get-ChildItem<\/b> cmdlet when compared to using Where.exe. Hmm … I said. <\/p>\n

The first thing to realize is that inside Windows PowerShell, you must use Where.exe if you intend to call the “where command.” The reason for this, is that where<\/b> is an alias for the Where-Object<\/b> cmdlet. If you use where<\/b> without supplying the .exe extension, an error occurs, as shown in the following image.<\/p>\n

\"Image<\/a> <\/p>\n

When I add the .exe extension to the where command, I am rewarded with an output that displays all of the pictures I have put in my Hey, Scripting Guy! Blog posts in the month of June. The \/R<\/b> means to recurse. The command is shown here:<\/p>\n

 <\/p>\n

PS<\/span> <\/span>C:\\><\/span> <\/span>where<\/span>.exe<\/span> <\/span>\/<\/span>R<\/span> <\/span>c:\\data<\/span> <\/span>HSG-7*.jpg<\/span>
<\/span>c:\\data\\ScriptingGuys\\2010\\HSG_7_5_10\\HSG-7-6-10-01.jpg<\/span>
<\/span>c:\\data\\ScriptingGuys\\2010\\HSG_7_5_10\\HSG-7-6-10-02.jpg<\/span>
<\/span>c:\\data\\ScriptingGuys\\2010\\HSG_7_5_10\\HSG-7-6-10-03.jpg<\/span>
<\/span>c:\\data\\ScriptingGuys\\2010\\HSG_7_5_10\\HSG-7-6-10-04.jpg<\/span>
<\/span>c:\\data\\ScriptingGuys\\2010\\HSG_7_5_10\\HSG-7-6-10-05.jpg<\/span>
<\/span>c:\\data\\ScriptingGuys\\2010\\HSG_7_5_10\\HSG-7-6-10-06.jpg<\/span>
<\/span>c:\\data\\ScriptingGuys\\2010\\HSG_7_5_10\\HSG-7-6-10-07.jpg<\/span>
<\/span>c:\\data\\ScriptingGuys\\2010\\HSG_7_5_10\\HSG-7-6-10-08.jpg<\/span>
<\/span>c:\\data\\ScriptingGuys\\2010\\HSG_7_5_10\\HSG-7-6-10-09.jpg<\/span>
<\/span>c:\\data\\ScriptingGuys\\2010\\HSG_7_5_10\\HSG-7-7-10-01.jpg<\/span>
<\/span>c:\\data\\ScriptingGuys\\2010\\HSG_7_5_10\\HSG-7-8-10-01_OldSeanPic.jpg<\/span>
<\/span>PS<\/span> <\/span>C:\\><\/span> <\/div>\n

To perform the same command using the Get-ChildItem<\/b> cmdlet, you would specify the path, and use a path<\/b> parameter and the recurse<\/b> switch. This command and the results it produces are shown here:<\/p>\n

 <\/p>\n

PS<\/span> <\/span>C:\\><\/span> <\/span>Get-ChildItem<\/span> <\/span>-Path<\/span> <\/span>c:\\data<\/span> <\/span>-Include<\/span> <\/span>HSG-7*.jpg<\/span> <\/span>-Recurse<\/span>
<\/span>Directory:<\/span> <\/span>C:\\data\\ScriptingGuys\\2010\\HSG_7_5_10<\/span>
<\/span>Mode<\/span> <\/span>LastWriteTime<\/span> <\/span>Length<\/span> <\/span>Name<\/span>
<\/span>—-<\/span> <\/span>————-<\/span> <\/span>——<\/span> <\/span>—-<\/span>
<\/span>-a—<\/span> <\/span>6<\/span>\/<\/span>30<\/span>\/<\/span>2010<\/span> <\/span>1<\/span>:<\/span>32<\/span> <\/span>PM<\/span> <\/span>5495<\/span> <\/span>HSG-7-6-10-01.jpg<\/span>
<\/span>-a—<\/span> <\/span>6<\/span>\/<\/span>30<\/span>\/<\/span>2010<\/span> <\/span>1<\/span>:<\/span>34<\/span> <\/span>PM<\/span> <\/span>20035<\/span> <\/span>HSG-7-6-10-02.jpg<\/span>
<\/span>-a—<\/span> <\/span>6<\/span>\/<\/span>30<\/span>\/<\/span>2010<\/span> <\/span>1<\/span>:<\/span>35<\/span> <\/span>PM<\/span> <\/span>53348<\/span> <\/span>HSG-7-6-10-03.jpg<\/span>
<\/span>-a—<\/span> <\/span>6<\/span>\/<\/span>30<\/span>\/<\/span>2010<\/span> <\/span>1<\/span>:<\/span>36<\/span> <\/span>PM<\/span> <\/span>39764<\/span> <\/span>HSG-7-6-10-04.jpg<\/span>
<\/span>-a—<\/span> <\/span>6<\/span>\/<\/span>30<\/span>\/<\/span>2010<\/span> <\/span>1<\/span>:<\/span>37<\/span> <\/span>PM<\/span> <\/span>39875<\/span> <\/span>HSG-7-6-10-05.jpg<\/span>
<\/span>-a—<\/span> <\/span>6<\/span>\/<\/span>30<\/span>\/<\/span>2010<\/span> <\/span>1<\/span>:<\/span>37<\/span> <\/span>PM<\/span> <\/span>13774<\/span> <\/span>HSG-7-6-10-06.jpg<\/span>
<\/span>-a—<\/span> <\/span>6<\/span>\/<\/span>30<\/span>\/<\/span>2010<\/span> <\/span>1<\/span>:<\/span>39<\/span> <\/span>PM<\/span> <\/span>20299<\/span> <\/span>HSG-7-6-10-07.jpg<\/span>
<\/span>-a—<\/span> <\/span>6<\/span>\/<\/span>30<\/span>\/<\/span>2010<\/span> <\/span>1<\/span>:<\/span>40<\/span> <\/span>PM<\/span> <\/span>17651<\/span> <\/span>HSG-7-6-10-08.jpg<\/span>
<\/span>-a—<\/span> <\/span>6<\/span>\/<\/span>30<\/span>\/<\/span>2010<\/span> <\/span>1<\/span>:<\/span>40<\/span> <\/span>PM<\/span> <\/span>39922<\/span> <\/span>HSG-7-6-10-09.jpg<\/span>
<\/span>-a—<\/span> <\/span>6<\/span>\/<\/span>30<\/span>\/<\/span>2010<\/span> <\/span>5<\/span>:<\/span>45<\/span> <\/span>PM<\/span> <\/span>4104<\/span> <\/span>HSG-7-7-10-01.jpg<\/span>
<\/span>-a—<\/span> <\/span>4<\/span>\/<\/span>15<\/span>\/<\/span>2010<\/span> <\/span>9<\/span>:<\/span>04<\/span> <\/span>PM<\/span> <\/span>23410<\/span> <\/span>HSG-7-8-10-01_OldSeanPic.jpg<\/span>
<\/span>PS<\/span> <\/span>C:\\><\/span> <\/div>\n

When I ran the two commands, I noticed that the Get-ChildItem<\/b> command seemed to take longer to complete. I therefore decided to pull out the Measure-Command<\/b> cmdlet to see how long each command takes to complete. When using Where.exe, the command takes 1.04 seconds. This is shown here: <\/p>\n

 <\/p>\n

PS<\/span> <\/span>C:\\><\/span> <\/span>Measure-Command<\/span> <\/span>{<\/span>where<\/span>.exe<\/span> <\/span>\/<\/span>R<\/span> <\/span>c:\\data<\/span> <\/span>HSG-7*.jpg}<\/span>
<\/span>Days<\/span> <\/span>:<\/span> <\/span>0<\/span>
<\/span>Hours<\/span> <\/span>:<\/span> <\/span>0<\/span>
<\/span>Minutes<\/span> <\/span>:<\/span> <\/span>0<\/span>
<\/span>Seconds<\/span> <\/span>:<\/span> <\/span>1<\/span>
<\/span>Milliseconds<\/span> <\/span>:<\/span> <\/span>46<\/span>
<\/span>Ticks<\/span> <\/span>:<\/span> <\/span>10466861<\/span>
<\/span>TotalDays<\/span> <\/span>:<\/span> <\/span>1<\/span>.21144224537037E-05<\/span>
<\/span>TotalHours<\/span> <\/span>:<\/span> <\/span>0<\/span>.<\/span>000290746138888889<\/span>
<\/span>TotalMinutes<\/span> <\/span>:<\/span> <\/span>0<\/span>.<\/span>0174447683333333<\/span>
<\/span>TotalSeconds<\/span> <\/span>:<\/span> <\/span>1<\/span>.<\/span>0466861<\/span>
<\/span>TotalMilliseconds<\/span> <\/span>:<\/span> <\/span>1046<\/span>.<\/span>6861<\/span>
<\/span>PS<\/span> <\/span>C:\\><\/span> <\/div>\n

When I used the Measure-Command<\/b> cmdlet to test the performance of the Get-ChildItem<\/b> cmdlet, it tells me that the command took 5.9 seconds to run. This is shown here:<\/p>\n

 <\/p>\n

PS<\/span> <\/span>C:\\><\/span> <\/span>Measure-Command<\/span> <\/span>{<\/span>Get-ChildItem<\/span> <\/span>-Path<\/span> <\/span>c:\\data<\/span> <\/span>-Include<\/span> <\/span>HSG-7*.jpg<\/span> <\/span>-Recurse}<\/span>
<\/span>Days<\/span> <\/span>:<\/span> <\/span>0<\/span>
<\/span>Hours<\/span> <\/span>:<\/span> <\/span>0<\/span>
<\/span>Minutes<\/span> <\/span>:<\/span> <\/span>0<\/span>
<\/span>Seconds<\/span> <\/span>:<\/span> <\/span>5<\/span>
<\/span>Milliseconds<\/span> <\/span>:<\/span> <\/span>923<\/span>
<\/span>Ticks<\/span> <\/span>:<\/span> <\/span>59235892<\/span>
<\/span>TotalDays<\/span> <\/span>:<\/span> <\/span>6<\/span>.85600601851852E-05<\/span>
<\/span>TotalHours<\/span> <\/span>:<\/span> <\/span>0<\/span>.<\/span>00164544144444444<\/span>
<\/span>TotalMinutes<\/span> <\/span>:<\/span> <\/span>0<\/span>.<\/span>0987264866666667<\/span>
<\/span>TotalSeconds<\/span> <\/span>:<\/span> <\/span>5<\/span>.<\/span>9235892<\/span>
<\/span>TotalMilliseconds<\/span> <\/span>:<\/span> <\/span>5923<\/span>.<\/span>5892<\/span>
<\/span>PS<\/span> <\/span>C:\\><\/span> <\/div>\n

One of the big things about using Windows PowerShell cmdlets is that they always return objects. When using the Where.exe command, it returns strings. But because the Where.exe command returns strings, it might seem that it is not the best tool to use with Windows PowerShell. However, the path parameter of the Get-Item<\/b> cmdlet will accept a string, so I can pipe the results of Where.exe to the Foreach-Object<\/b> cmdlet and inside the script block I can use Get-Item<\/b> to return a System.IO.FileInfo<\/b> .NET Framework class. This is command is shown here:<\/p>\n

 <\/p>\n

PS<\/span> <\/span>C:\\><\/span> <\/span>where<\/span>.exe<\/span> <\/span>\/<\/span>R<\/span> <\/span>c:\\data<\/span> <\/span>HSG-7*.jpg<\/span> <\/span>|<\/span> <\/span>ForEach-Object<\/span> <\/span>{<\/span> <\/span>Get-Item<\/span> <\/span>-Path<\/span> <\/span>$_<\/span> <\/span>}<\/span>
<\/span>Directory:<\/span> <\/span>C:\\data\\ScriptingGuys\\2010\\HSG_7_5_10<\/span>
<\/span>Mode<\/span> <\/span>LastWriteTime<\/span> <\/span>Length<\/span> <\/span>Name<\/span>
<\/span>—-<\/span> <\/span>————-<\/span> <\/span>——<\/span> <\/span>—-<\/span>
<\/span>-a—<\/span> <\/span>6<\/span>\/<\/span>30<\/span>\/<\/span>2010<\/span> <\/span>1<\/span>:<\/span>32<\/span> <\/span>PM<\/span> <\/span>5495<\/span> <\/span>HSG-7-6-10-01.jpg<\/span>
<\/span>-a—<\/span> <\/span>6<\/span>\/<\/span>30<\/span>\/<\/span>2010<\/span> <\/span>1<\/span>:<\/span>34<\/span> <\/span>PM<\/span> <\/span>20035<\/span> <\/span>HSG-7-6-10-02.jpg<\/span>
<\/span>-a—<\/span> <\/span>6<\/span>\/<\/span>30<\/span>\/<\/span>2010<\/span> <\/span>1<\/span>:<\/span>35<\/span> <\/span>PM<\/span> <\/span>53348<\/span> <\/span>HSG-7-6-10-03.jpg<\/span>
<\/span>-a—<\/span> <\/span>6<\/span>\/<\/span>30<\/span>\/<\/span>2010<\/span> <\/span>1<\/span>:<\/span>36<\/span> <\/span>PM<\/span> <\/span>39764<\/span> <\/span>HSG-7-6-10-04.jpg<\/span>
<\/span>-a—<\/span> <\/span>6<\/span>\/<\/span>30<\/span>\/<\/span>2010<\/span> <\/span>1<\/span>:<\/span>37<\/span> <\/span>PM<\/span> <\/span>39875<\/span> <\/span>HSG-7-6-10-05.jpg<\/span>
<\/span>-a—<\/span> <\/span>6<\/span>\/<\/span>30<\/span>\/<\/span>2010<\/span> <\/span>1<\/span>:<\/span>37<\/span> <\/span>PM<\/span> <\/span>13774<\/span> <\/span>HSG-7-6-10-06.jpg<\/span>
<\/span>-a—<\/span> <\/span>6<\/span>\/<\/span>30<\/span>\/<\/span>2010<\/span> <\/span>1<\/span>:<\/span>39<\/span> <\/span>PM<\/span> <\/span>20299<\/span> <\/span>HSG-7-6-10-07.jpg<\/span>
<\/span>-a—<\/span> <\/span>6<\/span>\/<\/span>30<\/span>\/<\/span>2010<\/span> <\/span>1<\/span>:<\/span>40<\/span> <\/span>PM<\/span> <\/span>17651<\/span> <\/span>HSG-7-6-10-08.jpg<\/span>
<\/span>-a—<\/span> \n<\/span>6<\/span>\/<\/span>30<\/span>\/<\/span>2010<\/span> <\/span>1<\/span>:<\/span>40<\/span> <\/span>PM<\/span> <\/span>39922<\/span> <\/span>HSG-7-6-10-09.jpg<\/span>
<\/span>-a—<\/span> <\/span>6<\/span>\/<\/span>30<\/span>\/<\/span>2010<\/span> <\/span>5<\/span>:<\/span>45<\/span> <\/span>PM<\/span> <\/span>4104<\/span> <\/span>HSG-7-7-10-01.jpg<\/span>
<\/span>-a—<\/span> <\/span>4<\/span>\/<\/span>15<\/span>\/<\/span>2010<\/span> <\/span>9<\/span>:<\/span>04<\/span> <\/span>PM<\/span> <\/span>23410<\/span> <\/span>HSG-7-8-10-01_OldSeanPic.jpg<\/span>
<\/span>PS<\/span> <\/span>C:\\><\/span> <\/div>\n

Well, the sun is coming up now, and I think I want to head out to my woodworking shop. Join us tomorrow for another edition of Weekend Scripter. <\/p>\n

 <\/p>\n

Ed Wilson and Craig Liebendorfer, Scripting Guys<\/b><\/p>\n","protected":false},"excerpt":{"rendered":"

Microsoft Scripting Guy Ed Wilson here. The sounds outside seems amplified by the inky darkness that grudgingly gives way to the early morning sun. I am sitting on the front porch sipping a cup of English Breakfast Tea, munching on a freshly baked cinnamon scone, and hanging out on Twitter via my laptop. Having wireless […]<\/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":[38,149,3,4,12,61,45],"class_list":["post-17661","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-files","tag-pipeline","tag-scripting-guy","tag-scripting-techniques","tag-storage","tag-weekend-scripter","tag-windows-powershell"],"acf":[],"blog_post_summary":"

Microsoft Scripting Guy Ed Wilson here. The sounds outside seems amplified by the inky darkness that grudgingly gives way to the early morning sun. I am sitting on the front porch sipping a cup of English Breakfast Tea, munching on a freshly baked cinnamon scone, and hanging out on Twitter via my laptop. Having wireless […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/17661","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=17661"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/17661\/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=17661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=17661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=17661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

We invite you to follow us on Twitter<\/a> or Facebook<\/a>. If you have any questions, send email to us at scripter@microsoft.com<\/a>, or post your questions on the Official Scripting Guys Forum<\/a>. See you tomorrow. Until then, peace.<\/p>\n