Forum Discussion
Mike_Moniz
3 years agoProfessor
I don't know a ton about SQL but peeking at the DataSource code for Microsoft_SQLServer_AlwaysOnAvailabilityGroups it seems to be running the below SQL statement to get a list of instances. Might want to run that to see what it outputs, if anything, and why.
SELECT @@servicename AS instanceName,
ag.group_id ,
ags.primary_replica ,
ag.name ,
ag.health_check_timeout ,
ag.automated_backup_preference
FROM sys.availability_groups ag
INNER JOIN sys.dm_hadr_availability_group_states ags ON ags.group_id = ag.group_id
Related Content
- 2 years ago