This next script is used to extract the inventory and alert history from Dell Open Manage via the API using Powershell into excel for quick and easy manipulation.

Personally I use this data to help track inventory, firmware, software, etc… for Dell hosts in a visual way but the data can be used in any way as it’s exported into .xlsx

Make sure to install https://github.com/dfinke/ImportExcel otherwise it will not export to excel.

So to the script..

So that I don’t keep being prompted for credentials I save the account user and password with the powershell Get-Credential command.

Script usage for inventory and xls

Script usage for inventory and xls

And now here is the whole script

vMan