Server Management Suite

 View Only
  • 1.  How to Find SQL cluster server names from SQL DB ?

    Posted May 16, 2014 04:03 AM


  • 2.  RE: How to Find SQL cluster server names from SQL DB ?

    Posted May 24, 2014 06:06 AM

    If the cluster names are already in the database, then simply querying the relevant table will give you this information.

    If, however, your question is actually how to gather sql cluster names so that they can be put into a database table, then you will most likely have to use custom inventory to interrogate either wmi or the registry on each node within the cluster.  This data will then allow you to map cluster names with their machine nodes via a sql query.



  • 3.  RE: How to Find SQL cluster server names from SQL DB ?

    Posted May 27, 2014 01:47 PM

    Could you just use this T-SQL query?

    SELECT * FROM fn_virtualservernodes() 



  • 4.  RE: How to Find SQL cluster server names from SQL DB ?

    Posted May 27, 2014 03:20 PM

    This article contains a number of cluster queries:- 

    http://www.sanssql.com/2011/02/t-sql-queries-to-find-sql-server.html



  • 5.  RE: How to Find SQL cluster server names from SQL DB ?

    Posted Jul 02, 2014 06:04 AM

    How to Retrieve Machines name in particular AD group(SALES-XX-XXXXX-) through SMP ?



  • 6.  RE: How to Find SQL cluster server names from SQL DB ?
    Best Answer

    Broadcom Employee
    Posted Jul 02, 2014 08:42 AM

    Hi,

    Seems like this is what you need https://www-secure.symantec.com/connect/forums/report-computer-ou

    Thanks,

    IP.