SQL Cluster Node Configuration

import-module failoverclusters
$Nodes = Get-Cluster | Get-ClusterNode
foreach ($Node in $Nodes) 
    {
        $SQLInstance = get-clusterresource -Cluster $Node -ErrorAction SilentlyContinue| 
                        where-object {$_.ResourceType -like "SQL Server"}|   
                        get-clusterparameter VirtualServerName,InstanceName | 
                        group-object ClusterObject | 
                        select-object @{Name = "SQLInstance";  
                        Expression = {[string]::join("\",($_.Group |   
                        select-object -expandproperty Value))}} 
    }
$SQLInstanceUnique = $SQLInstance | select SQLInstance -Unique


Foreach ($Instance in ($SQLInstanceUnique).SQLInstance)
    {
        $Query = "  
        SELECT CONVERT(sysname, SERVERPROPERTY('servername')) as Instance;  

        With ClusterActiveNode as 

        (
        SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') as NodeName, Cast('Active' as varchar(10)) as Active  
        ),
        ClusterNodes as 

        (

        SELECT NodeName FROM sys.dm_os_cluster_nodes
        )

        Select b.nodename, isnull(active,'Passive') as NodeStatus from ClusterNodes as b left join ClusterActiveNode as a  
        on a.NodeName = b.nodename"  


Invoke-Sqlcmd -Query $Query -ServerInstance "$Instance" | select Instance,Nodename,NodeStatus   


}