You can use my FolderByPath function.
The script would then look like this
function Get-FolderByPath { <# .SYNOPSIS Retrieve folders by giving a path .DESCRIPTION The function will retrieve a folder by it's path. The path can contain any type of leave (folder or datacenter). .NOTES Author: Luc Dekens .PARAMETER Path The path to the folder. This is a required parameter. .PARAMETER Path The path to the folder. This is a required parameter. .PARAMETER Separator The character that is used to separate the leaves in the path. The default is '/' .EXAMPLE PS> Get-FolderByPath -Path "Folder1/Datacenter/Folder2"
.EXAMPLE
PS> Get-FolderByPath -Path "Folder1>Folder2" -Separator '>'
#>
param(
[CmdletBinding()]
[parameter(Mandatory = $true)]
[System.String[]]${Path},
[char]${Separator} = '/'
)
process {
if ((Get-PowerCLIConfiguration).DefaultVIServerMode -eq "Multiple") {
$vcs = $defaultVIServers
}
else {
$vcs = $defaultVIServers[0]
}
foreach ($vc in $vcs) {
foreach ($strPath in $Path) {
$root = Get-Folder -Name Datacenters -Server $vc
$strPath.Split($Separator) | % {
$root = Get-Inventory -Name $_ -Location $root -Server $vc -NoRecursion
if ((Get-Inventory -Location $root -NoRecursion | Select -ExpandProperty Name) -contains "vm") {
$root = Get-Inventory -Name "vm" -Location $root -Server $vc -NoRecursion
}
}
$root | where {$_ -is [VMware.VimAutomation.ViCore.Impl.V1.Inventory.FolderImpl]}| % {
Get-Folder -Name $_.Name -Location $root.Parent -NoRecursion -Server $vc
}
}
}
}
}
# CSV layout
#
# FolderPath
# DC1/Folder2
# DC1/Folder1/Folder2
#
Import-Csv -Path .\foldernames.csv -UseCulture |
ForEach-Object -Process {
$folder = Get-FolderByPath -Path $_.FolderPath
$vms = Get-VM -Location $folder
New-Object PSObject -Property ([ordered]@{
Folder = $folder.Name
Path = $_.FolderPath
VMCount = $vms.Count
TotalProvisionedSpaceGB = [math]::Round(($vms | Measure-Object -Property ProvisionedSpaceGB -Sum).Sum)
TotalUsedSpaceGB = [math]::Round(($vms | Measure-Object -Property UsedSpaceGB -Sum).Sum)
})
}
