Azure Inventory using Powershell

Want to know about innovative and interesting ideas in Azure and automation? Check out my blog: https://manjunathrao.com.Version 2.0:I have changed the design of this script. It no longer creates a single Excel sheet. Rather, produces a CSV file for individual services inside ind

 
 
 
 
 
4.7 Star
(6)
16,894 times
Add to favorites
Windows Azure
10/24/2019
E-mail Twitter del.icio.us Digg Facebook
  • Export Reports
    1 Posts | Last post November 07, 2019
    • please share the power script to get the reports:
      need reports Firewall and Virtual Network rules for all PaaS Services (Key Vault, Storage Accounts, Data Lake Store, Data Lake Analytics, Event Hubs, Function Apps, Web Apps, Logic Apps)
      
      Thank you
  • Error when running script from RunBook
    1 Posts | Last post September 04, 2019
    • Every time I try to run this script from I get the following error. Unable to acquire token for tenant 'Common' 
  • Can you update the script to fix the following errors?
    1 Posts | Last post August 28, 2019
    • 
      WARNING: Breaking changes in the cmdlet 'Get-AzureRmVirtualNetwork' :
      WARNING:  - "The output type 'Microsoft.Azure.Commands.Network.Models.PSVirtualNetwork' is changing"
       - The following properties in the output type are being deprecated :
       'EnableVmProtection'
  • azure inventory script
    1 Posts | Last post July 10, 2019
    • please you can add public ip , available set , os disk size, data disk fields and size fields in vm .
  • Get Tags
    5 Posts | Last post May 13, 2019
    • Hi Manjunath,
      
      great script,
      
      I have one question, is it possible to also gather the azure tags? We are tagging the resources with many important info, it would be great to have them together in the output your script gives.
      
      Thanks!
    • Hello kopko222,
      
      Thank you for using my script. I will work on this request and update the script.
    • Could you please elaborate more? Do you want to generate a report of resources based on tags? or do you want me to add an extra column to the report that this script generates? 
    • Hi Manjunath,
      
      Thanks for your reply,
      What I had in mind, was to get report of tags based on resource or resource group level. We are tagging all the Rg's with important info like: requestor, environment, approver, costcenter, app owner etc. Those are all very important info which allows us to filter the resources easily. If you could think of a capability to add this, it would be really welcomed!
      
      Thanks for your effort!
    • @@Manjunath i Need your help to get report of tags based on resource or resource group level. We are tagging all the Rg's with important info like: requestor, environment, approver, costcenter, app owner etc. Those are all very important info which allows us to filter the resources easily
  • I am getting the error while running the script
    2 Posts | Last post April 04, 2019
    • login-azurermaccount : The browser based authentication dialog failed to complete. Reason: The download has failed
      (the connection was interrupted).
      At C:\AzureInventory_V2.ps1:17 char:5
      +     login-azurermaccount
      +     ~~~~~~~~~~~~~~~~~~~~
          + CategoryInfo          : CloseError: (:) [Connect-AzureRmAccount], AadAuthenticationFailedException
          + FullyQualifiedErrorId : Microsoft.Azure.Commands.Profile.ConnectAzureRmAccountCommand
    • Hello Chanchal,
      
      Thank you for using my script. This error is due to proxy settings. Please check your proxy settings and try the script again.
  • Traffic Manager
    1 Posts | Last post January 19, 2019
    • Amazing script brother!
      
      Any change you could add these two:
      Traffic Manager profiles, configuration, endpoints
      VPN Gateways, connections, status, IP, configuration
      
      Thank you!
  • Add Disk Type & Size which are attached to VM
    2 Posts | Last post January 05, 2019
    • In current Script, we have VMSize,OSDisk,AdminUserName,	NICID
      Kindly add disk type & disk size for the disk's which are attached to VM.
      
    • Hello Nayan,
      
      Thank you for using the script. Microsoft does not expose the "used" size of disks, so I am not able to get that information for you.
      
      The attached data disks and their name is contained under the "DataDisksNames" column.
      
      Thanks,
  • public ip attribute
    1 Posts | Last post December 06, 2018
    • can you add in the public IP attribute for vm details csv 
      
                $virtual_machine_object_temp | add-member -membertype NoteProperty -name "NICId" -Value $azureVMDetails_Iterator.NetworkProfile.NetworkInterfaces.id
                  $virtual_machine_object_temp | add-member -membertype NoteProperty -name "OSVersion" -Value $azureVMDetails_Iterator.StorageProfile.ImageReference.Sku
                  $virtual_machine_object_temp | add-member -membertype NoteProperty -name "PrivateIP" -Value $private_ip_address
                  $virtual_machine_object_temp | add-member -membertype NoteProperty -name "ManagedOSDiskURI" -Value $os_disk_details_managed
                  $virtual_machine_object_temp | add-member -membertype NoteProperty -name "UnManagedOSDiskURI" -Value $os_disk_details_unmanaged
  • NSG information
    1 Posts | Last post October 04, 2018
    • Hi, 
      
      I found 2 problems with NSG , first in the csv I didn't find NSG Name, also we only have one line for NSG, I solved it, 
      
      1. 
       foreach($azureNSGDetails_Iterator in $azureNSGDetails){
                  # $network_security_groups_object = $null
                  #$network_security_groups_object = @()
                 
       -->           $nsgname =  $azureNSGDetails_Iterator.Name 
                  
              
              
      
                  $securityRulesPerNSG = $azureNSGDetails_Iterator.SecurityRules
                  echo "********** $securityRulesPerNSG *********"
      
                  foreach($securityRulesPerNSG_Iterator in $securityRulesPerNSG) {
      
                      $network_security_groups_object_temp = new-object PSObject
       -->               $network_security_groups_object_temp | add-member -MemberType        NoteProperty -Name "NameSG" -Value $nsgname
      
      2.   
         # Setting the pointer to the next row and first column
                  
        -->             $network_security_groups_object += $network_security_groups_object_temp
                      
                  }
      
      
1 - 10 of 19 Items