Hello
I have created the below script, my issue is that the result like this
and I would like to have the output in this order:
- Name
- Type
- path
- FreeSpacePercent
- FreeSpaceGB
Sorry missed to add the script 
# Get all datastores in the vCenter Datacenters
$datastores = Get-Datastore -Location (Get-Datacenter)
# Create an empty array to hold the datastore information
$datastoreInfo = @()
# Loop through each datastore
foreach ($datastore in $datastores) {
# Get the datastore type, host or network path, available space in GB and %
$type = $datastore.ExtensionData.Info.GetType().Name
$path = $datastore.ExtensionData.Info.Url
$freeSpaceGB = "{0:N2}" -f ($datastore.FreeSpaceGB)
if ($datastore.CapacityGB -eq 0) {
$freeSpacePercent = "N/A"
} else {
$freeSpacePercent = "{0:N2}" -f ($datastore.FreeSpaceGB / $datastore.CapacityGB * 100)
}
# Add the information to the array
$datastoreInfo += New-Object PSObject -Property @{
Name = $datastore.Name
Type = $type
Path = $path
FreeSpaceGB = $freeSpaceGB
FreeSpacePercent = $freeSpacePercent
}
}
$PreContent = "<style>
table {
border-collapse: collapse;
with: 100%;
}
th, td {
padding: 8px;
text-align: left;
border-bottom: 1px solid #ddd;
}
tr:hover {
background-color: coral;
}
</style>"
$PostContent = "<br>"
$datastoreInfo | ConvertTo-Html -Fragment -PreContent $PreContent -PostContent $PostContent | Out-File "datastore_info.html"
$datastoreInfo | Export-Csv -Path .\datastore_info.csv -Append -NoTypeInformation -Force
# Disconnect from vCenter server
Disconnect-VIServer * -Force -Confirm:$false
