Powershell script to convert CSV to Bolt Inventory

bolt_inventory.ps1

$user = Read-Host -Prompt 'Input username'
$password = Read-Host -Prompt 'Input password'
$csv_path = Read-Host -Prompt 'Input path to inventory CSV'

$yaml_module = "powershell-yaml"

if ($null -eq (Get-InstalledModule -Name $yaml_module -ErrorAction SilentlyContinue)) {
  Install-Module $yaml_module
}

$csv_data = Get-Content $csv_path | ConvertFrom-Csv

[System.Collections.ArrayList]$WindowsList = @()
[System.Collections.ArrayList]$LinuxList = @()

foreach ($target in $csv_data) {
  $server = $target.server
  if ($target.os -eq "windows") {
    $WindowsList.Add($server) | Out-Null
  }
  else {
    $LinuxList.Add($server) | Out-Null
  }
}

$yaml = ConvertTo-Yaml @{"groups" = @(
    @{"name"    = "linux";
      "targets" = $LinuxList;
      "config"  = @{"transport" = "ssh";
        "ssh"                  = @{"host-key-check" = $false; "user" = $user; "password" = $password; "port" = 22 } 
      } 
    },
    @{"name"    = "windows";
      "targets" = $WindowsList;
      "config"  = @{"transport" = "winrm";
        "winrm"                = @{ "user" = $user; "password" = $password; "port" = 5985 } 
      } 
    } 
  ) 
}

Set-Content -Path .\inventory.yaml -Value $yaml