And now, Jeff…<\/p>\n
I once tweeted the following:<\/p>\n
This blog post is all about that quote.<\/p>\n Some time ago, I found myself in a situation where I needed to create a generic function that knew what other function or script called it. Let me explain…<\/p>\n I wanted to write a function to log information to the screen, to a SQL Server database and\/or to a file. After searching and failing because I was overthinking it, I finally gave up and asked for help from my fellow Windows PowerShell MVPs.<\/p>\n As always, I got a reply. In this case, the reply was from Oisin Grehan<\/a>, with exactly the answer I was looking for: Get-PSCallStack<\/b>.<\/p>\n The Get-PSCallStack<\/b> cmdlet gets the current call stack. It was initially written to be used with the Windows PowerShell debugger. However, it can be used outside the debugger to get the call stack inside a script or function. This is exactly what the doctor ordered!<\/p>\n There are many places you can get a call stack, so let’s go through them one-by-one.<\/p>\n When called from a script, the default output only provides you with the properties Command<\/b>, Arguments<\/b>, and Location<\/b>. However, there are more properties hidden that you can show by using the Select-Object<\/b> cmdlet:<\/p>\n So now let’s turn that into a reusable function and look at the call stack again:<\/p>\n That’s too much information! I only want the information from the command in the script, and not the function itself.<\/p>\n If the call stack only has a single entry, I want that entry. But if there are two (or more), I want the last entry, right?<\/p>\n function Get-Execution {<\/p>\n $CallStack = Get-PSCallStack | Select-Object -Property *<\/p>\n if ($CallStack.Count -eq 1) {<\/p>\n $CallStack[0]<\/p>\n } else {<\/p>\n $CallStack[($CallStack.Count – 1)]<\/p>\n }<\/p>\n }<\/p>\n Note<\/b> Remember that an array starts counting at 0, so selecting the first object in an array would be $VariableName[0]<\/b>.<\/p>\n The previous code will work when calling the Get-Execution<\/b> function directly from the script. But what if you, like me, prefer to write functions—so you’ll have a function that calls Get-Execution<\/b>. You’ll want the entry in the call stack for that function. Let’s see what happens:<\/p>\n It works! You can trust me when I write that it keeps working—no matter how large the tree of functions calling functions—it keeps working.<\/p>\n But wait, there’s more!<\/p>\n Reusable functions are nice, but having to copy them into all my scripts is not something I would prefer. So what if you place Get-Execution<\/b> in a module—let’s say a module with a lot of useful functions that you use in many of your scripts? Yes, it still works!<\/p>\n Now let’s try a function in the script calling Get-Execution<\/b> that’s inside the module:<\/p>\n Yup, still works like a charm.<\/p>\n This function will not work when calling from a command prompt or in the Windows PowerShell ISE from an unsaved file or selection. In those situations, no call stack is available.<\/p>\n In the case of the command prompt, I’ve found a difference in the behavior in Windows PowerShell 2.0 versus the later versions.<\/p>\n In Windows PowerShell 2.0, no output was given if no call stack was found. Additionally, no error was given. So I was able to check the variable to have no value by comparing to $null<\/b>. In The later versions of Windows PowerShell, I found that this wasn’t an option because Get-PSCallStack<\/b> provided output when no call stack was found:<\/p>\n Let’s check for an empty call stack, and if no call stack is found, we'll provide an error message:<\/p>\n That would mean we’re done, right?<\/p>\n Wrong…<\/p>\n When is the default data not enough?<\/p>\n I am actually missing one property in the output (although the data itself is available): The location of the script!<\/p>\n The current output provides the path, but only combined with the name of the script. I want a separate property with the path of the script. Here’s the code that also outputs the location of the script by taking it from ScriptName<\/b>:<\/p>\n function Get-Execution {<\/p>\n $CallStack = Get-PSCallStack | Select-Object -Property *<\/p>\n if (<\/p>\n ($CallStack.Count -ne $null) -or<\/p>\n (($CallStack.Command -ne '<ScriptBlock>') -and<\/p>\n ($CallStack.Location -ne '<No file>') -and<\/p>\n ($CallStack.ScriptName -ne $Null))<\/p>\n ) {<\/p>\n if ($CallStack.Count -eq 1) {<\/p>\n $Output = $CallStack[0]<\/p>\n $Output | Add-Member -MemberType NoteProperty -Name ScriptLocation -Value $((Split-Path $_.ScriptName)[0]) -PassThru<\/p>\n } else {<\/p>\n $Output = $CallStack[($CallStack.Count – 1)]<\/p>\n $Output | Add-Member -MemberType NoteProperty -Name ScriptLocation -Value $((Split-Path $Output.ScriptName)[0]) -PassThru<\/p>\n }<\/p>\n } else {<\/p>\n Write-Error -Message 'No callstack detected' -Category 'InvalidData'<\/p>\n }<\/p>\n }<\/p>\n Why would I want to write such a function?<\/p>\n I like to log the actions of my scripts to a file or to a database—maybe even to the event log. So when I deliver a script to a customer, I make use of this Get-Execution<\/b> function to mention which file or script did something. Let’s take an example…<\/p>\n I’ve got a Write-Log<\/b> function, which combined with Get-Execution<\/b>, can be used like this:<\/p>\n $Execution = Get-Execution<\/p>\n Write-Log -Database 'Logging' `<\/p>\n -DBServer 'SQLDB01' `<\/p>\n –Status ‘Error’ `<\/p>\n -Time ((Get-Date -format o) -replace ':','.') `<\/p>\n -Message "$($Execution.Command) at $($Execution.Location)"<\/p>\n ~Jeff<\/p>\n Thanks for sharing, Jeff.<\/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: Microsoft PowerShell MVP, Jeff Wouters, talks about using the Get-PSCallStack Windows PowerShell cmdlet. Microsoft Scripting Guy, Ed Wilson, is here. Today Windows PowerShell MVP, Jeff Wouters, is back with another guest blog post. To read more of Jeff's previous guest posts, see these Hey, Scripting Guy! Blog posts. And now, Jeff… I once tweeted […]<\/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":[294,56,381,3,4,61,45],"class_list":["post-880","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-debugging","tag-guest-blogger","tag-jeff-wouters","tag-scripting-guy","tag-scripting-techniques","tag-weekend-scripter","tag-windows-powershell"],"acf":[],"blog_post_summary":" Summary: Microsoft PowerShell MVP, Jeff Wouters, talks about using the Get-PSCallStack Windows PowerShell cmdlet. Microsoft Scripting Guy, Ed Wilson, is here. Today Windows PowerShell MVP, Jeff Wouters, is back with another guest blog post. To read more of Jeff's previous guest posts, see these Hey, Scripting Guy! Blog posts. And now, Jeff… I once tweeted […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/880","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=880"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/880\/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=880"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=880"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=880"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/wes-8-3-14-1.png\" "\\"Image")
<\/a><\/p>\n
So if function one calls the logging function, the logging function needed to figure that it was called by function one.<\/p>\nA script<\/h2>\n
![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/wes-8-3-14-2.png\" "\\"Image")
<\/a><\/p>\n![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/wes-8-3-14-3.png\" "\\"Image")
<\/a><\/p>\nCalling from a function in a script<\/h2>\n
![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/wes-8-3-14-4.png\" "\\"Image")
<\/a><\/p>\nGet-Execution in a module<\/h2>\n
This would negate the need to copy the code into all your scripts. Simply load the module, and all the functions in that mode are available to you. Let’s see if it still works:<\/p>\n![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/wes-8-3-14-5.png\" "\\"Image")
<\/a><\/p>\n![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/wes-8-3-14-6.png\" "\\"Image")
<\/a><\/p>\nWhen will it not work?<\/h2>\n
![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/wes-8-3-14-7.png\" "\\"Image")
<\/a><\/p>\nUse case?<\/h2>\n