Hello,
there are some Topics arround, but I want to ask...
I try to export Folders and VM Location on Folder to csv and import them on a differen vcenter.
Export looks ok,
-But import does only create the first Folders and all subfolders are missing.
-The VM move to destination folder is not wokring as well, problem is the subfolder as well.
I found the cheap disaster scripts....
ps scripts
1. export folderstructure
2. export vm Folder information
3. import Folderstructre
4. move vm´s to Folder
1
$sourceVI ="test"
$datacenter = "test"
$creds = Import-Clixml -Path "test"
connect-viserver -server $sourceVI -Credential $creds
filter Get-FolderPath {
$_ | Get-View | % {
$row = "" | select Name, Path
$row.Name = $_.Name
$current = Get-View $_.Parent
$path = $_.Name
do {
$parent = $current
if($parent.Name -ne "vm"){$path = $parent.Name + "\" + $path}
$current = Get-View $current.Parent
} while ($current.Parent -ne $null)
$row.Path = $path
$row
}
}
## Export all folders
$report = @()
$report = get-datacenter $datacenter -Server $sourceVI| Get-folder vm | get-folder | Get-Folderpath
##Replace the top level with vm
foreach ($line in $report) {
$line.Path = ($line.Path).Replace($datacenter + "\","vm\")
}
$report | Export-Csv "C:\folders\04-$($datacenter)-Folders-with-FolderPath.csv" -NoTypeInformation
Disconnect-VIServer "*" -Confirm:$False
2
$sourceVI ="test"
$datacenter = "test"
$creds = Import-Clixml -Path "test"
connect-viserver -server $sourceVI -Credential $creds
filter Get-FolderPath {
$_ | Get-View | % {
$row = "" | select Name, Path
$row.Name = $_.Name
$current = Get-View $_.Parent
$path = $_.Name
do {
$parent = $current
if($parent.Name -ne "vm"){$path = $parent.Name + "\" + $path}
$current = Get-View $current.Parent
} while ($current.Parent -ne $null)
$row.Path = $path
$row
}
}
##Export all VM locations
$report = @()
$report = get-datacenter $datacenter -Server $sourceVI| get-vm | Get-Folderpath
$report | Export-Csv "\folders\05-$($datacenter)-vms-with-FolderPath.csv" -NoTypeInformation
Disconnect-VIServer "*" -Confirm:$False
3
$creds = Import-Clixml -Path "test
$destVI = "test"
$datacenter = "test"
connect-viserver -server $destVI -Credential $creds
##IMPORT FOLDERS
$vmfolder = Import-Csv "folders\04-$($datacenter)-Folders-with-FolderPath.csv" | Sort-Object -Property Path
foreach($folder in $VMfolder){
$key = @()
$key = ($folder.Path -split "\\")[-2]
if ($key -eq "vm") {
get-datacenter $datacenter -Server $destVI | get-folder vm | New-Folder -Name $folder.Name
} else {
get-datacenter $datacenter -Server $destVI | get-folder vm | get-folder "$key" | New-Folder -Name $folder.Name
}
}
Disconnect-VIServer "*" -confirm:$false
4
$sourceVI ="test"
$datacenter = "test"
$creds = Import-Clixml -Path "test"
connect-viserver -server $sourceVI -Credential $creds
# move the vm's to correct location
$VMfolder = @()
$VMfolder = import-csv "folders\04-$($datacenter)-vms-with-FolderPath.csv" | Sort-Object -Property Path
foreach($guest in $VMfolder){
$key = @()
$key = Split-Path $guest.Path | split-path -leaf
if ($key -eq $datacenter) {
Write-Host "Root folder $guest.path"
##
Move-VM (Get-VM $guest.Name) -Destination "vm"
}
else
{
Move-VM (Get-VM $guest.Name) -Destination (Get-folder $key)
}
}
Disconnect-VIServer "*" -Confirm:$False
VCP4,VCP5,VCP6,VCP7,VCP8
