Scripts PowerCLI

Cette page regroupe un ensemble de scripts PowerCLI/Powershell

VM

Listing VM et taille

• Script pour lister les VMs et leur taille de disque dur

Param (
    [Alias("Host")]
    [string]$VIServer = "",
    [string]$User = "",
    [string]$Password="",
    [string]$PathToReport,
    [string]$CredentialFile="credential-vsphere.xml",
    
    [string]$To = "mail@domain.be",
    [string]$From = "report-vmware@domain.be",
    [string]$SMTPServer = "mail.domain.be"
)

#Récupération du fichier avec les identifiants
$PathCredentialFile = Split-Path $Script:MyInvocation.MyCommand.Path -Parent
$PathCredentialFile += "\" + $CredentialFile
$PathCredentialFile

$credential = Get-VICredentialStoreItem -File $PathCredentialFile

#Conexion au serveur
$connexion = Connect-VIServer -Server $credential.Host -User $credential.User -Password $credential.Password -WarningAction SilentlyContinue

$date = Get-Date -Format yyyy.MM.dd
$file = "C:\Rapport-VMware\"+$date+"-report-vm-size.csv"

#Recupération de toutes les VM
$listVm = Get-VM "*test*"
$report=@()

foreach ($vm in $listVm)
{
    $report += $vm | Select-Object Name,@{n="Provisionedspace(GB)"; E={[math]::round($_.ProvisionedSpaceGB)}}
}

$report
$report | Export-Csv -Path $file

Disconnect-VIServer $connexion -Force -Confirm:$false

Snapshot

Liste VM et elurs snapshots

• Script pour lister les VMs ayant un snapshot

#Server VSphere
$server = "adresse-VCenter"

#Connexion au vsphere
$connexion = Connect-VIServer -Server $server -WarningAction SilentlyContinue

#Liste des VM avec le nom du snapshot et la description
Get-VM | Get-Snapshot | Select VM,Name,Description

pause

Disconnect-VIServer -Server $connexion -Force -Confirm:$false

• Script pour réaliser un rapport des snapshot et l'envoyer par mai

Param (
    [Alias("Host")]
    [string]$VIServer = "",
    [string]$User = "",
    [string]$Password="",
    [string]$PathToReport,
    [string]$CredentialFile="credential-vsphere.xml",
    
    [string]$To = "nagios@pass.be",
    [string]$From = "report-vmware@pass.be",
    [string]$SMTPServer = "mail.pass.be"
)

$Header = @"
<style>
TABLE {border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}
TR:Hover TD {Background-Color: #C1D5F8;}
TH {border-width: 1px;padding: 3px;border-style: solid;border-color: black;background-color: #6495ED;}
TD {border-width: 1px;padding: 3px;border-style: solid;border-color: black;}
.odd  { background-color:#ffffff; }
.even { background-color:#dddddd; }
</style>
<title>
Snapshot Report - $VIServer
</title>
"@

Function Set-AlternatingRows {
    [CmdletBinding()]
         Param(
             [Parameter(Mandatory=$True,ValueFromPipeline=$True)]
             [object[]]$HTMLDocument,
      
             [Parameter(Mandatory=$True)]
             [string]$CSSEvenClass,
      
             [Parameter(Mandatory=$True)]
             [string]$CSSOddClass
         )
     Begin {
         $ClassName = $CSSEvenClass
     }
     Process {
         [string]$Line = $HTMLDocument
         $Line = $Line.Replace("<tr>","<tr class=""$ClassName"">")
         If ($ClassName -eq $CSSEvenClass)
         {    $ClassName = $CSSOddClass
         }
         Else
         {    $ClassName = $CSSEvenClass
         }
         $Line = $Line.Replace("<table>","<table width=""50%"">")
         Return $Line
     }
}

#Desactiver la securité 
#Set-ExecutionPolicy RemoteSigned

#Chargement du module Vmware
If (-not (Get-PSSnapin VMware.VimAutomation.Core -ErrorAction SilentlyContinue))
{   Try { Add-PSSnapin VMware.VimAutomation.Core -ErrorAction Stop }
    Catch { Throw "Problem loading VMware.VimAutomation.Core snapin because ""$($Error[1])""" }
}

#Récupération du fichier avec les identifiants
$PathCredentialFile = Split-Path $Script:MyInvocation.MyCommand.Path -Parent
$PathCredentialFile += "\" + $CredentialFile
$PathCredentialFile 

$credential = Get-VICredentialStoreItem -File $PathCredentialFile

#Affectation de la variable VIServer
$VIServer = $credential.Host

#Connexion au vsphere
$connection = Connect-VIServer -Server $credential.Host -User $credential.User -Password $credential.Password -WarningAction SilentlyContinue

$Report = Get-VM | Get-Snapshot | Select VM,Name,Description,@{Label="Size";Expression={"{0:N2} GB" -f ($_.SizeGB)}},Created
If (-not $Report)
{  $Report = New-Object PSObject -Property @{
      VM = "No snapshots found on any VM's controlled by $VIServer"
      Name = ""
      Description = ""
      Size = ""
      Created = ""
   }
}



$Report = $Report | Select VM,Name,Description,Size,Created | ConvertTo-Html -Head $Header -PreContent "<p><h2>Snapshot Report - $VIServer</h2></p><br>" | Set-AlternatingRows -CSSEvenClass even -CSSOddClass odd
	
#Si on veut enregistrer le rapport à un endroit
#$Report | Out-File $PathToReport\SnapShotReport.html

#Fonction d'envoi de mail
$MailSplat = @{
    To         = $To
    From       = $From
    Subject    = "$VIServer Snapshot Report"
    Body       = ($Report | Out-String)
    BodyAsHTML = $true
    SMTPServer = $SMTPServer
}

Send-MailMessage @MailSplat

#Deconnexion du VIServer sans prompt
Disconnect-VIServer -Server $connection -Force -Confirm:$false

Datastore

Liste des VM par datastore

Param (
    [Alias("Host")]
    [string]$VIServer = "",
    [string]$User = "",
    [string]$Password="",
    [string]$PathToReport,
    [string]$CredentialFile="credential-vsphere.xml",
    
    [string]$To = "",
    [string]$From = "",
    [string]$SMTPServer = "",

    [boolean]$ExportCsv = $false,
    [string]$DirecteoryCsv = ""

)

#Variables static
$date = Get-Date -Format yyyy.MM.dd
$fileNameCSV = ""+$date+"-report-datastore-vm.csv"
#Tableau récupérant le contenu a exporter
$content=@()

#Récupération du fichier avec les identifiants
$PathCredentialFile = Split-Path $Script:MyInvocation.MyCommand.Path -Parent
$PathCredentialFile += "\" + $CredentialFile
#Affichage de debug pour le fichier credential
#$PathCredentialFile

#Création de l'objet avec les informations de connexion
$credential = Get-VICredentialStoreItem -File $PathCredentialFile

#Conexion au serveur
$connexion = Connect-VIServer -Server $credential.Host -User $credential.User -Password $credential.Password -WarningAction SilentlyContinue

#Récupération des datastore et des VMs associées.
Get-Datacenter | Get-Datastore | Foreach-Object {
    $datastore= $_.Name
    $content += $_ | Get-VM | Select-Object @{n='DataStore';e={$datastore}},Name
}

if($ExportCsv)
{
    write-Host "Export en CSV"

    #Ficher CSV de sortie
    if ( $DirecteoryCsv -eq "" )
    {
        $FileCsv = ".\"+$fileNameCSV
    }
    else
    {
        $FileCsv = $DirecteoryCsv+"\"+$fileNameCSV
    }

    #Export du contenu en CSV
    $content | Export-Csv -Path $FileCsv -NoTypeInformation
}

$content

Disconnect-VIServer -Server $connexion -Force -Confirm:$false