powercli script with options menu

[DJ_NEIL]

Hi People, im new in powercli!

Is possible in powercli, create a script where appears a menu with options to choose like a what vcenter to connect, choose cluster in this vCenter.... and with this data, execute a task

For example, to choose a vCenter, in this vCenter  choose a cluster, in that cluster that shows me the DRS rules..

It's possible?

How can I do it?

Thanks in advanced

Regards

[LucD]

You can do something like this

$data = @'

Name

VC1

VC2

VC3

'@

$selectedVC = $data | ConvertFrom-Csv | select Name |

Out-GridView -OutputMode Single

Write-Host "You selected $($selectedVC.Name)"

[DJ_NEIL]

Thanks!

And now... Once I choose a vCenter, how can I connect to that vCenter, take another options menu to choose cluster, and of that cluster, show me the MVs that are not in a DRS group?

Thanks in advanced!

[LucD]

Try like this

$data = @'

Name

VC1

VC2

VC3

'@

$selectedVC = $data | ConvertFrom-Csv | select Name |

Out-GridView -OutputMode Single

Connect-VIServer -Server $selectedVC.Name

$selectedCLuster = Get-Cluster -Server $selectedVC.Name | Select Name | Out-GridView -OutputMode Single

$vmInRule = Get-View -Id (Get-DrsRule -Cluster $selectedCLuster.Name).VmIds -Property Name | %{$_.Name}

Get-Cluster -Name $selectedCLuster.Name | Get-VM | where{$vmInRule -notcontains $_.Name} | Select Name

[DJ_NEIL]

i try this, but i can´t select a cluster, don´t work :smileysad:

$data = @'

Name

VC1

VC2

VC3

'@

$selectedVC = $data | ConvertFrom-Csv | select Name |

Out-GridView -OutputMode Single

Connect-VIServer -Server $selectedVC

$data1 = @'

Cluster

Cluster1

Cluster2

Cluster3

'@

$selectedVC = $data | ConvertFrom-Csv | select Clusteer |

Out-GridView -OutputMode Single

$selectedCLuster = Get-Cluster -Server $selectedVC | Select Name | Out-GridView -OutputMode Single

$vmInRule = Get-View -Id (Get-DrsRule -Cluster $selectedCLuster.Name).VmIds -Property Name | %{$_.Name}

Get-Cluster -Name $selectedCLuster.Name | Get-VM | where{$vmInRule -notcontains $_.Name} | Select Name

[LucD]

That's not what I had in my last reply?
And I made a change to the Connect-VIServer in the code above.

Can you try that gain?
And show the script you are actually executing.

[DJ_NEIL]

Hi!

Yes, yes sorry! with the last update the script works! but it does not filter well the machines that are not in a rules of DRS groups, it shows all the MVs of the cluster!!

The rules of the DRS groups are a bit special!!

Tnaks in advanced

Regards

[LucD]

The code relies on the output of the Get-DrsRule cmdlet to find the VMs that are used in each DRS rule.

Does the following show all the VMs that appear in your DRS rules for a specific cluster?

$clusterName = 'MyCluster'

Get-CLuster -Name $clusterName |

Get-DrsRule | %{

    Get-View -Id $_.VMIDs -Property Name |

    Select -ExpandProperty Name

}

[DJ_NEIL]

with those lines, only shows me some MV, s, in theory all the MVs are in a DRS rule, so I would like you to show me if there was any MV without a rule

Thanks!

[LucD]

It looks as if not all VM s that are in DRS rules can be found this way then.

What kind of DRS rules do you use? Affinity, anti-affinity, VMHost-VM rules, start group order...

Are there VM Groups defined?

[DJ_NEIL]

What kind of DRS rules do you use? Affinity, anti-affinity, VMHost-VM rules, start group order...

Yes, i have Affinity, anti-affinity, VMHost-VM rules... start group order no

Are there VM Groups defined?

VM Groups no, DRS Groups yes!

Thanks!

[LucD]

What do you mean by a DRS Group?

Is that a VM/VMHost group under DRS?

A screenshot of the location where a VM is defined that is not listed by the snippet would help.

[DJ_NEIL]

Yes, i have a virtual machines DRS Groupalia, this DRS Groupalia contains VMs

[LucD]

But is that group used in a DRS rule?

A screenshot to clarify would help.

[DJ_NEIL]

I can,t upload a  screenshot of my infraestructure :smileysad:

But in this blog--> vSphere 5 DRS Groups and Rules - blog.shiplett.org You can see screenshots like my infraestructure just other mames!

[LucD]

I understand that, and I know what a DRS VM group is.

But the important question, are all these groups used in a DRS rule?

Or do you have VM groups that are defined but never used in a DRS rule?

[LucD]

Try this adapted version which starts from the DRS VM groups.

Get-DrsClusterGroup -Type VMGroup | %{

   $_.Member | Select -ExpandProperty Name

}

$data = @'

Name

VC1

VC2

VC3

'@

$selectedVC = $data | ConvertFrom-Csv | select Name | Out-GridView -OutputMode Single

Connect-VIServer -Server $selectedVC.Name

$selectedCluster = Get-Cluster -Server $selectedVC.Name | Select Name | Out-GridView -OutputMode Single

$vmInGroup = Get-DrsClusterGroup -Type VMGroup | %{

   $_.Member | Select -ExpandProperty Name

}

Get-Cluster -Name $selectedCluster.Name | Get-VM | where{$vmInGroup -notcontains $_.Name} | Select Name

[DJ_NEIL]

Now works perfectly!

Any idea to export the final result (VMs in not DRS rules) to CSV?

Thanks!!

[LucD]

Change the last line into

Get-Cluster -Name $selectedCLuster.Name | Get-VM | where{$vmInGroup -notcontains $_.Name} | Select Name |

Export-Csv -Path .\report.csv -NoTypeInformation -UseCulture

[DJ_NEIL]

Perfect!!

Thanks!!