Skip to content

Instantly share code, notes, and snippets.

@andikrueger
Created January 8, 2019 15:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save andikrueger/fe000c3cf8b5e09322a18cb64f006b33 to your computer and use it in GitHub Desktop.
Save andikrueger/fe000c3cf8b5e09322a18cb64f006b33 to your computer and use it in GitHub Desktop.
Creating SQL Server Alias based on a hash table with iteration
$ConfigurationData.NonNodeData.SqlServerAlias.Keys | ForEach-Object -Process {
SqlAlias $ConfigurationData.NonNodeData.SqlServerAlias[$_].Name
{
Name = $ConfigurationData.NonNodeData.SqlServerAlias[$_].Name
ServerName = $ConfigurationData.NonNodeData.SqlServerAlias[$_].ServerName
Protocol = $ConfigurationData.NonNodeData.SqlServerAlias[$_].Protocol
UseDynamicTcpPort = $ConfigurationData.NonNodeData.SqlServerAlias[$_].UseDynamicTcpPort
TcpPort = $ConfigurationData.NonNodeData.SqlServerAlias[$_].TcpPort
Ensure = 'Present'
PsDscRunAsCredential = $SpSetupAccount
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment