Powershell Query Fix required
Budget: $10 – $30 USD
I need a fix for two fields
Id
InstallationBehavior
Query:
$wsus.GetUpdates() | Select-Object -First 10
helpful content: I can get the data using below but I want to fix it in single query do not want to run it separately.
$results = ForEach ($update in $updates) {$update.InstallationBehavior,$update.id}
$results
OUTPUT of the Query:
UpdateServer : Microsoft.UpdateServices.Internal.BaseApi.UpdateServer
Id : Microsoft.UpdateServices.Administration.UpdateRevisionId
Title : Remote Assistance Connection
Description : This update resolves the "Cannot Establish a Remote Assistance Connection" issue in Windows XP, and is discussed in Microsoft
Knowledge Base (KB) Article 311889. When you try to establish a Remote Assistance session, you might receive an error message, and be
unable to start a Remote Assistance session. Download now to ensure that you can establish a Remote Assistance session successfully.
This item has been updated since it was released in October, 2001. If you have already installed this item, it is not necessary to
reinstall it.
LegacyName : q311889_xp_5081
MsrcSeverity : Unspecified
KnowledgebaseArticles : {311889}
SecurityBulletins : {}
AdditionalInformationUrls : {http://www.download.windowsupdate.com/msdownload/update/v3/static/RTF/en/5081.htm}
ReleaseNotes :
UpdateClassificationTitle : Critical Updates
CompanyTitles : {Microsoft}
ProductTitles : {Windows XP}
ProductFamilyTitles : {Windows}
IsLatestRevision : True
HasEarlierRevision : False
Size : 0
CreationDate : 2/18/2003 8:49:52 PM
ArrivalDate : 6/25/2022 12:50:34 PM
UpdateType : Software
PublicationState : Published
InstallationBehavior : Microsoft.UpdateServices.Administration.InstallationBehavior
UninstallationBehavior : Microsoft.UpdateServices.Administration.InstallationBehavior
IsBeta : False
HasStaleUpdateApprovals : False
IsApproved : False
IsDeclined : False
DefaultPropertiesLanguage :
HasLicenseAgreement : False
RequiresLicenseAgreementAcceptance : False
State : NotNeeded
HasSupersededUpdates : False
IsSuperseded : False
IsWsusInfrastructureUpdate : False
IsEditable : False
UpdateSource : MicrosoftUpdate
Helpful content:
$results = ForEach ($update in $updates) {$update.InstallationBehavior,$update.id}
$results
Id
InstallationBehavior
Query:
$wsus.GetUpdates() | Select-Object -First 10
helpful content: I can get the data using below but I want to fix it in single query do not want to run it separately.
$results = ForEach ($update in $updates) {$update.InstallationBehavior,$update.id}
$results
OUTPUT of the Query:
UpdateServer : Microsoft.UpdateServices.Internal.BaseApi.UpdateServer
Id : Microsoft.UpdateServices.Administration.UpdateRevisionId
Title : Remote Assistance Connection
Description : This update resolves the "Cannot Establish a Remote Assistance Connection" issue in Windows XP, and is discussed in Microsoft
Knowledge Base (KB) Article 311889. When you try to establish a Remote Assistance session, you might receive an error message, and be
unable to start a Remote Assistance session. Download now to ensure that you can establish a Remote Assistance session successfully.
This item has been updated since it was released in October, 2001. If you have already installed this item, it is not necessary to
reinstall it.
LegacyName : q311889_xp_5081
MsrcSeverity : Unspecified
KnowledgebaseArticles : {311889}
SecurityBulletins : {}
AdditionalInformationUrls : {http://www.download.windowsupdate.com/msdownload/update/v3/static/RTF/en/5081.htm}
ReleaseNotes :
UpdateClassificationTitle : Critical Updates
CompanyTitles : {Microsoft}
ProductTitles : {Windows XP}
ProductFamilyTitles : {Windows}
IsLatestRevision : True
HasEarlierRevision : False
Size : 0
CreationDate : 2/18/2003 8:49:52 PM
ArrivalDate : 6/25/2022 12:50:34 PM
UpdateType : Software
PublicationState : Published
InstallationBehavior : Microsoft.UpdateServices.Administration.InstallationBehavior
UninstallationBehavior : Microsoft.UpdateServices.Administration.InstallationBehavior
IsBeta : False
HasStaleUpdateApprovals : False
IsApproved : False
IsDeclined : False
DefaultPropertiesLanguage :
HasLicenseAgreement : False
RequiresLicenseAgreementAcceptance : False
State : NotNeeded
HasSupersededUpdates : False
IsSuperseded : False
IsWsusInfrastructureUpdate : False
IsEditable : False
UpdateSource : MicrosoftUpdate
Helpful content:
$results = ForEach ($update in $updates) {$update.InstallationBehavior,$update.id}
$results