Windows – LincolnBlog.net

Using PowerShell to Failover Availability Groups and WFC Cluster Nodes

Posted on 05/21/201905/21/2019 by Lincoln Bovee'

This article will show you how to failover an AG to another node and then move the WFC role to the same secondary…

Properly Taking a Cluster Offline for Disk Maintenance

Posted on 08/14/201808/14/2018 by Lincoln Bovee'

I recently needed to replace the older, slower attached disks on our clustered SQL instance offline so as to copy each drive to…

Building an AlwaysOn Availability Group SQL Cluster

Posted on 03/07/201801/17/2019 by Lincoln Bovee'

Here are the steps to build at SQL Server 2017 AlwaysOn Availability Group. We will be using Windows 2016 Standard 64-bit for the…

Resize a VirtualBox Linux VDI Disk under Windows Host

Posted on 12/01/201612/02/2016 by Lincoln Bovee'

Resize a VirtualBox guest Linux VDI Disk under Windows Host The link to GPartEd: GParted ISO download Views – 2208

Migrating Parallels VMs to Oracles’ VirtualBox

Posted on 11/23/201611/23/2016 by Lincoln Bovee'

Below are the steps to migrate a Parallels VM to VirtualBox. This example is done on a MacBook Pro running OS X Sierra…

A new cmdlet: Get-ClusterActiveNode

Posted on 05/27/201606/17/2016 by Lincoln Bovee'

Here is a small cmdlet I wrote to get the currently active node in a Windows cluster:

function Get-ClusterActiveNode
{
	<#
	.SYNOPSIS
		Returns the active server node name for the specified Windows server cluster.
	.DESCRIPTION
		Returns the active server node name for the specified Windows server cluster.
	.EXAMPLE
		PS C:\> Get-ClusterActiveNode -ClusterCName ClusterAlias
    .PARAMETER ClusterName
    	Specifies the cluster name or alias for the Windows cluster to query.
	.OUTPUTS
		The output is displayed to the console.
	#>
	[CmdletBinding(DefaultParameterSetName = 'ClusterName')]
	[OutputType([string], ParameterSetName = 'ClusterName')]
	[OutputType([string])]
	Param
	(
		[Parameter(Mandatory = $true, Position = 0)]
		[string]$ClusterName
	)
	
	try
	{
		Get-WmiObject -Class Win32_ComputerSystem -ComputerName $ClusterName | Select-Object @{ Label = "Active Node"; Expression = { $_.Name } }
	}
	catch
	{
		$exception = $_.Exception
		
		"Error attempting to retrieve cluster node information for cluster name\alias: $ClusterName"
		
		Write-Error "$exception.Message"
		Write-Error $exception.InnerException
		Write-Error $exception.Data
		Write-Error $exception.StackTrace
	}
}

function Get-ClusterActiveNode

{

.SYNOPSIS

Returns the active server node name for the specified Windows server cluster.

.DESCRIPTION

Returns the active server node name for the specified Windows server cluster.

.EXAMPLE

PS C:\> Get-ClusterActiveNode -ClusterCName ClusterAlias

.PARAMETER ClusterName

Specifies the cluster name or alias for the Windows cluster to query.

.OUTPUTS

The output is displayed to the console.

[CmdletBinding(DefaultParameterSetName = 'ClusterName')]

[OutputType([string], ParameterSetName = 'ClusterName')]

[OutputType([string])]

Param

(

[Parameter(Mandatory = $true, Position = 0)]

[string]$ClusterName

)

try

{

Get-WmiObject -Class Win32_ComputerSystem -ComputerName $ClusterName | Select-Object @{ Label = "Active Node"; Expression = { $_.Name } }

}

catch

{

$exception = $_.Exception

"Error attempting to retrieve cluster node information for cluster name\alias: $ClusterName"

Write-Error "$exception.Message"

Write-Error $exception.InnerException

Write-Error $exception.Data

Write-Error $exception.StackTrace

}

Using the cmdlet as displayed…

LincolnBlog.net

…my observations in the world of SQL Server, PowerShell, .Net etc…

Category: Windows

Using PowerShell to Failover Availability Groups and WFC Cluster Nodes

Properly Taking a Cluster Offline for Disk Maintenance

Building an AlwaysOn Availability Group SQL Cluster

Resize a VirtualBox Linux VDI Disk under Windows Host

Migrating Parallels VMs to Oracles’ VirtualBox

A new cmdlet: Get-ClusterActiveNode

Using Get-ClusterNode

Exploring WMI Resources and Tools

Unlocking an AD account with PowerShell