Nice script.

____________

Blog: LucD notes

Twitter: lucd22

Indeed. Nice script. One caveat is that stat tracking must be @ level 3 in vCenter for the disk.numberWrite.summation and disk.numberRead.summation statistics to show up.

Chris Nakagaki (Zsoldier)

http://tech.zsoldier.com

Thanks guys.

@Zsoldier: Yeah, that's why I decided to get the stats from the hosts themselves. Would be a bit more streamlined if stats were up to level 3 across the board and everything happened through vCenter, but one of our environments is still at level 2.

Is there a way to specify multiple datastores or multiple hosts?

The array that you pass to the -datastores parameter can have multiple datastores in it. For example:

GatherIOPS.ps1 -server myvcenterserver.mydns.com -datastores @("DS01","DS03","DS25") -numsamples 90

Currently, the script will only work against one vCenter instance (but gathers data from all ESX hosts managed by that instance). If there is a need to hit multiple vCenter Servers I can modify it to take this in as an array as well.

Great script! Thanks for this!

Question: is there any way to supress the certificate errors that I'm receiving? (Sample below)

Thanks in advance!!!!

-

WARNING: There were one or more problems with the server certificate:

• The X509 chain could not be built up to the root certificate.

• The certificate's CN name does not match the passed value.

Sorry to be a nuisance, but also is there anyway to output the IOP's in whole numbers (ie. take off everything after the decimals?)

Thanks again!

godbucket -

I've uploaded a new version of the script that ignores the cert alerts. Also, if you want rounded numbers the easiest way would be to replace the last line in the GetAvgStat function:

return $totalIOPS/$samples/20

with this:

return ($totalIOPS/$samples/20)

Cool, thanks for supressing the cert alerts!

Now when I try the GetAvgStat replacement function you mentioned above, I get the following error:

-

The term 'int' is not recognized as the name of a cmdlet, function, script file

, or operable program. Check the spelling of the name, or if a path was include

d, verify that the path is correct and try again.

At C:\Users\Tsmith\Desktop\GatherIOPS.ps1:78 char:12

+ return int <<<< ($totalIOPS/$samples/20)

+ CategoryInfo : ObjectNotFound: (int:String) [], CommandNotFound

Exception

+ FullyQualifiedErrorId : CommandNotFoundException

-

Please advise me on what to do, and thank you so much for your help!!!

Sorry, looks like I need to learn how to format for these discussion boards... there should be brackets "[ ]" around "int"

I went ahead and added the rounding to version 3 of the script after I realized that I don't really care that much if a single VM is doing .3 read IOPS.

lol yeah, 0.2227262738 IOPS is hard to explain in reports to management.

Thanks so much for your script and your help. I appreciate it big time!!!!

Hi really nice script

Would be cool if you could add " | where {$_.PowerState -eq "PoweredOn"} " after $myVMs = Get-VM -Datastore $myDatastore -server $server

So we dont get errors on powered off vms.

By the way, is there any way to do the same with the datastores ?

and if you want to get all the datastores you can use

GatherIOPS.ps1 -server myvcenterserver.mydns.com -datastores @(Get-Datastore) -numsamples 90

Would be cool if you could add " | where {$_.PowerState -eq "PoweredOn"} "

after $myVMs = Get-VM -Datastore $myDatastore -server $server

So we dont get errors on powered off vms.

Added!

By the way, is there any way to do the same with the datastores ?

Not sure I know what you mean here - you just want datastores with no running VMs to be excluded from the results? If so, yeah, that should be easy enough.

What i mean is; Is it possible to get a list of IOPS per datastore(over a given time) insted for per vm(as in the script)

Hi.  I am total neebie to running scripts.  When I try and run your script I get several errors. I do get prompted for the ESX host account and password but which host is it talking about.  Our hosts have several different passwords. Should we be logging in as root?  Can I select specific hosts?  Here are the errors I receive

Connect-VIServer : The argument cannot be null or empty.
At C:\scripts\GatherIOPS.ps1:44 char:17
+ Connect-VIServer  <<<< $server -NotDefault -WarningAction SilentlyContinue |
Out-Null
Get-Datastore : The argument cannot be null or empty.
At C:\scripts\GatherIOPS.ps1:86 char:37
+   $myDatastore = Get-Datastore -Name  <<<< $datastore -server $server
Get-VM : The argument cannot be null or empty.
At C:\scripts\GatherIOPS.ps1:87 char:29
+   $myVMs = Get-VM -Datastore  <<<< $myDatastore -server $server | Where {$_.P
owerState -eq "PoweredOn"}
Connect-VIServer : The argument cannot be null or empty.
At C:\scripts\GatherIOPS.ps1:58 char:26
+     connect-viserver -server  <<<< $vmhost -credential $credentials -NotDefau
lt -WarningAction SilentlyContinue | Out-Null
Get-Datastore : The argument cannot be null or empty.
At C:\scripts\GatherIOPS.ps1:61 char:34
+     $myDatastoreID = ((Get-Datastore  <<<< $ds -server $vmhost) | Get-View).i
nfo.vmfs.extent[0].diskname
Get-VM : The argument cannot be null or empty.
At C:\scripts\GatherIOPS.ps1:64 char:40
+     $rawVMStats = get-stat -entity    (get-vm  <<<< $vm -server $vmhost) -sta
t $stat -maxSamples $samples
You cannot call a method on a null-valued expression.
At C:\scripts\GatherIOPS.ps1:68 char:28
+         if ($stat.instance.Equals( <<<< $myDatastoreID)) {
Attempted to divide by zero.
At C:\scripts\GatherIOPS.ps1:78 char:27
+     return [int] ($totalIOPS/$ <<<< samples/20)
Connect-VIServer : The argument cannot be null or empty.
At C:\scripts\GatherIOPS.ps1:58 char:26
+     connect-viserver -server  <<<< $vmhost -credential $credentials -NotDefau
lt -WarningAction SilentlyContinue | Out-Null
Get-Datastore : The argument cannot be null or empty.
At C:\scripts\GatherIOPS.ps1:61 char:34
+     $myDatastoreID = ((Get-Datastore  <<<< $ds -server $vmhost) | Get-View).i
nfo.vmfs.extent[0].diskname
Get-VM : The argument cannot be null or empty.
At C:\scripts\GatherIOPS.ps1:64 char:40
+     $rawVMStats = get-stat -entity    (get-vm  <<<< $vm -server $vmhost) -sta
t $stat -maxSamples $samples
You cannot call a method on a null-valued expression.
At C:\scripts\GatherIOPS.ps1:68 char:28
+         if ($stat.instance.Equals( <<<< $myDatastoreID)) {
Attempted to divide by zero.
At C:\scripts\GatherIOPS.ps1:78 char:27
+     return [int] ($totalIOPS/$ <<<< samples/20)

You don't have to be logged in as root (although that works if they share the same password). This should also work with AD credentials if your hosts are configured to accept that. If not, then you will need to create local accounts on each ESX/ESXi host for this purpose. I haven't played around with that setup, but these accounts would likely only need read-only rights on the hosts to get this working.

Hi, I have now got a bit furtther.  I created new accounts on nearly all of our hosts and the script begins to run but still generates errors but the script continues to run. However when the scripts completes it provides the names of the guests located in the LUN specified but does not provide any IOPs output.  Errors are below.

+     $myDatastoreID = ((Get-Datastore  <<<< $ds -server $vmhost) | Get-View).i
nfo.vmfs.extent[0].diskname
Get-Datastore : 10/11/2011 09:50:58    Get-Datastore        Could not find any
of the servers specified by name.
At C:\scripts\GatherIOPS.ps1:61 char:34
+     $myDatastoreID = ((Get-Datastore  <<<< $ds -server $vmhost) | Get-View).i
nfo.vmfs.extent[0].diskname
Get-VM : 10/11/2011 09:50:58    Get-VM        Could not find VIServer with name
'sose0003v.scotland.gov.uk'.
At C:\scripts\GatherIOPS.ps1:64 char:40
+     $rawVMStats = get-stat -entity    (get-vm  <<<< $vm -server $vmhost) -sta
t $stat -maxSamples $samples
Get-VM : 10/11/2011 09:50:58    Get-VM        Could not find any of the servers
specified by name.
At C:\scripts\GatherIOPS.ps1:64 char:40
+     $rawVMStats = get-stat -entity    (get-vm  <<<< $vm -server $vmhost) -sta
t $stat -maxSamples $samples
You cannot call a method on a null-valued expression.
At C:\scripts\GatherIOPS.ps1:68 char:28
+         if ($stat.instance.Equals( <<<< $myDatastoreID)) {
The operation '[System.Int32] / [System.String]' is not defined.
At C:\scripts\GatherIOPS.ps1:78 char:27
+     return [int] ($totalIOPS/$ <<<< samples/20)
Method invocation failed because [System.String] doesn't contain a method named
'op_Division'.
At C:\scripts\GatherIOPS.ps1:94 char:50
+       $data."Interval (minutes)" = ($numsamples*20)/6 <<<< 0
Connect-VIServer : A parameter cannot be found that matches parameter name 'War
ningAction'.
At C:\scripts\GatherIOPS.ps1:58 char:86
+     connect-viserver -server $vmhost -credential $credentials -NotDefault -Wa
rningAction  <<<< SilentlyContinue | Out-Null
Get-Datastore : 10/11/2011 09:50:59    Get-Datastore        Could not find VISe
rver with name 'sose0003v.scotland.gov.uk'.
At C:\scripts\GatherIOPS.ps1:61 char:34
+     $myDatastoreID = ((Get-Datastore  <<<< $ds -server $vmhost) | Get-View).i
nfo.vmfs.extent[0].diskname
Get-Datastore : 10/11/2011 09:50:59    Get-Datastore        Could not find any
of the servers specified by name.
At C:\scripts\GatherIOPS.ps1:61 char:34
+     $myDatastoreID = ((Get-Datastore  <<<< $ds -server $vmhost) | Get-View).i
nfo.vmfs.extent[0].diskname
Get-VM : 10/11/2011 09:50:59    Get-VM        Could not find VIServer with name
'sose0003v.scotland.gov.uk'.
At C:\scripts\GatherIOPS.ps1:64 char:40
+     $rawVMStats = get-stat -entity    (get-vm  <<<< $vm -server $vmhost) -sta
t $stat -maxSamples $samples
Get-VM : 10/11/2011 09:50:59    Get-VM        Could not find any of the servers
specified by name.
At C:\scripts\GatherIOPS.ps1:64 char:40
+     $rawVMStats = get-stat -entity    (get-vm  <<<< $vm -server $vmhost) -sta
t $stat -maxSamples $samples
You cannot call a method on a null-valued expression.
At C:\scripts\GatherIOPS.ps1:68 char:28
+         if ($stat.instance.Equals( <<<< $myDatastoreID)) {
The operation '[System.Int32] / [System.String]' is not defined.
At C:\scripts\GatherIOPS.ps1:78 char:27
+     return [int] ($totalIOPS/$ <<<< samples/20)
Connect-VIServer : A parameter cannot be found that matches parameter name 'War
ningAction'.
At C:\scripts\GatherIOPS.ps1:58 char:86
+     connect-viserver -server $vmhost -credential $credentials -NotDefault -Wa
rningAction  <<<< SilentlyContinue | Out-Null
Get-Datastore : 10/11/2011 09:50:59    Get-Datastore        Could not find VISe
rver with name 'sose0003v.scotland.gov.uk'.
At C:\scripts\GatherIOPS.ps1:61 char:34
+     $myDatastoreID = ((Get-Datastore  <<<< $ds -server $vmhost) | Get-View).i
nfo.vmfs.extent[0].diskname
Get-Datastore : 10/11/2011 09:50:59    Get-Datastore        Could not find any
of the servers specified by name.
At C:\scripts\GatherIOPS.ps1:61 char:34
+     $myDatastoreID = ((Get-Datastore  <<<< $ds -server $vmhost) | Get-View).i
nfo.vmfs.extent[0].diskname
Get-VM : 10/11/2011 09:50:59    Get-VM        Could not find VIServer with name
'sose0003v.scotland.gov.uk'.
At C:\scripts\GatherIOPS.ps1:64 char:40
+     $rawVMStats = get-stat -entity    (get-vm  <<<< $vm -server $vmhost) -sta
t $stat -maxSamples $samples
Get-VM : 10/11/2011 09:50:59    Get-VM        Could not find any of the servers
specified by name.
At C:\scripts\GatherIOPS.ps1:64 char:40
+     $rawVMStats = get-stat -entity    (get-vm  <<<< $vm -server $vmhost) -sta
t $stat -maxSamples $samples
You cannot call a method on a null-valued expression.
At C:\scripts\GatherIOPS.ps1:68 char:28
+         if ($stat.instance.Equals( <<<< $myDatastoreID)) {
The operation '[System.Int32] / [System.String]' is not defined.
At C:\scripts\GatherIOPS.ps1:78 char:27
+     return [int] ($totalIOPS/$ <<<< samples/20)
Method invocation failed because [System.String] doesn't contain a method named
'op_Division'.
At C:\scripts\GatherIOPS.ps1:94 char:50
+       $data."Interval (minutes)" = ($numsamples*20)/6 <<<< 0
Connect-VIServer : A parameter cannot be found that matches parameter name 'War
ningAction'.
At C:\scripts\GatherIOPS.ps1:58 char:86
+     connect-viserver -server $vmhost -credential $credentials -NotDefault -Wa
rningAction  <<<< SilentlyContinue | Out-Null
Get-Datastore : 10/11/2011 09:51:00    Get-Datastore        Could not find VISe
rver with name 'sose0003v.scotland.gov.uk'.
At C:\scripts\GatherIOPS.ps1:61 char:34
+     $myDatastoreID = ((Get-Datastore  <<<< $ds -server $vmhost) | Get-View).i
nfo.vmfs.extent[0].diskname
Get-Datastore : 10/11/2011 09:51:00    Get-Datastore        Could not find any
of the servers specified by name.
At C:\scripts\GatherIOPS.ps1:61 char:34
+     $myDatastoreID = ((Get-Datastore  <<<< $ds -server $vmhost) | Get-View).i
nfo.vmfs.extent[0].diskname
Get-VM : 10/11/2011 09:51:00    Get-VM        Could not find VIServer with name
'sose0003v.scotland.gov.uk'.
At C:\scripts\GatherIOPS.ps1:64 char:40
+     $rawVMStats = get-stat -entity    (get-vm  <<<< $vm -server $vmhost) -sta
t $stat -maxSamples $samples
Get-VM : 10/11/2011 09:51:00    Get-VM        Could not find any of the servers
specified by name.
At C:\scripts\GatherIOPS.ps1:64 char:40
+     $rawVMStats = get-stat -entity    (get-vm  <<<< $vm -server $vmhost) -sta
t $stat -maxSamples $samples
You cannot call a method on a null-valued expression.
At C:\scripts\GatherIOPS.ps1:68 char:28
+         if ($stat.instance.Equals( <<<< $myDatastoreID)) {
The operation '[System.Int32] / [System.String]' is not defined.
At C:\scripts\GatherIOPS.ps1:78 char:27
+     return [int] ($totalIOPS/$ <<<< samples/20)
Connect-VIServer : A parameter cannot be found that matches parameter name 'War
ningAction'.
At C:\scripts\GatherIOPS.ps1:58 char:86
+     connect-viserver -server $vmhost -credential $credentials -NotDefault -Wa
rningAction  <<<< SilentlyContinue | Out-Null
Get-Datastore : 10/11/2011 09:51:00    Get-Datastore        Could not find VISe
rver with name 'sose0003v.scotland.gov.uk'.
At C:\scripts\GatherIOPS.ps1:61 char:34
+     $myDatastoreID = ((Get-Datastore  <<<< $ds -server $vmhost) | Get-View).i
nfo.vmfs.extent[0].diskname
Get-Datastore : 10/11/2011 09:51:00    Get-Datastore        Could not find any
of the servers specified by name.
At C:\scripts\GatherIOPS.ps1:61 char:34
+     $myDatastoreID = ((Get-Datastore  <<<< $ds -server $vmhost) | Get-View).i
nfo.vmfs.extent[0].diskname
Get-VM : 10/11/2011 09:51:00    Get-VM        Could not find VIServer with name
'sose0003v.scotland.gov.uk'.
At C:\scripts\GatherIOPS.ps1:64 char:40
+     $rawVMStats = get-stat -entity    (get-vm  <<<< $vm -server $vmhost) -sta
t $stat -maxSamples $samples
Get-VM : 10/11/2011 09:51:00    Get-VM        Could not find any of the servers
specified by name.
At C:\scripts\GatherIOPS.ps1:64 char:40
+     $rawVMStats = get-stat -entity    (get-vm  <<<< $vm -server $vmhost) -sta
t $stat -maxSamples $samples
You cannot call a method on a null-valued expression.
At C:\scripts\GatherIOPS.ps1:68 char:28
+         if ($stat.instance.Equals( <<<< $myDatastoreID)) {
The operation '[System.Int32] / [System.String]' is not defined.
At C:\scripts\GatherIOPS.ps1:78 char:27
+     return [int] ($totalIOPS/$ <<<< samples/20)
Method invocation failed because [System.String] doesn't contain a method named
'op_Division'.
At C:\scripts\GatherIOPS.ps1:94 char:50
+       $data."Interval (minutes)" = ($numsamples*20)/6 <<<< 0
Connect-VIServer : A parameter cannot be found that matches parameter name 'War
ningAction'.
At C:\scripts\GatherIOPS.ps1:58 char:86
+     connect-viserver -server $vmhost -credential $credentials -NotDefault -Wa
rningAction  <<<< SilentlyContinue | Out-Null
Get-Datastore : 10/11/2011 09:51:01    Get-Datastore        Could not find VISe
rver with name 's0011dev.scotland.gov.uk'.
At C:\scripts\GatherIOPS.ps1:61 char:34
+     $myDatastoreID = ((Get-Datastore  <<<< $ds -server $vmhost) | Get-View).i
nfo.vmfs.extent[0].diskname
Get-Datastore : 10/11/2011 09:51:01    Get-Datastore        Could not find any
of the servers specified by name.
At C:\scripts\GatherIOPS.ps1:61 char:34
+     $myDatastoreID = ((Get-Datastore  <<<< $ds -server $vmhost) | Get-View).i
nfo.vmfs.extent[0].diskname
Get-VM : 10/11/2011 09:51:01    Get-VM        Could not find VIServer with name
's0011dev.scotland.gov.uk'.
At C:\scripts\GatherIOPS.ps1:64 char:40
+     $rawVMStats = get-stat -entity    (get-vm  <<<< $vm -server $vmhost) -sta
t $stat -maxSamples $samples
Get-VM : 10/11/2011 09:51:01    Get-VM        Could not find any of the servers
specified by name.
At C:\scripts\GatherIOPS.ps1:64 char:40
+     $rawVMStats = get-stat -entity    (get-vm  <<<< $vm -server $vmhost) -sta
t $stat -maxSamples $samples
You cannot call a method on a null-valued expression.
At C:\scripts\GatherIOPS.ps1:68 char:28
+         if ($stat.instance.Equals( <<<< $myDatastoreID)) {
The operation '[System.Int32] / [System.String]' is not defined.
At C:\scripts\GatherIOPS.ps1:78 char:27
+     return [int] ($totalIOPS/$ <<<< samples/20)
Connect-VIServer : A parameter cannot be found that matches parameter name 'War
ningAction'.
At C:\scripts\GatherIOPS.ps1:58 char:86
+     connect-viserver -server $vmhost -credential $credentials -NotDefault -Wa
rningAction  <<<< SilentlyContinue | Out-Null
Get-Datastore : 10/11/2011 09:51:01    Get-Datastore        Could not find VISe
rver with name 's0011dev.scotland.gov.uk'.
At C:\scripts\GatherIOPS.ps1:61 char:34
+     $myDatastoreID = ((Get-Datastore  <<<< $ds -server $vmhost) | Get-View).i
nfo.vmfs.extent[0].diskname
Get-Datastore : 10/11/2011 09:51:01    Get-Datastore        Could not find any
of the servers specified by name.
At C:\scripts\GatherIOPS.ps1:61 char:34
+     $myDatastoreID = ((Get-Datastore  <<<< $ds -server $vmhost) | Get-View).i
nfo.vmfs.extent[0].diskname
Get-VM : 10/11/2011 09:51:01    Get-VM        Could not find VIServer with name
's0011dev.scotland.gov.uk'.
At C:\scripts\GatherIOPS.ps1:64 char:40
+     $rawVMStats = get-stat -entity    (get-vm  <<<< $vm -server $vmhost) -sta
t $stat -maxSamples $samples
Get-VM : 10/11/2011 09:51:01    Get-VM        Could not find any of the servers
specified by name.
At C:\scripts\GatherIOPS.ps1:64 char:40

Some of the errors (ignoring the "Could not find" ones for now) look like the Get-Stat cmdlet isn't returning anything when called, resulting in some division by 0 errors. Can you post the ESX/ESXi build version you are using? I might have to spin up a test environment to see if  I can recreate the error.

Hi we do have a mixed environment of ESX 4.1 433742, ESXi 4.1 433742, ESX 4.0 2948555 and the host that is attached to the LUN we required output from is ESX 4.1 433742

Thanks

Ok, thanks for the info. Just so I'm testing with the correct parameters, what rights did you assign to this new account on each host? If Read-Only, can you also try it with Administrator privileges on a single host just to rule out permissions as an issue?

Hi the account created is a member of the root group.

Thanks

Ok, that's probably the issue. You don't want to add this user to the root group; in fact, whatever default groups are assigned when you create the account is fine. Once the account is created, select the host, go to the Permissions tab, and add a Permission with the Read-Only role for your new user account. This should give it sufficient permissions to access the performance data via vSphere client and PowerCLI.

Still blank out-put.  Account is only member of users group.

Hi Iwas able to run the script on vmfs type datastores but receiving errors for nfs type of datastores.Plase let me know is there any solution to this.

Thanks

Hi,

I was able to get the desired stats for VMFS datastores but can't get the details for NFS datastores, could you please:smileyplain: let me knoe why is that it is not suporting VMFS datastores.

Thanks

Please could you tell me if this script is valid for ESXi 5.1 environment as well. Thanks!

Iam getting following error while executing the script. please help me on this.

Connect-VIServer : Cannot validate argument on parameter 'Server'. The argument is null or empty. Supply an argument that is not null or

empty and then try the command again.

At line:14 char:18

+ Connect-VIServer $server -NotDefault -WarningAction SilentlyContinue | Out-Null

+                  ~~~~~~~

          + CategoryInfo : InvalidData: (:) [Connect-VIServer], ParameterBindingValidationException

         + FullyQualifiedErrorId : ParameterArgumentValidationError,VMware.VimAutomation.ViCore.Cmdlets.Commands.ConnectVIServer

Any update for the script on the new VMFS 5.5 and DataStore cluster capabilities ?

Can any body help me as I am getting following error while executing the script.

Connect-Viserver: cannot validate argument on parameter ' Server'. The argument is null or empty.

supply an argument that is not null or empty and then try the command again.

At line:14 char:18

+ connect - Viserver $server -notdefault -warningaction silentlycontinue | out-null

+                                ~~~~~

+ categoryinfo : invalidate: (:) [connect-viserver], parameterbindingvalidationexception

+ fullyqualfiederrorid: parameter arugment validation error, VMware.vimautomation.vicore.cmdlets.commands.convvectviserver.

Dear AlbertWT,

Please help me on the above error.

change that line to be:

Connect-VIServer -server $server -NotDefault -WarningAction SilentlyContinue | Out-Null

That's what got it working for me.

Thanks for this script!  It helped me weed out a VM that was hogging our SAN and causing latency to spike.

Cheers!

thanks for this! was much easier than creating something from scratch!

Try Changing $vm.host.name to $vm.vmhost.name

Bringing this thread back from the dead.

Line 93 says: $data = �� | Select "VM", "Interval (minutes)", "Avg Write IOPS", "Avg Read IOPS"

What are �� ??