Get replication articles from the distribution database.

Get-DbaReplicationArticle.ps1

function Get-DbaReplicationArticle {
    [CmdletBinding()]
    param(
        [Parameter(Mandatory=$true)]
        [string]$SqlInstance,
        
        [Parameter(Mandatory=$true)]
        [string]$Database
    )
    
    Import-Module SqlServer
    
    $query = @"
SELECT
    publisher_db AS DatabaseName,
    publication AS PublicationName,
    article AS ArticleName,
    source_owner AS SchemaName,
    source_object AS ObjectName
FROM
    msarticles
WHERE
    publisher_db = '$Database'
"@
    
    $results = Invoke-DbaQuery -SqlInstance $SqlInstance -Database 'distribution' -Query $query
    if ($results.Count -eq 0) {
        return @()
    }
    
    $articles = foreach ($result in $results) {
        [PSCustomObject]@{
            DatabaseName = $result.DatabaseName
            PublicationName = $result.PublicationName
            ArticleName = $result.ArticleName
            SchemaName = $result.SchemaName
            ObjectName = $result.ObjectName
        }
    }
    
    return $articles
}