topic Re: PowerCLI script to get Capacity, Provisioned, Overprovisioned memory of Cluster (not datastore cluster) and OS type of a host in VMware PowerCLI Discussions

PowerCLI script to get DatastoreCluster, Datastores and the size info, DataCenter, Clusters

lorried82 — Tue, 24 Feb 2015 16:07:41 GMT

Hello - I am looking to pull the DatastoreClusters and then list the datastores as well with their size (total size, Used space, Free Space, Provisioned, Uncommitted space) and the total number of VM's on that datastore. I would also like to include what datacenter and clusters they are on. Is this possible? I would like to maybe limit what is shown to datastores that are 13% free space or less.

Thanks,

Lorri

Re: PowerCLI script to get DatastoreCluster, Datastores and the size info, DataCenter, Clusters

LucD — Tue, 24 Feb 2015 17:41:40 GMT

Try something like this

foreach($dsc in Get-DatastoreCluster){

Get-Datastore -Location $dsc |

Select @{N='DSC';E={$dsc.Name}},Name,CapacityGB,@{N='FreespaceGB';E={[math]::Round($_.FreespaceGB,2)}},

@{N='ProvisionedSpaceGB';E={

[math]::Round(($_.ExtensionData.Summary.Capacity - $_.Extensiondata.Summary.FreeSpace + $_.ExtensionData.Summary.Uncommitted)/1GB,2)}},

@{N='UnCommittedGB';E={[math]::Round($_.ExtensionData.Summary.Uncommitted/1GB,2)}},

@{N='VM';E={$_.ExtensionData.VM.Count}}

}

Re: PowerCLI script to get DatastoreCluster, Datastores and the size info, DataCenter, Clusters

lorried82 — Tue, 24 Feb 2015 18:00:18 GMT

this looks great - is there a way I can get it to be exported? do I just add Export-Csv z:\newdatastorereport1.csv -NoTypeInformation after the end bracket? will that work?

Also - will this pick up datastores that are not part of a cluster? We have a combination of DatastoreClusters as well as just datastores. So is there a way to pull in the what DataCenter cluster it's in? I am really looking for a way to monitor and manage the datastores - I can't seem to find a good tool.

thanks!

Re: PowerCLI script to get DatastoreCluster, Datastores and the size info, DataCenter, Clusters

LucD — Tue, 24 Feb 2015 19:02:52 GMT

Sure, try it this way

Get-Datastore |

Select @{N='Datacenter';E={$_.Datacenter.Name}},

@{N='DSC';E={Get-DatastoreCluster -Datastore $_ | Select -ExpandProperty Name}},

Name,CapacityGB,@{N='FreespaceGB';E={[math]::Round($_.FreespaceGB,2)}},

@{N='ProvisionedSpaceGB';E={

[math]::Round(($_.ExtensionData.Summary.Capacity - $_.Extensiondata.Summary.FreeSpace + $_.ExtensionData.Summary.Uncommitted)/1GB,2)}},

@{N='UnCommittedGB';E={[math]::Round($_.ExtensionData.Summary.Uncommitted/1GB,2)}},

@{N='VM';E={$_.ExtensionData.VM.Count}} |

Export-Csv report.csv -NoTypeInformation -UseCulture

Re: PowerCLI script to get DatastoreCluster, Datastores and the size info, DataCenter, Clusters

lorried82 — Thu, 26 Feb 2015 15:28:39 GMT

Thanks this is great! One last thing - if I want to only show datastores that are less than 13% free - how do I add that? Also - Is there any way to create totals? Like create a total by DatastoreCluster - total capacity, free space, provisioned, uncommitted, VM count?

Re: PowerCLI script to get DatastoreCluster, Datastores and the size info, DataCenter, Clusters

LucD — Thu, 26 Feb 2015 15:43:52 GMT

To only see datastores that have 13% or less free space, you can add Where-clause

Get-Datastore |

where {($_.FreeSpaceGB/$_.CapacityGB) -le 0.13} |

Select @{N='Datacenter';E={$_.Datacenter.Name}},

@{N='DSC';E={Get-DatastoreCluster -Datastore $_ | Select -ExpandProperty Name}},

Name,CapacityGB,@{N='FreespaceGB';E={[math]::Round($_.FreespaceGB,2)}},

@{N='ProvisionedSpaceGB';E={

[math]::Round(($_.ExtensionData.Summary.Capacity - $_.Extensiondata.Summary.FreeSpace + $_.ExtensionData.Summary.Uncommitted)/1GB,2)}},

@{N='UnCommittedGB';E={[math]::Round($_.ExtensionData.Summary.Uncommitted/1GB,2)}},

@{N='VM';E={$_.ExtensionData.VM.Count}} |

Export-Csv report.csv -NoTypeInformation -UseCulture

How do you want to see these datastorecluster totals ?

It's difficult to have those in the same CSV file.

Can these go to another CSV file ?

Re: PowerCLI script to get DatastoreCluster, Datastores and the size info, DataCenter, Clusters

lorried82 — Thu, 26 Feb 2015 16:53:21 GMT

Yes I think that another cvs would be fine. I need to figure out a way to display this info anyways.

How can I add the free percentage column as well?

Re: PowerCLI script to get DatastoreCluster, Datastores and the size info, DataCenter, Clusters

YuvarajSekar01 — Wed, 11 Oct 2017 11:34:29 GMT

Hi Lucd,

Can you please help me to get it output from the multiple vCenter. I have totally 10vCenter, Please modify the same scripts and let me know,

Thanks in Advance,

Yuvaraj

Re: PowerCLI script to get DatastoreCluster, Datastores and the size info, DataCenter, Clusters

LucD — Wed, 11 Oct 2017 11:39:54 GMT

Try like this.
You need to connect to all vCenters before running the script

$report = foreach($vc in $global:DefaultVIServers){

Get-Datastore -Server $vc |

where {($_.FreeSpaceGB/$_.CapacityGB) -le 0.13} |

Select @{N='vCenter';E={$vc.Name}},

@{N='Datacenter';E={$_.Datacenter.Name}},

@{N='DSC';E={Get-DatastoreCluster -Datastore $_ -Server $vc | Select -ExpandProperty Name}},

Name,CapacityGB,@{N='FreespaceGB';E={[math]::Round($_.FreespaceGB,2)}},

@{N='ProvisionedSpaceGB';E={

[math]::Round(($_.ExtensionData.Summary.Capacity - $_.Extensiondata.Summary.FreeSpace + $_.ExtensionData.Summary.Uncommitted)/1GB,2)}},

@{N='UnCommittedGB';E={[math]::Round($_.ExtensionData.Summary.Uncommitted/1GB,2)}},

@{N='VM';E={$_.ExtensionData.VM.Count}}

}

$report | Export-Csv report.csv -NoTypeInformation -UseCulture

Re: PowerCLI script to get DatastoreCluster, Datastores and the size info, DataCenter, Clusters

pmullen13 — Thu, 04 Jan 2018 18:03:08 GMT

Hi LucD, this is good! Anyway to modify the logic so along with FreespaceGB it can give you percentage (%) free? I'd like to run this on a scheduled basis against each of my vCenters.

Re: PowerCLI script to get DatastoreCluster, Datastores and the size info, DataCenter, Clusters

LucD — Thu, 04 Jan 2018 18:17:06 GMT

Try something like this

$report = foreach($vc in $global:DefaultVIServers){

Get-Datastore -Server $vc |

where {($_.FreeSpaceGB/$_.CapacityGB) -le 0.13} |

Select @{N='vCenter';E={$vc.Name}},

@{N='Datacenter';E={$_.Datacenter.Name}},

@{N='DSC';E={Get-DatastoreCluster -Datastore $_ -Server $vc | Select -ExpandProperty Name}},

Name,CapacityGB,

@{N='FreespaceGB';E={[math]::Round($_.FreespaceGB,2)}},

@{N='Freespace%';E={[math]::Round($_.FreespaceGB/$_.CapacityGB*100,1)}},

@{N='ProvisionedSpaceGB';E={

[math]::Round(($_.ExtensionData.Summary.Capacity - $_.Extensiondata.Summary.FreeSpace + $_.ExtensionData.Summary.Uncommitted)/1GB,2)}},

@{N='UnCommittedGB';E={[math]::Round($_.ExtensionData.Summary.Uncommitted/1GB,2)}},

@{N='VM';E={$_.ExtensionData.VM.Count}}

}

$report | Export-Csv report.csv -NoTypeInformation -UseCulture

Re: PowerCLI script to get DatastoreCluster, Datastores and the size info, DataCenter, Clusters

pmullen13 — Thu, 04 Jan 2018 18:59:34 GMT

Worked like a champ! Thank you LucD!

Re: PowerCLI script to get DatastoreCluster, Datastores and the size info, DataCenter, Clusters

pmullen13 — Wed, 17 Jan 2018 12:45:28 GMT

Hi LucD, you provided me the percentage free which worked great. Thank you again! Anyway we can incorporate the datastore names associated with each datastore cluster?

$report = foreach($vc in $global:DefaultVIServers){

Get-Datastore -Server $vc |

where {($_.FreeSpaceGB/$_.CapacityGB) -le 0.13} |

Select @{N='vCenter';E={$vc.Name}},

@{N='Datacenter';E={$_.Datacenter.Name}},

@{N='DSC';E={Get-DatastoreCluster -Datastore $_ -Server $vc | Select -ExpandProperty Name}},

Name,CapacityGB,

@{N='FreespaceGB';E={[math]::Round($_.FreespaceGB,2)}},

@{N='Freespace%';E={[math]::Round($_.FreespaceGB/$_.CapacityGB*100,1)}},

@{N='ProvisionedSpaceGB';E={

[math]::Round(($_.ExtensionData.Summary.Capacity - $_.Extensiondata.Summary.FreeSpace + $_.ExtensionData.Summary.Uncommitted)/1GB,2)}},

@{N='UnCommittedGB';E={[math]::Round($_.ExtensionData.Summary.Uncommitted/1GB,2)}},

@{N='VM';E={$_.ExtensionData.VM.Count}}

}

$report | Export-Csv report.csv -NoTypeInformation -UseCulture

Re: PowerCLI script to get DatastoreCluster, Datastores and the size info, DataCenter, Clusters

LucD — Wed, 17 Jan 2018 12:49:11 GMT

The datastorename is in the Name column, or do you mean something else?

Re: PowerCLI script to get DatastoreCluster, Datastores and the size info, DataCenter, Clusters

pmullen13 — Wed, 17 Jan 2018 12:58:39 GMT

I'm looking for all the datastore names inside that make up the datastore cluster

Re: PowerCLI script to get DatastoreCluster, Datastores and the size info, DataCenter, Clusters

LucD — Wed, 17 Jan 2018 13:02:33 GMT

You mean like this (in DSCDSNames)?

$report = foreach($vc in $global:DefaultVIServers){

Get-Datastore -Server $vc |

where {($_.FreeSpaceGB/$_.CapacityGB) -le 0.13} |

Select @{N='vCenter';E={$vc.Name}},

@{N='Datacenter';E={$_.Datacenter.Name}},

@{N='DSC';E={Get-DatastoreCluster -Datastore $_ -Server $vc | Select -ExpandProperty Name}},

@{N='DSCDSNames';E={(Get-DatastoreCluster -Datastore $_ -Server $vc | Get-Datastore | Select -ExpandProperty Name) -join '|'}}

Name,CapacityGB,

@{N='FreespaceGB';E={[math]::Round($_.FreespaceGB,2)}},

@{N='Freespace%';E={[math]::Round($_.FreespaceGB/$_.CapacityGB*100,1)}},

@{N='ProvisionedSpaceGB';E={

[math]::Round(($_.ExtensionData.Summary.Capacity - $_.Extensiondata.Summary.FreeSpace + $_.ExtensionData.Summary.Uncommitted)/1GB,2)}},

@{N='UnCommittedGB';E={[math]::Round($_.ExtensionData.Summary.Uncommitted/1GB,2)}},

@{N='VM';E={$_.ExtensionData.VM.Count}}

}

$report | Export-Csv report.csv -NoTypeInformation -UseCulture

Re: PowerCLI script to get DatastoreCluster, Datastores and the size info, DataCenter, Clusters

pmullen13 — Wed, 17 Jan 2018 13:28:12 GMT

Luc, my apologies, the current script does captures that information (DSCDSNames). What if I wanted to connect to 4 or 5 vCenters at one time to pull this information, would that put any sort of load on each of the VC's, and how can I do that? I'd like to run this once versus one at a time on each VC

Re: PowerCLI script to get DatastoreCluster, Datastores and the size info, DataCenter, Clusters

LucD — Wed, 17 Jan 2018 13:33:47 GMT

I added the DSCDSNames properties just a minute ago.

When you connect to multiple vCenters you can run this scripts against all of these vCenters in one run.

Each query places some load on a vCenter, but so does a page refresh in the Web Client.

Besides, most of the actual calculations in that report are done on the station where you run the script.

The script already uses a ForEach loop, where it queries each of the connected vCenters one by one.

So it's not as if all vCenters will receive that same query at the same time.

Re: PowerCLI script to get DatastoreCluster, Datastores and the size info, DataCenter, Clusters

lorried82 — Wed, 17 Jan 2018 14:54:55 GMT

LucD - Is there anyway to actually take this script and change it to pull a certain % of Provisioned space? We want to take a look at datastores that are provisioned over 175%.

Additionally I would like to also query provisioned space over 175% AND freespace % less than 5%

Thanks

Re: PowerCLI script to get DatastoreCluster, Datastores and the size info, DataCenter, Clusters

LucD — Wed, 17 Jan 2018 18:40:54 GMT

You mean something like this?

Get-Datastore |

where {((($_.ExtensionData.Summary.Capacity - $_.Extensiondata.Summary.FreeSpace + $_.ExtensionData.Summary.Uncommitted)/1GB)/$_.CapacityGB) -ge 1.75 -and

($_.FreeSpaceGB/$_.CapacityGB) -le 0.05} |

Select @{N='Datacenter';E={$_.Datacenter.Name}},

@{N='DSC';E={Get-DatastoreCluster -Datastore $_ | Select -ExpandProperty Name}},

Name,CapacityGB,

@{N='FreespaceGB';E={[math]::Round($_.FreespaceGB,2)}},

@{N='ProvisionedSpaceGB';E={

[math]::Round(($_.ExtensionData.Summary.Capacity - $_.Extensiondata.Summary.FreeSpace + $_.ExtensionData.Summary.Uncommitted)/1GB,2)}},

@{N='UnCommittedGB';E={[math]::Round($_.ExtensionData.Summary.Uncommitted/1GB,2)}},

@{N='VM';E={$_.ExtensionData.VM.Count}} |

Export-Csv report.csv -NoTypeInformation -UseCulture