PowerCLI Script

[Sha_roy]

Hello,

I'm searching for a powerCLI script that can log in to multiple vCenters simultaneously, record the name and number of VMs in each Resource Pool, and export the results in CSV format.

Please, someone lend a hand.

@LucD 

[scott28tt]

I have reported your post to the moderators, asking them to move it to the PowerCLI area.
Once you can see that area, it's probably best to do a search rather than expecting someone to write code for you.

[LucD]

Provided the credentials for all your vCenters are the same, you could do

$vcenters = 'VC1','VC2','VC3'
$user = 'xyz'
$pswd = 'abc'

$cred = New-Object System.Management.Automation.PSCredential($user, (ConvertTo-SecureString $pswd -AsPlainText -Force))

Connect-VIServer -Server $vcenters -Credential $cred

Get-ResourcePool |
Select Name,
	@{N='VMCount';E={(Get-VM -Location $_).Count}} |
Export-Csv -Path .\report.csv -NoTypeInformation -UseCulture

[Sha_roy]

Hi LucD,

Thanks for your help.

As I'm running it for multiple VC's, is it possible to add columns for the Cluster and vCenter Name so that I can sort report with VC.

[LucD · Accepted solution]

Sure, try like this

$vcenters = 'VC1','VC2','VC3'
$user = 'xyz'
$pswd = 'abc'
$cred = New-Object System.Management.Automation.PSCredential($user, (ConvertTo-SecureString $pswd -AsPlainText -Force))

Connect-VIServer -Server $vcenters -Credential $cred

Get-Cluster -PipelineVariable cluster | 
Get-ResourcePool |
Select @{N='vCenter';E={([System.Uri]$cluster.ExtensionData.Client.ServiceUrl).Host}},
	@{N='Cluster';E={$cluster.Name}},
	@{N='ResourcePool';E={$_.Name}},
	@{N='VMCount';E={(Get-VM -Location $_).Count}} |
Export-Csv -Path .\report.csv -NoTypeInformation -UseCulture

[Sha_roy]

Hi LucD,

Thank you for the update.

I tried the script, however it's capturing the data only for last VC which I enter in the $vcenters.

Anything I'm missing or doing wrong?

[LucD]

You probably have the DefaultVIServerMode set to Single.
Check with Get-PowerCLIConfiguration.
Change to Multiple with Set-PowerCLIConfiguration.

[StephenMoll · Accepted solution]

I like to begin all my scripts with :

Set-PowerCLIConfiguration -Scope Session `
        -DefaultVIServerMode Multiple `
        -Confirm:$false | Out-Null

I need to run my scripts in various locations which may be configured to be single or multi-server for various reasons. This way my scripts work the way I intend them to without altering the environment I run them in.

There are other options too which are sometimes useful too:

Set-PowerCLIConfiguration -Scope Session `
        -ParticipateInCeip $false `
        -InvalidCertificateAction Ignore `
        -DisplayDeprecationWarnings $false `
        -DefaultVIServerMode Multiple `
        -Confirm:$false | Out-Null

This tends to be the full commandlet near the beginning of my scripts.

[Sha_roy]

Thank you @LucD & @StephenMoll for your inputs.

It's working as expected.