Private/Write-CmPackages.ps1

function Write-CmPackages {
    param (
        [string] $FileName,
        [string] $TableName,
        [string] $SiteCode,
        [int] $NumberOfDays,
        [string] $LogFile,
        [string] $ServerName,
        [bool] $ContinueOnError = $true
    )
    Write-Log -Message "function... Write-CmPackages ****" -LogFile $logfile
    $query = "select distinct PackageID, Name,
    Case
        When (PackageType = 0) Then 'Software Distribution Package'
        When (PackageType = 3) Then 'Driver Package'
        When (PackageType = 4) Then 'Task Sequence Package'
        When (PackageType = 5) Then 'Software Update Package'
        When (PackageType = 6) Then 'Device Settings Package'
        When (PackageType = 7) Then 'Virtual Package'
        When (PackageType = 8) Then 'Application'
        When (PackageType = 257) Then 'OS Image Package'
        When (PackageType = 258) Then 'Boot Image Package'
        When (PackageType = 259) Then 'OS Upgrade Package'
        WHEN (PackageType = 260) Then 'VHD Package'
        End as PkgType,
    PackageType, Description, SourceVersion as Version from dbo.v_Package order by Name"

    $packages = @(Invoke-DbaQuery -SqlInstance $ServerName -Database "CM_$SiteCode" -Query $query -ErrorAction SilentlyContinue)
    if ($null -eq $packages) { return }
    $Fields = @("Name","PkgID","Type","Description","Version")
    $pkgDetails = New-CmDataTable -TableName $tableName -Fields $Fields
    foreach ($pkg in $packages) {
        $row = $pkgDetails.NewRow()
        $row.Name = $pkg.Name
        $row.PkgID = $pkg.PackageID
        $row.Type  = $pkg.PkgType
        $row.Version = $pkg.Version
        $row.Description = $pkg.Description
        $pkgDetails.Rows.Add($row)
    }
    , $pkgDetails | Export-CliXml -Path ($filename)
}