topic Re: Get datastore details in VMware PowerCLI Discussions

Get datastore details

lElOUCHE_79 — Thu, 19 Jan 2023 14:42:18 GMT

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

Re: Get datastore details

LucD — Thu, 19 Jan 2023 14:53:38 GMT

There doesn't seem to be any code in your post.

In any case, if you want to keep the properties in the order you define them in the code, one way of doing that is to use the [ordered]@ construct

New-Object -TypeName PSObject -Property ([ordered]@{ Prop1 = 'value' Prop2 = 'value' Prop3 = 'value' })

Re: Get datastore details

lElOUCHE_79 — Thu, 19 Jan 2023 15:01:12 GMT

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

Re: Get datastore details

LucD — Thu, 19 Jan 2023 18:34:44 GMT

Like I said earlier, use the [ordered] construct.

# Add the information to the array $datastoreInfo += New-Object PSObject -Property ([ordered]@{ Name = $datastore.Name Type = $type Path = $path FreeSpaceGB = $freeSpaceGB FreeSpacePercent = $freeSpacePercent })