Powershell object attribute not showing

Question

Any idea why the $result.PathName doesn't work?

$results = Get-WMIObject -query "select * from Win32_Service where Name LIKE '%sql%'" | Select Name, PathName | Format-List
ForEach ($result in $results) {
    Write-Output "Test = " + $result.PathName
}        
Write-Output "done"

Expected output:

Test = C:\blah\blah.sqlserver.exe
Test = C:\blah\blah.sqlserver.exe

Actual output

Test =
+
Test = 
+

user4003407 · Accepted Answer · 2015-01-20 10:20:03Z

3

Format-* cmdlets produce formatting instructions as output. This instructions not useful for anything except displaying result to user or for Out-* cmdlets. Remove Format-List from your code. And put expression after Write-Output in parentheses: Write-Output ("Test = " + $result.PathName), to it be interpreted as single expression but not three different arguments to Write-Output. Or you can remove Write-Output entirely as it implied by default.

edited Jan 20, 2015 at 10:20

answered Jan 20, 2015 at 10:06

user4003407

22.3k4 gold badges54 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Dird Over a year ago

Thanks this is getting at the objects but producing this: <br/> Test = @{Name=SQLWriter; PathName="C:\blah\sqlwriter.exe"}.PathName

user4003407 Over a year ago

Did you write this: "Test = $result.PathName"? You should write this instead: "Test = $($result.PathName)".

Dird Over a year ago

That got it, thanks. Any good site you recommend for picking up PS quickly? Is this site generally good for learning? powershell.com/cs/blogs/tips/archive/2009/06/08/… -- that page allowed me to get through the next part of my script

user4003407 Over a year ago

@Dird I mostly learned PowerShell by build-in documentation, MSDN, ILSpy to understand some internal working and practicing, so I can not recommend any good site for learning.

Matt Over a year ago

@Dird most people just pick it up "on the job" but I cannot recommend this book enough manning.com/payette2. If you manage to find it it's a really good in depth read

|

Collectives™ on Stack Overflow

Powershell object attribute not showing

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related