- \n
- VMs per Cluster<\/em><\/li>\n
- Count Guest OS<\/em><\/li>\n
- Host Inventory<\/em><\/li>\n
- Datastore Inventory<\/em><\/em><\/li>\n<\/ol>\n
\nFirst we create a new Spreadsheet with 5 Tabs.<\/p>\n
![\"excel-tabs\"](\"https:\/\/test.hochsticher.de\/wp-content\/uploads\/2016\/06\/excel-tabs-300x30.jpg\")
<\/p>\nFor 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\"](\"https:\/\/test.hochsticher.de\/wp-content\/uploads\/2016\/06\/import-vms-300x256.jpg\")
<\/p>\nPlace the adress to your reports location.<\/em><\/p>\n
Go straight forward with the others.<\/p>\n
\nTotal 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
- Count Guest OS<\/em><\/li>\n
![\n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\t\t\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\n\t\t\n\t<\/div>\t<\/div>\n<\/p>\n\nGuest OS Chart<\/strong><\/p>\nto view the Guest OS Counts you insert a new graph with the following settings:<\/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\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\t\t\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\n\t\t\n\t<\/div>\t<\/div>\n<\/p>\n\nReport All VMs Chart<\/strong><\/p>\nfor the last report we have to use a Excel function to get the last value in the column. Important for this function is, that you enter it with “CTRL+SHIFT+ENTER”<\/em><\/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\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\t\t\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\t\t\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\n\t\t\n\t<\/div>\t<\/div>\n<\/p>\n\nThe complete sample file you can get here:<\/p>\nReport-VM-growth-per-Cluster<\/a><\/p>\nOf course, the automatic connection to the report files is cancelled in this file.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"In my last post, we collected data with PowerCLI scripts to build some graphs and numbers in Excel. Let’s start fomating this data!<\/p>\n","protected":false},"author":1,"featured_media":197,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[4,5,7],"tags":[],"class_list":["post-128","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powercli","category-reports","category-vsphere"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t](\"http:\/\/vblog.hochsticher.de\/wp-content\/gallery\/report3vms\/data-source-vms.JPG\"\n){kind=link}
![\n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\n\t\t\n\t<\/div>\t<\/div>\n<\/p>\n\nGuest OS Chart<\/strong><\/p>\nto view the Guest OS Counts you insert a new graph with the following settings:<\/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\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\t\t\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\n\t\t\n\t<\/div>\t<\/div>\n<\/p>\n\nReport All VMs Chart<\/strong><\/p>\nfor the last report we have to use a Excel function to get the last value in the column. Important for this function is, that you enter it with “CTRL+SHIFT+ENTER”<\/em><\/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\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\t\t\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\t\t\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\n\t\t\n\t<\/div>\t<\/div>\n<\/p>\n\nThe complete sample file you can get here:<\/p>\nReport-VM-growth-per-Cluster<\/a><\/p>\nOf course, the automatic connection to the report files is cancelled in this file.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"In my last post, we collected data with PowerCLI scripts to build some graphs and numbers in Excel. Let’s start fomating this data!<\/p>\n","protected":false},"author":1,"featured_media":197,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[4,5,7],"tags":[],"class_list":["post-128","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powercli","category-reports","category-vsphere"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t](\"http:\/\/vblog.hochsticher.de\/wp-content\/gallery\/report3vms\/vm-chart.JPG\"\n){kind=link}
![\n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\t\t\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\n\t\t\n\t<\/div>\t<\/div>\n<\/p>\n\nReport All VMs Chart<\/strong><\/p>\nfor the last report we have to use a Excel function to get the last value in the column. Important for this function is, that you enter it with “CTRL+SHIFT+ENTER”<\/em><\/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\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\t\t\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\t\t\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\n\t\t\n\t<\/div>\t<\/div>\n<\/p>\n\nThe complete sample file you can get here:<\/p>\nReport-VM-growth-per-Cluster<\/a><\/p>\nOf course, the automatic connection to the report files is cancelled in this file.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"In my last post, we collected data with PowerCLI scripts to build some graphs and numbers in Excel. Let’s start fomating this data!<\/p>\n","protected":false},"author":1,"featured_media":197,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[4,5,7],"tags":[],"class_list":["post-128","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powercli","category-reports","category-vsphere"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t](\"http:\/\/vblog.hochsticher.de\/wp-content\/gallery\/guestos\/data-source-guestos.JPG\"\n){kind=link}
![\n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\n\t\t\n\t<\/div>\t<\/div>\n<\/p>\n\nReport All VMs Chart<\/strong><\/p>\nfor the last report we have to use a Excel function to get the last value in the column. Important for this function is, that you enter it with “CTRL+SHIFT+ENTER”<\/em><\/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\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\t\t\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\t\t\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\n\t\t\n\t<\/div>\t<\/div>\n<\/p>\n\nThe complete sample file you can get here:<\/p>\nReport-VM-growth-per-Cluster<\/a><\/p>\nOf course, the automatic connection to the report files is cancelled in this file.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"In my last post, we collected data with PowerCLI scripts to build some graphs and numbers in Excel. Let’s start fomating this data!<\/p>\n","protected":false},"author":1,"featured_media":197,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[4,5,7],"tags":[],"class_list":["post-128","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powercli","category-reports","category-vsphere"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t](\"http:\/\/vblog.hochsticher.de\/wp-content\/gallery\/guestos\/guestos-chart.JPG\"\n){kind=link}
![\n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\t\t\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\t\t\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\n\t\t\n\t<\/div>\t<\/div>\n<\/p>\n\nThe complete sample file you can get here:<\/p>\nReport-VM-growth-per-Cluster<\/a><\/p>\nOf course, the automatic connection to the report files is cancelled in this file.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"In my last post, we collected data with PowerCLI scripts to build some graphs and numbers in Excel. Let’s start fomating this data!<\/p>\n","protected":false},"author":1,"featured_media":197,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[4,5,7],"tags":[],"class_list":["post-128","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powercli","category-reports","category-vsphere"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t](\"http:\/\/vblog.hochsticher.de\/wp-content\/gallery\/all-vms-chart\/function-allvms.JPG\"\n){kind=link}
![\n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\t\t\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\n\t\t\n\t<\/div>\t<\/div>\n<\/p>\n\nThe complete sample file you can get here:<\/p>\nReport-VM-growth-per-Cluster<\/a><\/p>\nOf course, the automatic connection to the report files is cancelled in this file.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"In my last post, we collected data with PowerCLI scripts to build some graphs and numbers in Excel. Let’s start fomating this data!<\/p>\n","protected":false},"author":1,"featured_media":197,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[4,5,7],"tags":[],"class_list":["post-128","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powercli","category-reports","category-vsphere"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t](\"http:\/\/vblog.hochsticher.de\/wp-content\/gallery\/all-vms-chart\/data-source-allvms.JPG\"\n){kind=link}
![\n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\n\t\t\n\t<\/div>\t<\/div>\n<\/p>\n\nThe complete sample file you can get here:<\/p>\nReport-VM-growth-per-Cluster<\/a><\/p>\nOf course, the automatic connection to the report files is cancelled in this file.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"In my last post, we collected data with PowerCLI scripts to build some graphs and numbers in Excel. Let’s start fomating this data!<\/p>\n","protected":false},"author":1,"featured_media":197,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[4,5,7],"tags":[],"class_list":["post-128","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powercli","category-reports","category-vsphere"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t](\"http:\/\/vblog.hochsticher.de\/wp-content\/gallery\/all-vms-chart\/allvms-chart.JPG\"\n){kind=link}