Need to Filter only the KBxxxx article and remaining text separtely on below code result

Question

$Session = New-Object -ComObject "Microsoft.Update.Session"
$Searcher = $Session.CreateUpdateSearcher()

$historyCount = $Searcher.GetTotalHistoryCount()

$a=$Searcher.QueryHistory(0, $historyCount) | Select-Object Title 

$a

Request you to kindly help me to filter only KBxxxx,softwarenamelist for the above command output.

Answer 1

You could try this at the end of your own code :

$arrayKb = @()

foreach($strKb in $a){
    $strKb -match "KB\d{7}"
    $kb = $Matches[0]

    $itemObject = New-Object System.Object
    $itemObject | Add-Member -type NoteProperty -Name "Kb" -Value $kb
    $itemObject | Add-Member -type NoteProperty -Name "Software" -Value $strKb
    $arrayKb += $itemObject
}

$arrayKb

Answer 2

Using this RegEx to capture the KB Number from between the parentheses, and then Calculated Properties to make it neat:

$a = $Searcher.QueryHistory(0, $historyCount) | Select-Object @{Name="KB";Expression={[regex]::match($_.Title,'\(([^\)]+)\)').Groups[1].Value}},@{Name="Title";Expression={$_.Title}}