{"id":128,"date":"2016-06-29T12:44:28","date_gmt":"2016-06-29T12:44:28","guid":{"rendered":"http:\/\/vblog.hochsticher.de\/?p=128"},"modified":"2023-03-30T10:40:41","modified_gmt":"2023-03-30T08:40:41","slug":"report-your-vm-growth-per-cluster-part-2of2-format-data","status":"publish","type":"post","link":"https:\/\/vblog.hochsticher.de\/?p=128","title":{"rendered":"Report your VM growth per Cluster (Part 2of2 Format Data)"},"content":{"rendered":"

In my last post, we collected data with PowerCLI scripts to build some graphs and numbers in Excel.<\/p>\n

Let’s start fomating this data!<\/p>\n

<\/p>\n

The prerequisite is our 4 Reports we created earlier:<\/em><\/p>\n

    \n
  1. VMs per Cluster<\/em><\/li>\n
  2. Count Guest OS<\/em><\/li>\n
  3. Host Inventory<\/em><\/li>\n
  4. Datastore Inventory<\/em><\/em><\/li>\n<\/ol>\n
    \n

    First we create a new Spreadsheet with 5 Tabs.<\/p>\n

    \"excel-tabs\"<\/p>\n

    For all reports we do an import “from web” (sorry for my german Excel, but I’m sure you will find the options we need)<\/em><\/p>\n

    like this:<\/p>\n

    \"import-vms\"<\/p>\n

    Place the adress to your reports location.<\/em><\/p>\n

    Go straight forward with the others.<\/p>\n

    \n

    Total VMs per Cluster Chart<\/strong><\/p>\n

    When you imported all your reports, go to “Report”- tab and insert a line graph.<\/p>\n

    You select the data like this:<\/p>\n

    \n\n\n \t

    \n [Show slideshow]<\/a>\n\t\t\n\t<\/div>\n\t\t\t\n\t\t\t\t