Function New-OSBuildVersionTable returns System.Object[] for OSversion 24H2

[arts-abhi]

It looks like the function New-OSBuildVersionTable returns System.Object[] for OSVersion 24H2. Possibly due to 2 rows for Version 24H2.
I tried to fix it by omitting duplicate rows but it doesn't work in the runbook. Please help in rectifying it.

Thanks!

Runbook: [Update Software_Updates_Reporting_Summarizer.ps1]

Function: New-OSBuildVersionTable

[SMSAgentSoftware]

I'm not seeing this issue myself. The output of New-OSBuildVersionTable is returning this:

[arts-abhi]

@SMSAgentSoftware Thanks for the quick response Trevor.
Here is what I’m getting for 24H2 version in SU_OSUpdateHistory_CL table:

[arts-abhi]

@SMSAgentSoftware There is an additional issue in SU_OSSupportMatrix_CL table, its not able to get the correct startdate, enddate and thus the whole data is becoming irrelvant.

These are the errors from runbook execution:

Exception calling "ParseExact" with "3" argument(s): "String was not recognized as a valid DateTime." At line:181 char:25 + ... $StartDateDT = [datetime]::ParseExact($StartDate, 'yyyy-M ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [], MethodInvocationException + FullyQualifiedErrorId : FormatException

Exception calling "ParseExact" with "3" argument(s): "String was not recognized as a valid DateTime." At line:184 char:29 + ... $EndDateDT = [datetime]::ParseExact($EndDate, 'yyyy-MM-dd ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [], MethodInvocationException + FullyQualifiedErrorId : FormatException

Cannot convert null to type "System.DateTime". At line:185 char:29 + ... $SupportDaysRemaining = ([datetime]$EndDateDT - (Get-Date ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidArgument: (:) [], RuntimeException + FullyQualifiedErrorId : nullToObjectInvalidCast

Cannot convert null to type "System.DateTime". At line:191 char:29 + ... $SupportPeriodInDays = ([datetime]$EndDateDT - [datetime] ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidArgument: (:) [], RuntimeException + FullyQualifiedErrorId : nullToObjectInvalidCast

Get-Date : The input object cannot be bound to any parameters for the command either because the command does not take pipeline input or the input and its properties do not match any of the parameters that take pipeline input. At line:192 char:63 + ... rtDateFinal = ($StartDateDT | Get-Date -Format "yyyy MMMM dd").ToStri ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidArgument: (:) [Get-Date], ParameterBindingException + FullyQualifiedErrorId : InputObjectNotBound,Microsoft.PowerShell.Commands.GetDateCommand

You cannot call a method on a null-valued expression. At line:192 char:29 + ... $StartDateFinal = ($StartDateDT | Get-Date -Format "yyyy ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull

Get-Date : The input object cannot be bound to any parameters for the command either because the command does not take pipeline input or the input and its properties do not match any of the parameters that take pipeline input. At line:193 char:59 + ... $EndDateFinal = ($EndDateDT | Get-Date -Format "yyyy MMMM dd").ToStri ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidArgument: (:) [Get-Date], ParameterBindingException + FullyQualifiedErrorId : InputObjectNotBound,Microsoft.PowerShell.Commands.GetDateCommand

You cannot call a method on a null-valued expression. At line:193 char:29 + ... $EndDateFinal = ($EndDateDT | Get-Date -Format "yyyy MMMM ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull

Exception calling "ParseExact" with "3" argument(s): "String was not recognized as a valid DateTime." At line:181 char:25 + ... $StartDateDT = [datetime]::ParseExact($StartDate, 'yyyy-M ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [], MethodInvocationException + FullyQualifiedErrorId : FormatException

Exception calling "ParseExact" with "3" argument(s): "String was not recognized as a valid DateTime." At line:184 char:29 + ... $EndDateDT = [datetime]::ParseExact($EndDate, 'yyyy-MM-dd ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [], MethodInvocationException + FullyQualifiedErrorId : FormatException

Cannot convert null to type "System.DateTime". At line:185 char:29 + ... $SupportDaysRemaining = ([datetime]$EndDateDT - (Get-Date ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidArgument: (:) [], RuntimeException + FullyQualifiedErrorId : nullToObjectInvalidCast

Cannot convert null to type "System.DateTime". At line:191 char:29 + ... $SupportPeriodInDays = ([datetime]$EndDateDT - [datetime] ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidArgument: (:) [], RuntimeException + FullyQualifiedErrorId : nullToObjectInvalidCast