Powershell – Generate AWS Inventory

As with any managed services or infrastructure services projects, maintaining the server inventory is very crucial. The server-inventory-file provides a one-stop checklist, that you can refer while you are on priority 1 bridge calls.

With traditional data center, it is easy to maintain server/infra inventory in an excel sheet. But it is not the same with cloud, because the infrastructure is so dynamic.

The only solution to this problem is Automation. I have written a powershell script just to do that.

Below is the link for the script:

https://gallery.technet.microsoft.com/scriptcenter/Powershell-Script-to-4e623057

 

Also, check out my blog for Azure Inventory:

https://manjunathrao.com/2016/12/30/powershell-generate-azure-inventory/

If this blog helps even one person on this planet. The purpose of this blog is served.

 

Advertisements

6 comments

  1. Hi, I’ve used your script but the output in the spreadsheet is blank. It has created the worksheets and the heading in all the worksheet but the content is blank, any ideas??

    I don’t get any errors when running the script.

    Like

      1. Thanks for the response, I assume the only credentials I need to edit are the AWS_AccessKey and AWS_SecreyKey??

        Like

  2. The script does not produce any output from function Create-EC2InstanceWorksheet and VirtualMachine worksheet in excel is blank. It populates other 3 sheets. Any ideas?

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s