finding the Active node in Failover Cluster

I am looking at the Windows 2012 Server and sql server 2012 is installed on this server..and I am confused about which node is active? when I look at the Failover Cluster manager,I see the Cluster name and Current host server there ;see attached file

there are two nodes;


Cluster Name: SQL12CLU
Current Host name: SQL12CLUB

but when I look at the Roles in Failover Cluster management, SQL12CLUA seems to be owner node so why are they different? I think, the server in the Owner Role should be Active node,which is SQL12CLUA but on the other hand, I see the SQL12CLUB as a Current host name..
Teoman SahinAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

You could logon to one of the cluster nodes and open a command prompt (cmd.exe) with administrative permissions.
Via the command:
cluster group

Open in new window

you should be able to see which host is running which cluster group.
Sarat chsystem adminCommented:
As told by Zalazar you can use cluster group command

Cluster group /Status --> Displays Cluster group and its status

And coming to the screenshots which you attached, do u see the same in both the nodes?
Teoman SahinAuthor Commented:
thanks but  this command is not working on windows 2012 cluster
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Sarat chsystem adminCommented:
My Bad.. With win 2012 you may have to Use Wndows powershell . Below Articles for your reference

As long as you play around with Get Commands you wont be doing any changes

By using Set commands you will be making changes !!!!!!!

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
To make the "cluster.exe" command available you could install the additional feature called "Failover Cluster Command Interface".
Altough I still favor the cluster.exe command as it's more direct, you can also use the command "Get-ClusterGroup" from PowerShell as mentioned by srikanth chantati.
Ryan McCauleyEnterprise Analytics ManagerCommented:
Can you connect to the SQL Server instance using SQL Management Studio? If so, then the following query will show you on which node the SQL instance current resides:

select serverproperty('ComputerNamePhysicalNetBIOS')

Open in new window

Doing a "SELECT @@SERVERNAME" will show you the cluster instance name, but not the physical host - the query above will tell you which node the instance currently lives on.
Teoman SahinAuthor Commented:
I executed this query on SQL12CLUA

it returned the same node name as a result = SQL12CLUA

I executed this query on SQL12CLUB

it returned the same node name as A result= SQL12CLUB

I guess this query did not return the active node name properly
Could you try to install the feature "Failover Cluster Command Interface".
and then execute the "cluster group" command.
Teoman SahinAuthor Commented:
where ı can find the Failover Cluster Command Interface?
Open Server Manager, select Local Server
Click Manage |Add Roles and Features
Click Next until Features
Selct the Failover Cluster Command Interface (please see the screenshot below)
ClusterActiveNode_2.pngClick Next and Install
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2012

From novice to tech pro — start learning today.