Replication Topology Report Showing Wrong Results

[asavioliMSFT]

The replication topology report is showing wrong results on some situations. In the scenario below, it lists some subscriptions that don’t exist for the given publisher because of a Cartesian join, showing combinations that don't exist

Confirmed the issue is in the query used by the report design. We see the same cartesian join if we run it directly on SSMS

SqlNexus/NexusReports/Replication_Topology_C.rdl

Line 20 in b8b78f3

<CommandText>DECLARE @DistributionSQLVersion NVARCHAR(71);