Most of us are familiar with the traditional use of Select \u2013ExpandProperty <propertyname>. This takes a the value of an incoming object, enumerates its values and outputs each of those values as a single record on the output stream after adding any properties specified by the \u2013PROPERTIES <propertyname[]> parameter. An example will help:<\/p>\n
PS> gps |Select -ExpandProperty Modules -ea SilentlyContinue |Group ModuleName |Sort Count |Select -Last 4 <\/font><\/p>\n Count Name Group <\/p>\n <\/p>\n A while ago, Lee Holmes turned me on to another use of \u2013ExpandProperty and I\u2019ve been meaning to blog it ever since. Have you ever wanted to get just the value for a property from every object? You\u2019d think you could do this and it would work:<\/p>\n PS> gps *ss |select name <\/font><\/p>\n Name <\/p>\n Sadly, this is not what you want. This gives you a set of objects each of which has exactly one property: NAME. What you wanted was a stream of VALUES. What I\u2019ve always ended up doing was this:<\/p>\n <\/p>\n PS> gps *ss | foreach {$_.Name} <\/p>\n <\/p>\n This works, it is not too hard but it always sorta pissed me off that I had to do it this way. Sadly, addressing this never made it above the cut like for V2. Again \u2013 to ship is the choose. I was complaining about this one day and Lee pointed out that if you specify a scalar property (a property that is NOT a collection) for \u2013ExpandProperty \u2013 it gives you exactly what you want.<\/p>\n PS> gps *ss |select -ExpandProperty name <\/p>\n SWEET!<\/p>\n Enjoy! <\/p>\n Jeffrey Snover [MSFT] Most of us are familiar with the traditional use of Select \u2013ExpandProperty <propertyname>. This takes a the value of an incoming object, enumerates its values and outputs each of those values as a single record on the output stream after adding any properties specified by the \u2013PROPERTIES <propertyname[]> parameter. An example will help: PS> gps […]<\/p>\n","protected":false},"author":600,"featured_media":13641,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3511","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powershell"],"acf":[],"blog_post_summary":" Most of us are familiar with the traditional use of Select \u2013ExpandProperty <propertyname>. This takes a the value of an incoming object, enumerates its values and outputs each of those values as a single record on the output stream after adding any properties specified by the \u2013PROPERTIES <propertyname[]> parameter. An example will help: PS> gps […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/posts\/3511","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/users\/600"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/comments?post=3511"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/posts\/3511\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/media\/13641"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/media?parent=3511"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/categories?post=3511"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/tags?post=3511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
—– —- —–
58 kernel32.dll {System.Diagnostics.ProcessModule (kernel32….
58 msvcrt.dll {System.Diagnostics.ProcessModule (msvcrt.dl…
58 KERNELBASE.dll {System.Diagnostics.ProcessModule (KERNELBAS…
72 ntdll.dll {System.Diagnostics.ProcessModule (ntdll.dll…<\/font><\/p>\n
—-
csrss
csrss
lsass
smss<\/font><\/p>\n
csrss
csrss
lsass
smss<\/font><\/p>\n
csrss
csrss
lsass
smss<\/font><\/p>\n
Distinguished Engineer
Visit the Windows PowerShell Team blog at: http:\/\/blogs.msdn.com\/PowerShell<\/a>
Visit the Windows PowerShell ScriptCenter at: http:\/\/www.microsoft.com\/technet\/scriptcenter\/hubs\/msh.mspx<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"