Queries all the servers in the farm and reports the name, version and installation date for 'Microsoft SQL Server 201x RS Addin for SharePoint'

Get-RSAddInVersion.ps1

Add-PSSnapin -Name Microsoft.SharePoint.PowerShell

$servers = @(Get-SPServer | ? Role -ne "Invalid" | SELECT -ExpandProperty Name)

foreach( $server in $servers )
{
    $products = @(Get-CimInstance -ClassName Win32_Product -ComputerName $server -Filter "Name like 'Microsoft SQL Server%RS Addin%'")
                    
    if( $products.Count -gt 0 )
    {
        $products | SELECT PSComputerName, Name, Version, @{N="InstallDate";e={[DateTime]::ParseExact($_.InstallDate, "yyyyMMdd", [System.Globalization.CultureInfo]::InvariantCulture).ToString("MM/dd/yyyy")}}
    }
    else
    {
        [PSCustomObject] @{
            PSComputerName = $server
            Name           = "NOT FOUND"
            Version        = "N/A"
            InstallDate    = "N/A"
        }
    }
}