I heard from Ariel Sanchez that he needed something tested. It was vDocumentation and him and Edgar Sanchez had something very cool. I want to share it with you as I think it very handy. It produces very nice reports on your vSphere environment. Lets see how to get it working and produce some reports.
The home of this project is in this GitHub location. But all the info you need is right here in this article.
- Have PowerCLI installed – preferably 6.5.2, and be in PowerCLI and execute these commands:
Install-Module ImportExcel -scope CurrentUser
Install-Module vDocumentation -scope CurrentUser
- If you have errors when executing those commands you can add -force at the end of the line.
- If you have installed this cool stuff a few weeks ago you should do:
- If you want to learn what version you have, you can use the following command:
Get-Module vDocumentation -ListAvailable | Format-List
- If you want help on one of the commands you can get it.
get-help Get-ESXSpeculativeExecution -full
Now connect to your vCenter (Connect-VIserver -server vcName) and execute the following commands:
Get-ESXInventory -ExportExcel -folderpath c:\
Get-ESXIODevice -ExportExcel -folderpath c:\
Get-ESXNetworking -ExportExcel -folderpath c:\
Get-ESXStorage -ExportExcel -folderpath c:\
Get-ESXPatching -ExportExcel -folderpath c:\
Get-ESXSpeculativeExecution -ExportExcel -folderpath c:\
Storage red errors gone in version v2.4.3.
Note that there may be some red errors on the Get-ESXStorage but I can tell you they know and are working on it – confirmed that the red with the storage still occurs in my lab (still see the errors in up to and including 2.4.1).
Once the reports are done, and you look in the location where they are written too – by default – your current folder so for me c:\scripts or where you set on the command line.
Below is screenshots of each report. But only the first part, with each one you could scroll down and right in Excel. They are very detailed reports.
There you have it. With very little work, and very little config, you end up with a number of very detailed Excel spreadsheets on your vSphere environment. Very handy stuff and I sure like how easy it is to install and update!
- 7/27/18 – test this with latest version of PowerShell / PowerCLI (as of today) and vSphere 6.7. Mostly worked perfect. I had an error on networking due to a Veeam created switch, and and error in patching due to no patches installed and no downloaded patches – I think that it is. But the reports all produced and look right. Maybe missing info but not much.
- 4/28/18 – red storage errors gone in 2.4.3. I used PowerCLI 10.1.0 and all was good.
- 3/25/18 – v2.41 and it works good. Some big changes – where are described in this article. My PowerShell can connect to the Internet so I did not have to download or import files. As well, I have not worked out some of the new parameters so have not updated my example commands above yet.
- 2/4/18 – added new default location above.
- 1/11/18 – and now another updated with more VMware checking for Speculative type stuff. Nice job!
- 1/9/18 – added in the GEt-ESXSpeculativeExecution option, and did some spell checking and added in the patching screen. Also added the comment about -folderpath.
- 12/16/17 – added in the new Get-ESXPatching. Still see the errors in red on storage in 2.0. I need to update the screenshots above, particularly Inventory, and add patching. Will do it soon.
- 10/18/17 – I did the Update-Module vDocumentation and there was an update. Came down fine. Here is the readme from GitHub. One thing I see I really like is that the default path is much easier and logical now – c:\users\your_user_name. I have also used this with PowerCLI 6.5.3 with no issue. If your Get-Module shows you multiple vDocumentation, then use uninstall-module vDocumentation once for each installed version, then install again and you will only have the latest. No matter how many versions you have installed, you will only execute the latest.
=== END ===