InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 23:28:41 GMT20http://www.sqlservercentral.com/Forums/Topic1182082-1351-1.aspxThanks all - this helped me keep my application event log clean.[code="other"] bool isClustered = false; ManagementObjectSearcher searcher = new ManagementObjectSearcher( new ManagementScope(string.Format("\\\\{0}\\root\\cimv2", machineName)) , new ObjectQuery("SELECT PartComponent FROM Win32_SystemServices")); foreach (ManagementObject iQueryObj in searcher.Get()) { string name = iQueryObj["PartComponent"].ToString(); if (name.Contains("ClusSvc")) { isClustered = true; } }[/code]Wed, 06 Mar 2013 11:19:17 GMTjgogelhttp://www.sqlservercentral.com/Forums/Topic1182082-1351-1.aspx$s = New-Object Microsoft.SqlServer.Management.Smo.Server("$instancename");$s.IsClustered; # returns $true/$false accordingly.Tue, 04 Oct 2011 09:22:35 GMTmendesmhttp://www.sqlservercentral.com/Forums/Topic1182082-1351-1.aspxAnother option is to look for the cluster service$s = Get-WmiObject -Class Win32_SystemServices -ComputerName $serverif ($s | select PartComponent | where {$_ -like "*ClusSvc*"}) { Write-Output "$server is Clustered" }else { Write-Output "$server is Not clustered" }Fri, 30 Sep 2011 11:21:41 GMTbruce 1565http://www.sqlservercentral.com/Forums/Topic1182082-1351-1.aspxThanks for the ideas. I think I've got a solution that works:$s=Get-WMIObject -query "select * from Win32_ComputerSystem" -ComputerName $server | select nameif ($s -ne $server) { Write-Output "$server is clustered"} else { Write-Output "$server is not clustered"}ColleenThu, 29 Sep 2011 08:34:35 GMTColleen M. Morrowhttp://www.sqlservercentral.com/Forums/Topic1182082-1351-1.aspxthis may be to primitive but you could just use a try catch block to try get-cluster or get-clusternode and have the catch block handle stand-alone servers.Tue, 27 Sep 2011 14:54:44 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic1182082-1351-1.aspxcolleen i know that via TSQL you can get the serverproperty:would that help?[code]SELECT 'IsClustered', SERVERPROPERTY('IsClustered')[/code]Tue, 27 Sep 2011 14:26:14 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1182082-1351-1.aspxI'm in the process of writing a powershell script to inventory my SQL Server environment. In collecting the server information, I'd like to grab the physical hostnames that make up any clustered environments. I know I can use $nodes=get-clusternode -Cluster SERVERNAME |select nameto get the physical servers in the cluster, but if I run that on a non-clustered server, I get an error, obviously. So, can someone recommend a good way to determine whether the SERVERNAME I've connected to is a cluster resource group or a physical stand-alone server?Tue, 27 Sep 2011 14:14:37 GMTColleen M. Morrow