Create, Clean-up/deduplicate AG-related XML rowsets in the RowsetImportEngine\TextRowset.xml

[PiJoCoder]

These rowsets are not really defined with columns. But also for tbl_availability_groups there is already a rowset defined

• There is one defined for this, so delete this:

    <Rowset name="tbl_availability_groups" enabled="true" identifier="--sys.availability_groups--" type="RowsetImportEngine.TextRowset">
    </Rowset>

• Define this one if needed and make sure there is data collected for it in PSSDIAG/SQL LogScout

    <Rowset name="tbl_dm_hadr_availability_replica_states" enabled="true" identifier="--sys.dm_hadr_availability_replica_states--" type="RowsetImportEngine.TextRowset">
    </Rowset>

- There is another one defined for it, so delete this: 

<Rowset name="tbl_availability_replicas" enabled="true" identifier="--sys.availability_replicas--" type="RowsetImportEngine.TextRowset">
</Rowset>

See related on the data collection side: microsoft/DiagManager#162

[gambit9009]

Table defs....

https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-hadr-availability-replica-states-transact-sql?msclkid=f21c6f28c1cc11ecbe0eaec0f6c3b920&view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-availability-groups-transact-sql?msclkid=04339893c1cd11ec90e7100f700dd282&view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-availability-replicas-transact-sql?view=sql-server-ver15

[PiJoCoder]

Fixed in:
00119a6
f315c00