{"id":627,"date":"2014-09-25T00:01:00","date_gmt":"2014-09-25T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2014\/09\/25\/analyzing-powershell-script-files\/"},"modified":"2014-09-25T00:01:00","modified_gmt":"2014-09-25T00:01:00","slug":"analyzing-powershell-script-files","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/analyzing-powershell-script-files\/","title":{"rendered":"Analyzing PowerShell Script Files"},"content":{"rendered":"

Summary<\/b>: Learn how to analyze Windows PowerShell script files.<\/span><\/p>\n

Microsoft Scripting Guy, Ed Wilson, is here. This morning I am sitting around sipping a cup of English Breakfast tea. I added some peppermint, spearmint, lemon grass, licorice root, and a cinnamon stick to the pot. The result is a very refreshing cup of tea. I am sitting on the back porch with my Surface 3 Pro and playing around with Windows PowerShell.<\/p>\n

I have a folder that I use to store miscellaneous Windows PowerShell scripts. I call the folder PSExtras and it contains scripts that I wrote for no apparent reason—I was just playing around. I decided that I would look at some of these scripts to determine a few things about the way I write scripts. To be fair, I have not added much to this folder in the last several years. Therefore, the folder is really more a picture of the way I used to write Windows PowerShell scripts three to four years ago.<\/p>\n

One of the cool things about the Select-String<\/b> cmdlet is that not only will it parse a file, but it will also parse all files in a folder. For example, if I want to see the files where I used the Write-Host<\/b> cmdlet, all I need to do is write something like:<\/p>\n

Select-String -Path E:\\Data\\PSExtras\\*.ps1 -Pattern 'write-host' -List | select filename, line –Unique<\/p>\n

The output produces a list of the file names and the line where the Write-Host<\/b> cmdlet appeared in the script.<\/p>\n

These days, the main reason I use the Write-Host<\/b> cmdlet is because I want to display output in a different color. I always use the –ForeGround<\/b> parameter when I do this. So, in how many of my scripts did I do this in my PSExtras folder? Here is the answer (this is a one-line command that is broken to fit on the website):<\/p>\n

PS C:\\> Select-String -Path E:\\Data\\PSExtras\\*.ps1 -Pattern 'write-host -fore'  |
select filename, line | sort filename -Unique | measure<\/span><\/p>\n

 <\/p>\n

Count    : 204<\/p>\n

Average  :<\/p>\n

Sum      :<\/p>\n

Maximum  :<\/p>\n

Minimum  :<\/p>\n

Property :<\/p>\n

How many scripts did I write where I did not use the –Foreground<\/b> parameter? I can easily get that by removing the –fore<\/b> from my pattern. Here is the result:<\/p>\n

PS C:\\> Select-String -Path E:\\Data\\PSExtras\\*.ps1 -Pattern 'write-host'  |
select filename, line | sort filename -Unique | measure<\/span><\/p>\n

 <\/p>\n

Count    : 375<\/p>\n

Average  :<\/p>\n

Sum      :<\/p>\n

Maximum  :<\/p>\n

Minimum  :<\/p>\n

Property :<\/p>\n

But wait! That is all the files that include Write-Host<\/b>. So the answer is 375-204, which is 171 scripts that did not include a directive to change the foreground color. Today I would not do that.<\/p>\n

What about the length of these scripts? I can get this information by using the Measure-Object<\/b> cmdlet.<\/p>\n

To do this, I use the Get-ChildItem<\/b> cmdlet to find all of my .ps1 script files. Then for each of them, I get the content of the file and pipe it to the Measure-Object<\/b> cmdlet where I choose the Line<\/b> property. Now I pipe that to the Measure-Object<\/b> cmdlet, and I choose the Average<\/b>, Maximum<\/b>, and Minimum<\/b> properties. Here is the command (using aliases) and the output from the command:<\/p>\n

PS C:\\> Gci E:\\Data\\PSExtras\\*.ps1 | % {get-content $_.fullname | measure -Line } |
measure -Property lines -Average -Maximum -Minimum<\/p>\n

 <\/p>\n

Count    : 1347<\/p>\n

Average  : 35.7995545657016<\/p>\n

Sum      :<\/p>\n

Maximum  : 698<\/p>\n

Minimum  : 1<\/p>\n

Property : Lines<\/p>\n

This tells me that I have 1347 scripts in my PSExtras folder, and that the average length is 35 lines (this also includes comments and blank lines). The maximum length of my scripts is 698 lines, and the shortest one (no surprise) is a one-liner.<\/p>\n

Most of the time, I do not save one-liners in files because I can easily re-create them (this is usually quicker than it takes me to actually locate the script file that contains the command), so this is not necessarily representative of my Windows PowerShell usage. But, I do think it is kind of interesting.<\/p>\n

How does this compare with the VBScript files I wrote over the years? I also have a VBSExtras folder, so let's find out:<\/p>\n

PS C:\\> Gci E:\\Data\\VBSExtras\\*.vbs | % {get-content $_.fullname | measure -Line } |
measure -Property lines -Average -Maximum -Minimum<\/p>\n

 <\/p>\n

Count    : 1610<\/p>\n

Average  : 48.2391304347826<\/p>\n

Sum      :<\/p>\n

Maximum  : 1846<\/p>\n

Minimum  : 0<\/p>\n

Property : Lines<\/p>\n

Wow! The average file length was 48 lines long, and my longest VBScript is 1846 lines long. Note that I also have more VBScript files than I have Windows PowerShell files in my *Extras folder. This is probably because of the fact that I do not save all my one-liners.<\/p>\n

Here is an image that shows the two commands and their associated output:<\/p>\n

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

That is all there is to using Select-String<\/b> and working with files. Join me tomorrow when I will talk about more cool stuff.<\/p>\n

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

Ed Wilson, Microsoft Scripting Guy<\/b> <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Summary: Learn how to analyze Windows PowerShell script files. Microsoft Scripting Guy, Ed Wilson, is here. This morning I am sitting around sipping a cup of English Breakfast tea. I added some peppermint, spearmint, lemon grass, licorice root, and a cinnamon stick to the pot. The result is a very refreshing cup of tea. I […]<\/p>\n","protected":false},"author":596,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[51,3,4,336,45],"class_list":["post-627","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-getting-started","tag-scripting-guy","tag-scripting-techniques","tag-strings","tag-windows-powershell"],"acf":[],"blog_post_summary":"

Summary: Learn how to analyze Windows PowerShell script files. Microsoft Scripting Guy, Ed Wilson, is here. This morning I am sitting around sipping a cup of English Breakfast tea. I added some peppermint, spearmint, lemon grass, licorice root, and a cinnamon stick to the pot. The result is a very refreshing cup of tea. I […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/627","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\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=627"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/627\/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=627"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=627"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=627"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}