Post reply

Finding cluster nodes (powershell or sql)

  • September 17, 2013 at 3:23 am

    #282543

    Hi,

    I am looking to find cluster and it's nodes, actually we have bulk of servers and we don't know which server is running under which cluster. i want to find out all servers. basically we don't know when cluster server will change. please can any one help me out from this situation.??

    it would be greatful wheather script poershell or sql script.

    Thanks

  • September 17, 2013 at 2:05 pm

    #1650915

    select serverproperty('computernamephysicalnetbios')

    above command when you will run in sql server it will tell currently in which node cluster is running.

  • September 19, 2013 at 11:28 am

    #1651606

    Select serverproperty('computernamephysicalnetbios') as [currentnodename]

    SELECT * FROM fn_virtualservernodes() –Gives the nodes list

    Select * from sys.dm_os_cluster_nodes

    Select * from fn_servershareddrives()

    Select * from sys.dm_io_cluster_shared_drives

  • September 20, 2013 at 2:09 am

    #1651798

    Cheers,

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply