{"id":326,"date":"2016-09-08T14:13:42","date_gmt":"2016-09-08T12:13:42","guid":{"rendered":"http:\/\/blog.purplescreen.fr\/?p=326"},"modified":"2016-10-14T13:50:34","modified_gmt":"2016-10-14T11:50:34","slug":"etude-powercli-les-vms","status":"publish","type":"post","link":"http:\/\/blog.purplescreen.fr\/?p=326","title":{"rendered":"Etude PowerCLI – Informations sur les VMs"},"content":{"rendered":"

Introduction :<\/h4>\n

Voici une commande PowerCLI qui pourra j’esp\u00e8re vous aider un jour. Elle vous permet de lister l’ensemble de vos VMs selon le trie de votre choix et d’exporter en CSV.<\/p>\n

Pre-requis :<\/h4>\n

Il faut avoir install\u00e9 le module PowerCLI sur une machine de votre r\u00e9seau de management et que nous puissions contacter le vCenter. Il faudra faire une connexion en PowerCLI au vCenter.<\/p>\n

> Connect-VIServer <MonServeurvCenter> -User <Utilisateur> -Password <MotdePass><\/pre>\n
Exemples de Script :<\/h4>\n
Nous allons partir d’une commande\u00a0simple que nous allons faire \u00e9voluer au fur et \u00e0\u00a0mesure.<\/p>\n
> Get-VM<\/pre>\n
Depuis cette commande, nous pouvons lister l’ensemble des VMs pr\u00e9sentes sur notre infrastructure. Nous pouvons faire un tris suivant l’\u00e9tat des VMs, par exemple je souhaite visualiser les VMs d\u00e9marrer.<\/p>\n
>\u00a0Get-VM | Where-Object {$_.PowerState -eq \"PoweredOn\"}\r\n<\/pre>\n
Pour exporter au format CSV, il nous suffira d’ajouter la commande Export-Csv <AvecLeChemin>.<\/p>\n
> Get-VM | Where-Object {$_.PowerState -eq \"PoweredOn\"} | Export-Csv \"c:\\LAB.csv\"\r\n<\/pre>\n
Comme nous pouvons le constater, on r\u00e9cup\u00e8re beaucoup de valeurs, nous pouvons faire une s\u00e9lection des valeurs que nous souhaitons par exemple pour r\u00e9cup\u00e9rer Le nom de la VM, l’\u00e9tat actuel, le nombre de CPU, la taille de la Memoire en GB.<\/p>\n
> Get-VM | Where-Object {$_.PowerState -eq \"PoweredOn\"} | Select-Object Name,PowerState,NumCPU,MemoryGB | Export-Csv \"c:\\LAB2.csv\"<\/pre>\n
Si nous souhaitons afficher les VMs avec plus de 1 CPU.<\/p>\n
Get-VM | Where-Object {$_.PowerState -eq \"PoweredOn\"} | Where-Object {$_.NumCPU -gt \"1\"} | Select-Object Name,PowerState,NumCPU,MemoryGB | Export-CSV \"c:\\LAB3.CSV\"\r\n<\/pre>\n
Pour rappel, les options sont les suivantes
\n\"OptionPowerShell\"<\/h6>\n
Si vous souhaitez faire un trie sur le nom des VMs, vous pouvez ajouter -Name <NomdemesVm>. Par exemple, si je souhaite avoir toutes les VMs commencent par vSphere.<\/p>\n
> Get-VM -Name vSphere* | Where-Object {$_.PowerState -eq \"PoweredOn\"} | Where-Object {$_.NumCPU -gt \"1\"} | Select-Object Name,PowerState,NumCPU,MemoryGB | Export-CSV \"c:\\LAB3.CSV\"<\/pre>\n
Have Fun!<\/p>\n","protected":false},"excerpt":{"rendered":"
Introduction : Voici une commande PowerCLI qui pourra j’esp\u00e8re vous aider un jour. Elle vous permet de lister l’ensemble de vos VMs selon le trie de votre choix et d’exporter en CSV. Pre-requis : Il faut avoir install\u00e9 le module PowerCLI sur une machine de votre r\u00e9seau de management et que nous puissions contacter le…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[11,10,14],"tags":[26,19,16],"yoast_head":"\nEtude PowerCLI - Informations sur les VMs - PurpleScreen<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/blog.purplescreen.fr\/?p=326\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ogosselin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/blog.purplescreen.fr\/?p=326\",\"url\":\"http:\/\/blog.purplescreen.fr\/?p=326\",\"name\":\"Etude PowerCLI - Informations sur les VMs - PurpleScreen\",\"isPartOf\":{\"@id\":\"http:\/\/blog.purplescreen.fr\/#website\"},\"datePublished\":\"2016-09-08T12:13:42+00:00\",\"dateModified\":\"2016-10-14T11:50:34+00:00\",\"author\":{\"@id\":\"http:\/\/blog.purplescreen.fr\/#\/schema\/person\/ad63980c08d122ffe9115ade81b21fd3\"},\"breadcrumb\":{\"@id\":\"http:\/\/blog.purplescreen.fr\/?p=326#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/blog.purplescreen.fr\/?p=326\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/blog.purplescreen.fr\/?p=326#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/blog.purplescreen.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Etude PowerCLI – Informations sur les VMs\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/blog.purplescreen.fr\/#website\",\"url\":\"http:\/\/blog.purplescreen.fr\/\",\"name\":\"PurpleScreen\",\"description\":\"by Olivier Gosselin\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/blog.purplescreen.fr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"http:\/\/blog.purplescreen.fr\/#\/schema\/person\/ad63980c08d122ffe9115ade81b21fd3\",\"name\":\"ogosselin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/blog.purplescreen.fr\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/0.gravatar.com\/avatar\/6a053a3dca3cccbeecd37d492189f38f?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/0.gravatar.com\/avatar\/6a053a3dca3cccbeecd37d492189f38f?s=96&d=mm&r=g\",\"caption\":\"ogosselin\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/olivier-gosselin-30090498\/\"],\"url\":\"http:\/\/blog.purplescreen.fr\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Etude PowerCLI - Informations sur les VMs - PurpleScreen","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/blog.purplescreen.fr\/?p=326","twitter_misc":{"Written by":"ogosselin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/blog.purplescreen.fr\/?p=326","url":"http:\/\/blog.purplescreen.fr\/?p=326","name":"Etude PowerCLI - Informations sur les VMs - PurpleScreen","isPartOf":{"@id":"http:\/\/blog.purplescreen.fr\/#website"},"datePublished":"2016-09-08T12:13:42+00:00","dateModified":"2016-10-14T11:50:34+00:00","author":{"@id":"http:\/\/blog.purplescreen.fr\/#\/schema\/person\/ad63980c08d122ffe9115ade81b21fd3"},"breadcrumb":{"@id":"http:\/\/blog.purplescreen.fr\/?p=326#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/blog.purplescreen.fr\/?p=326"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/blog.purplescreen.fr\/?p=326#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/blog.purplescreen.fr\/"},{"@type":"ListItem","position":2,"name":"Etude PowerCLI – Informations sur les VMs"}]},{"@type":"WebSite","@id":"http:\/\/blog.purplescreen.fr\/#website","url":"http:\/\/blog.purplescreen.fr\/","name":"PurpleScreen","description":"by Olivier Gosselin","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/blog.purplescreen.fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/blog.purplescreen.fr\/#\/schema\/person\/ad63980c08d122ffe9115ade81b21fd3","name":"ogosselin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/blog.purplescreen.fr\/#\/schema\/person\/image\/","url":"http:\/\/0.gravatar.com\/avatar\/6a053a3dca3cccbeecd37d492189f38f?s=96&d=mm&r=g","contentUrl":"http:\/\/0.gravatar.com\/avatar\/6a053a3dca3cccbeecd37d492189f38f?s=96&d=mm&r=g","caption":"ogosselin"},"sameAs":["https:\/\/www.linkedin.com\/in\/olivier-gosselin-30090498\/"],"url":"http:\/\/blog.purplescreen.fr\/?author=1"}]}},"_links":{"self":[{"href":"http:\/\/blog.purplescreen.fr\/index.php?rest_route=\/wp\/v2\/posts\/326"}],"collection":[{"href":"http:\/\/blog.purplescreen.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.purplescreen.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.purplescreen.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.purplescreen.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=326"}],"version-history":[{"count":26,"href":"http:\/\/blog.purplescreen.fr\/index.php?rest_route=\/wp\/v2\/posts\/326\/revisions"}],"predecessor-version":[{"id":400,"href":"http:\/\/blog.purplescreen.fr\/index.php?rest_route=\/wp\/v2\/posts\/326\/revisions\/400"}],"wp:attachment":[{"href":"http:\/\/blog.purplescreen.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=326"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.purplescreen.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=326"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.purplescreen.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}