Get CPU metric data of N days as per desired input from user for all the VMs in an azure subscription.
- PowerShell version: 5
- Install following module: Install-Module ImportExcel
This script is used to get the metric named average CPU for last 90 days for all the VMs provided by input csv. CSV must contain two fields: VM name and Resource group name.
- Path of CSV which contains VM name and Resource groups to which they belong
- Path where the output needs to be stored.
Output of this gives you average CPU utilization of each VM in last 90 days in form of CSV with two fields: Timestamp, Average