This PowerShell and PowerTool script connects to one or more standalone UCS C-series and E-series servers querying it/them for hardware details. Using that information it generates an excel spreadsheet presenting the inventory in the form of an outline. Besides model, part number, etc. it also lists for each element the serial number and firmware version.
There are a few parameters, the most important being '-show' which controls the level of detail you get to see. At level one you see only an overview of the C-series or E-series server At two the scripts adds CPUs and memory, then all the way up to five where you will get detailed info on each and every DIMM.
The advantage of having it in a spreadsheet is that it can be used for modelling the data, for example when doing capacity planning for a tech-refresh. But for others it will be simply a tool for asset tracking.
Few points to be aware of:
- You need to have Cisco IMC PowerTool and Microsoft Office installed on the system running the script.
- Do not install the script in C:\ because for some reason the script doesn't have write access there, put it instead in some user directory.
- This script will store the data retrieved from Cisco IMC in a bunch of csv-files in "C:\Temp", plus two conversion tables to translate the 'model' attribute to 'part number' and back.
- Finally there is the '-v' flag with which you can follow the progress of the script.
If you are looking for a similar script for fetching the inventory details of a UCS domain managed by UCS Manager, go to -