Write array values to Event Viewer?

johnmsch Found a nice module which could help, https://www.powershellgallery.com/packages/ConvertFrom-DataRow/0.9.2 . Run Install-Module -Name ConvertFrom-DataRow and Import-Module -Name ConvertFrom-DataRow. You can now convert your variable using that to a hashtable or an object. I converted it to a hashtable and then you can use:

function hashToArray($hash){
$arr=@();
[string[]] $arr = ($hash | Out-String -Stream) -ne '' | select -Skip 2
return $arr
}

to convert it to a array which you can use in your write-eventlog.

Harm_Veenstra Here's the PS code I've been using for the past 6-7 years for the query:

#
#	SQL statement to find the active primary node
#
$sqlQuery = "Select distinct ags.primary_replica
From sys.dm_hadr_availability_replica_states     ars
Inner Join sys.dm_hadr_availability_group_states  ags On ags.group_id = ars.group_id
Where ars.role_desc = 'PRIMARY'"

#
#	Run the SQL query against the listener
#
$SourceDatabase = "master"
Push-Location
$activeNode = invoke-sqlcmd -ServerInstance $AOListener -Database $SourceDatabase -Query $sqlQuery
Pop-Location

Yes, as I mentioned above, this is such a simple little thing but has been driving me nuts why it doesn't work!