Topology/Clustering on VMM

/* Clustering */
SELECT DISTINCT
        tbl_ADHC_Host.computername AS from_device,
        'is part of cluster' AS rel_type,
        tbl_ADHC_HostCluster.name AS to_device

    FROM tbl_WLC_VObject
    LEFT JOIN tbl_ADHC_Host
        ON tbl_ADHC_Host.hostid = tbl_WLC_VObject.hostid
    LEFT JOIN tbl_ADHC_HostCluster
        ON tbl_ADHC_HostCluster.clusterid = tbl_ADHC_Host.HostClusterID
    WHERE tbl_ADHC_Host.computername IS NOT NULL
        AND tbl_ADHC_HostCluster.name IS NOT NULL

UNION

/* Topology */
SELECT DISTINCT
        COALESCE(tbl_WLC_VMInstance.computername, tbl_WLC_VObject.name) AS from_device,
        'is running on' AS rel_type,
        COALESCE(tbl_ADHC_HostCluster.name, tbl_ADHC_Host.computername) AS to_device

    FROM ( SELECT
                tbl_WLC_VObject.objectid,
                ROW_NUMBER() OVER(PARTITION BY COALESCE(tbl_WLC_VMInstance.computername, tbl_WLC_VObject.name) ORDER BY tbl_WLC_VObject.creationtime DESC) AS RowNum
            FROM tbl_WLC_VObject
            LEFT JOIN tbl_WLC_VMInstance
                ON tbl_WLC_VMInstance.objectid = tbl_WLC_VObject.objectid
        ) newestDevices

    JOIN tbl_WLC_VObject
        ON tbl_WLC_VObject.objectid = newestDevices.objectid
        AND newestDevices.RowNum = 1
    LEFT JOIN tbl_ADHC_Host
        ON tbl_ADHC_Host.hostid = tbl_WLC_VObject.hostid
    LEFT JOIN tbl_ADHC_HostCluster
        ON tbl_ADHC_HostCluster.clusterid = tbl_ADHC_Host.HostClusterID
    LEFT JOIN tbl_WLC_VMInstance
        ON tbl_WLC_VMInstance.objectid = tbl_WLC_VObject.objectid
    WHERE tbl_WLC_VObject.objecttype = 1
        AND COALESCE(tbl_ADHC_HostCluster.name, tbl_ADHC_Host.computername) IS NOT NULL