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 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

I have started using github so check out the latest version here