2 Replies Latest reply on Dec 9, 2019 12:38 AM by ganapa2000

    Unable to get Datastore name

    ganapa2000 Hot Shot

      Hi,

       

      I am trying to validate and get the name of the datastore, which has more free space, below script is not working,

       

      I have two datastores, which has 800 GB and 400 GB free but I am not able to get datastore name with more free space from below.

       

      please help

       

      $intNewVMDiskSize = '250'

      $oDatastoreWithMostFree = Get-Cluster MyClus | Get-Datastore | Sort-Object -Property {$_.FreeSpaceGB} -Descending:$true | where {$_.Name -NotMatch '^datastore1|^Datastore123|^MyDatastore3|^datastore_udev'} | Select-Object -ExpandProperty Name -First 1

      if (($oDatastoreWithMostFree.FreespaceGB + 100) -lt $intNewVMDiskSize) {

          $($oDatastoreWithMostFree.Name)

      }

      else {

          "oh, no -- not enough freespace on datastore '$($oDatastoreWithMostFree.Name)' to provision new VM"

          return

      }

        • 1. Re: Unable to get Datastore name
          LucD Guru
          User ModeratorsCommunity WarriorsvExpert

          You only seem to select the Name property, while you use the FreespaceGB property as well later on.

          Try like this

           

          $intNewVMDiskSize = '250'

           

          $oDatastoreWithMostFree = Get-Cluster MyClus |

              Get-Datastore |

              where {$_.Name -NotMatch '^datastore1|^Datastore123|^MyDatastore3|^datastore_udev'} |

              Sort-Object -Property {$_.FreeSpaceGB} -Descending:$true |

              Select-Object -First 1

            

          if (($oDatastoreWithMostFree.FreespaceGB + 100) -lt $intNewVMDiskSize) {

              $($oDatastoreWithMostFree.Name)

          }

          else {

              "oh, no -- not enough freespace on datastore '$($oDatastoreWithMostFree.Name)' to provision new VM"

              return

          }

          Blog: http://lucd.info | Twitter: @LucD22 | PowerCLI Reference co-author: http://tinyurl.com/hkn4glz
          • 2. Re: Unable to get Datastore name
            ganapa2000 Hot Shot

            perfect...Thanks a lot as always...