Here’s one powershell method for how to check the value of an environment variable on multiple servers; $computers = @(“server1”, “server2”, “server3”); foreach ($c in $computers) { Get-WmiObject -ComputerName $c -Class Win32_Environment -Filter “Username = ” AND Name = ‘VAR_NAME'”; } Output will be similar to below… VariableValue Name UserName ————- —- ——– SERVER1 VAR_NAME […]

Here’s just a little tip I picked up from a presentation by Mark Broadbent (retracement on twitter). I’m the guy who wasn’t listening! Mark stressed the importance of enabling the Protection from accidental deletion property in active directory for your Failover Clusters. Here’s how to check this for Computers with Powershell. This string of commands […]

I’ve got another post on the Scripting Guys Blog. This post uses powershell to report on a Windows Failover Cluster. I think it’s pretty cool, let me know what you think!.

Here’s the Powershell version of matching the node number in Cluster.Log files to the actual cluster node names. Essentially log messages like this one… ERROR_CLUSTER_GROUP_MOVING(5908)’ because of ”Cluster Disk’ is owned by node 1, not 2.’ Inspired by this post using cluster.exe. Get-ClusterNode -Cluster ClusterName | SELECT Name, Id, State | Format-Table -Autosize; Output will […]

Here’s a quick powershell snippet to display the Windows groups setup as logins on SQL Server. Import-Module SQLPS -DisableNameChecking -ErrorAction Ignore; Import-Module ActiveDirectory -DisableNameChecking -ErrorAction Ignore; $sql_server = “sql_instance”; $srv = New-Object Microsoft.SqlServer.Management.Smo.Server $sql_server; $srv.Logins | Where-Object {$_.LoginType -eq “WindowsGroup”;}; Output will be similar to below. Name Login Type Created —- ———- ——- NT SERVICE\ClusSvc […]