Get the host cluster name with respective datastores name.

[Vel_VMware]

Hi,

I have list datastores Name, I need to get the respective hosts cluster name in powercli. Please help me.

 

Thanks

[LucD]

You didn't specify in which format that "list datastores Name" is provided, but when I assume it is a CSV with a column named DSName, you could do

Import-Csv -Path .\datastores.csv -UseCulture |
Foreach-Object -Process {
   Get-Datastore -Name $_.DSName |
   Select Name,
     @{N='Cluster';E={(Get-VMHost -Datastore $_ | Get-Cluster).Name}}
}

 

[Vel_VMware]

Getting error as attached.

 

[LucD]

Where is that Disconnect-VIServer coming from?
That was not in the code I posted.
The code assumes you are connected to the vCenter.

[Vel_VMware]

Disconnect-VIServer is added my self. Script is working now. But, When I try to export data in CSV, getting  cluster detail for only one datastore only. otherwise on screen output shows for all datastore. 

[LucD]

That probably means you placed the Export-Csv inside the Forwach-Object loop, hence overwriting the CSV each time.
You have to place the Export-Csv outside the Foreach-Object code block

[Vel_VMware]

Now, I have kept my Export-CSV in out of foreach, but still I am getting cluster detail only for last datastore in the list.

[LucD]

Can you show the code you are using?

[Vel_VMware]

Unable to copy and paste the code here due to limited access, just providing the screenshot of the code.

 

 

[LucD]

You are overwriting the variable $p inside the loop each time.

[Vel_VMware]

How can I stop overwriting $p in the script.

[LucD]

Perhaps you could use the code I give and not change it?

Import-Csv -Path .\datastores.csv -UseCulture |
Foreach-Object -Process {
   Get-Datastore -Name $_.DSName |
   Select Name,
     @{N='Cluster';E={(Get-VMHost -Datastore $_ | Get-Cluster).Name}}
} | Export-Csv -Path .\report.csv -NoTypeInformation -UseCulture

[Vel_VMware]

Hi, 

I tried with your code and getting below error.

 

 

 

[Vel_VMware]

I found the issue and fixed it.. 

It works now.. 

Thank you LucD