# Filter Property Value

**URL:** <https://forums.powershell.org/t/filter-property-value/7714>\
**Category:** PowerShell Help\
**Created:** [December 14, 2016, 8:35am UTC](https://forums.powershell.org/t/filter-property-value/7714 "2016-12-14T08:35:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![tthomas06outlook-com](https://avatars.discourse-cdn.com/v4/letter/t/85f322/32.png) [@tthomas06outlook-com](https://forums.powershell.org/u/tthomas06outlook-com)\
**Post date:** [December 14, 2016, 8:35am UTC](https://forums.powershell.org/t/filter-property-value/7714/1 "2016-12-14T08:35:22Z")

</div>

Hi Everyone,

I am trying to get the list of windows updates from the WSUS server using the following PowerShell command. I get the result and I can see the first column as “Title”.

Get-WsusUpdate -Approval Unapproved | Select-Object -First 10

But, when I try to filter the output by adding “-Property Title, Classification” to the above line, it will not give me the Title.

Get-WsusUpdate -Approval Unapproved | Select-Object -First 10 -Property Title, Classification

Is it because the string is too long? Can you please help me?

Thanks,  
Tijo.

---

<div class="post-metadata">

**Author:** ![skalizar](https://avatars.discourse-cdn.com/v4/letter/s/ecc23a/32.png) [@skalizar](https://forums.powershell.org/u/skalizar)\
**Post date:** [December 14, 2016, 9:04am UTC](https://forums.powershell.org/t/filter-property-value/7714/2 "2016-12-14T09:04:19Z")

</div>

Did a quick search and found [this.](https://www.reddit.com/r/PowerShell/comments/2msg7z/trouble_with_getwsusupdate/)

It appears the title is part of the update object, so you need to reference it like this:

select @{Name=“Title”;Expression={$\_.update.title}}

---

<div class="post-metadata">

**Author:** ![daniel-krebs](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.powershell.org/daniel-krebs/32/484_2.png) [@daniel-krebs](https://forums.powershell.org/u/daniel-krebs)\
**Post date:** [December 14, 2016, 9:21am UTC](https://forums.powershell.org/t/filter-property-value/7714/3 "2016-12-14T09:21:53Z")

</div>

Hi,

The Title property column is not a member of the base object but a child object.

```
TypeName: Microsoft.UpdateServices.Commands.WsusUpdate

Name MemberType
---- ----------
Approved Property
Classification Property
ComputersInstalledOrNotApplicable Property
ComputersNeedingThisUpdate Property
ComputersWithErrors Property
ComputersWithNoStatus Property
InstalledOrNotApplicablePercentage Property
LanguagesSupported Property
LicenseAgreement Property
MayRequestUserInput Property
MsrcNumbers Property
MustBeInstalledExclusively Property
Products Property
Removable Property
RestartBehavior Property
Update Property
UpdateId Property
UpdatesSupersededByThisUpdate Property
UpdatesSupersedingThisUpdate Property
```

You can verify that yourself with below:

```
$list = Get-WsusUpdate -Approval Unapproved
$list[0] | Get-Member -MemberType Property
```

The Title property is actually hidden inside the object property “Update”.

```
$list = Get-WsusUpdate -Approval Unapproved
$list[0].Update | Get-Member -MemberType Property
```

```
TypeName: Microsoft.UpdateServices.Internal.BaseApi.Update

Name MemberType
---- ----------
AdditionalInformationUrls Property
ArrivalDate Property
CompanyTitles Property
CreationDate Property
DefaultPropertiesLanguage Property
Description Property
HasEarlierRevision Property
HasLicenseAgreement Property
HasStaleUpdateApprovals Property
HasSupersededUpdates Property
Id Property
InstallationBehavior Property
IsApproved Property
IsBeta Property
IsDeclined Property
IsEditable Property
IsLatestRevision Property
IsSuperseded Property
IsWsusInfrastructureUpdate Property
KnowledgebaseArticles Property
LegacyName Property
MsrcSeverity Property
ProductFamilyTitles Property
ProductTitles Property
PublicationState Property
ReleaseNotes Property
RequiresLicenseAgreementAcceptance Property
SecurityBulletins Property
Size Property
State Property
Title Property
UninstallationBehavior Property
UpdateClassificationTitle Property
UpdateServer Property
UpdateSource Property
UpdateType Property
```

The PowerShell engine is doing a bit of magic for you because the authors of the UpdateServices module have specified a custom format view to allow for human consumption.

If you open the custom format file “C:\windows\system32\windowspowershell\v1.0\Modules\UpdateServices\WsusCmdlets.format.ps1xml” of the UpdateServices module and search for “Microsoft.UpdateServices.Commands.WsusUpdate” you can find the calculated property.

To get the same result with only selected properties you’ll need to specify a calculated property for Title instead.

```
Get-WsusUpdate -Approval Unapproved | Select-Object -First 10 -Property @{Name='Title';Expression={$_.Update.Title}}, Classification
```

I hope above helps. Apologies for my long answer.

Best,  
Daniel

---

<div class="post-metadata">

**Author:** ![tthomas06outlook-com](https://avatars.discourse-cdn.com/v4/letter/t/85f322/32.png) [@tthomas06outlook-com](https://forums.powershell.org/u/tthomas06outlook-com)\
**Post date:** [December 14, 2016, 10:16am UTC](https://forums.powershell.org/t/filter-property-value/7714/4 "2016-12-14T10:16:51Z")

</div>

That worked. Thank you Ron & Daniel for the quick response. Special thanks to Daniel for the explanation.

Thank you,  
Tijo.

---

<div class="post-metadata">

**Author:** ![dotnVo](https://avatars.discourse-cdn.com/v4/letter/d/4af34b/32.png) [@dotnVo](https://forums.powershell.org/u/dotnVo)\
**Post date:** [May 16, 2024, 8:39pm UTC](https://forums.powershell.org/t/filter-property-value/7714/5 "2024-05-16T20:39:42Z")

</div>

Closed on May 16, 2024, 8:39pm UTC