Get-MSRCtoZDIwithDate.ps1

#Requires -Module MsrcSecurityUpdates

(Get-MSRCCvrfDocument -ID "$((Get-Date).ToString('yyyy-MMM',[System.Globalization.CultureInfo]'en-US'))").Vulnerability |
Foreach-Object {
 $v = $_

 $Disclosed = $Exploited = $null

 $Disclosed = ([regex]'Publicly\sDisclosed:(?<D>(Yes|No));').Match("$(($v.Threats | Where-Object { $_.Type -eq 1}).Description.Value)") |
 Select-Object -ExpandProperty Groups| Select-Object -Last 1 -ExpandProperty Value
 $Exploited = ([regex]'Exploited:(?<E>(Yes|No));').Match("$(($v.Threats | Where-Object { $_.Type -eq 1}).Description.Value)") |
 Select-Object -ExpandProperty Groups| Select-Object -Last 1 -ExpandProperty Value

 [PSCustomObject]@{
  CVEID = $v.CVE
  Tag = $($v.Notes | Where-Object { $_.Type -eq 7}).Value
  CNA = $($v.Notes | Where-Object {$_.Type -eq 8}).Value
  Title = $v.Title.Value
  Date = $($v.RevisionHistory | Select-Object -First 1 -ExpandProperty Date)
  Revision = $($v.RevisionHistory | Select-Object -First 1 -ExpandProperty Number)
  Severity = $( ($v.Threats | Where-Object { $_.Type -eq 3 }).Description | Select-Object -ExpandProperty Value -ErrorAction SilentlyContinue | Sort-Object -Unique)
  CVSS = '{0:N1}' -f $($v.CVSSScoreSets.BaseScore | Sort-Object -Unique | ForEach-Object { [double]$_} | Sort-Object -Descending | Select-Object -First 1)
  Public = $Disclosed
  Exploited = $Exploited
  Type = $( ($v.Threats | Where-Object { $_.Type -eq 0 }).Description | Select-Object -ExpandProperty Value -ErrorAction SilentlyContinue | Sort-Object -Unique)
 }
} | Where-Object { [datetime]$_.Date -ge ((Get-Date).AddDays(-5)) } |
Select-Object -Property CVEID,Title,Severity,CVSS,Public,Exploited,Type,Date |
Out-GridView