Connecting Mulitple VCenter Servers and collect information with Powercli

Question

I have a list of VCenter servers. They are on different locations and of different customers. I have created a text file with all the vcenter servers and credentials like below..I have more than 20 Vcenter Servers. I need to collect information of VM, Datastores, etc.(for which I have scripts).

Connect-VIServer vcenter0001 -User vcenter0001\sysdep -Password "Passwowrd1"
Connect-VIServer vcenter0002 -User vcenter0002\sysdep -Password "Passwowrd2"

I want to connect to each VCenter server and execute my scripts. Please help me. Thanks in Advance.

This question may be more suited for [Serverfault](https://serverfault.com/). — Nikolaj Dam Larsen, Jul 26 '17 at 19:10
Are you sure you want to store passwords in plaintext. The New-VICredentialStoreItem allows for multi credentials, reference them using [0],[1] etc. — user3520245, Jul 31 '17 at 07:13

score 1 · Accepted Answer · answered Jul 26 '17 at 21:20

There's a couple ways to accomplish this, first you need to make sure that your configuration is set to allow for multiple connections. This is done with the following:

Set-PowerCLIConfiguration -DefaultVIServerMode Multiple

Note: It may also be necessary to run the following to enforce the change against all session scopes:

Set-PowerCLIConfiguration -DefaultVIServerMode Multiple -Scope User
Set-PowerCLIConfiguration -DefaultVIServerMode Multiple -Scope Session

Afterwards, you can pass multiple vCenter server names in string format or array format to the Connect-VIServer cmdlet to the 'Server' parameter.

Example using strings:

Connect-VIServer -Server vcenter0001,vcenter0002,vcenter0003 -User sysdep -Password "Password"

Example using an array:

$vCenterNames = @('vcenter0001','vcenter0002','vcenter0003')
Connect-VIServer -Server $vCenterNames -User sysdep -Password "Password"

Lastly, since it looks like you may be using local accounts instead of a single domain account, you could look at integrating the VICredentialStore. This saves your credentials in an XML file that will be referenced automatically at time of authentication.

Example Usage:

New-VICredentialStoreItem -Host vcenter0001 -User vcenter0001\sysdep -Password "Password"
New-VICredentialStoreItem -Host vcenter0002 -User vcenter0002\sysdep -Password "Password"
New-VICredentialStoreItem -Host vcenter0003 -User vcenter0003\sysdep -Password "Password"
Connect-VIServer -Server vcenter0001,vcenter0002,vcenter0003

Thank you Kyle, In my case the usernames and passwords can also change.. each vcenter can have different user instead of sysdep and machine generated passwords. — Subhantech, Jul 27 '17 at 12:48

score 1 · Answer 2 · answered Aug 03 '17 at 04:36

Suppose you have a top secret csv file where you store the connection info (i.e. vi server fqdn, logon user name and passwords) that looked like this:

viserver, username, password
myfav.cust1.org, cust1usr, cust1pw
my2fav.cust2.net, cust2usr, cust2pw
myleastfav.cust3.com, cust3usr, cust3pw

and it was saved in: c:\mysecretdocs\custviservers.csv you could use import-csv and a foreach statement to do your inventory dirty work with a function that looked something like this:

function get-vminventory
{
    $viCntinfo = Import-Csv c:\mysecretdocs\custviservers.csv
    foreach ($vi in $viCntInfo)
    {
        $convi = connect-viserver -server $vi.viserver -username $vi.username -password $vi.password
        $vms = get-vm
        $vms | select name, MemoryGB, NumCpu,
            @{ n = "hostname"; e = { $_.guest.hostname } },
            @{ n = "ip"; e = { $_.guest.ipaddress -join ", " } },
            @{ n = "viserver"; e = { $convi.Name } }
        $discvi = disconnect-viserver -server * -force -confirm:$false
    }
}

You can run any of the PowerCLI inventory or custom commands there and select whatever output you want, that's just an example using Get-VM. Either dot source the function or just paste it into your shell. Then execute it and put the output in a csv like this:

get-vminventory | Export-Csv c:\mycustomerdata\vminfo.csv

This is awesome and exactly what I was looking for! – Naomi See Apr 25 '19 at 00:37 — Naomi See, Apr 25 '19 at 00:37

Connecting Mulitple VCenter Servers and collect information with Powercli

2 Answers2