我正在尝试使用Powershell Get-AzMetric获取Azure SQL MI实例使用的空间。不知道应在参数-MetricName中输入什么
$Storageaccounts = Get-AzResource -ResourceType microsoft.Sql/managedInstances
FOREACH($Storageaccount in $Storageaccounts){
$ResourceId = $Storageaccount.ResourceId
$Metric = Get-AzMetric -ResourceId $ResourceId -MetricName "Storagespaceused" -Warningaction Ignore
$SQLDBSize = ($Metric.Data | Select-Object -First 1).Total/1024/1024/1024
}
您需要在参数storage_space_used_mb中使用-MetricName。
完美。再次感谢@Joy Wang。
$StorageAccounts = Get-AzResource -ResourceType Microsoft.Sql/managedInstances
FOREACH($StorageAccount in $StorageAccounts){
$ResourceId = $StorageAccount.ResourceId
$Start = (get-date).AddDays(-7)
$End = get-date
$SpaceMetric = Get-AzMetric -ResourceId $ResourceId -MetricName "storage_space_used_mb" -WarningAction Ignore
$IOMetric = Get-AzMetric -ResourceId $ResourceId -MetricName "io_requests" -StartTime $Start -EndTime $End -WarningAction Ignore
$CoreMetric = Get-AzMetric -ResourceId $ResourceId -MetricName "virtual_core_count" -WarningAction Ignore
#Load Variables for SQL Statement.
$TeamGroupName = $SubscriptionID.TeamGroupsName
$ServiceName = $SubscriptionID.ServiceName
$SubscriptionName = $SubscriptionID.SubscriptionName
$SubID = $SubscriptionID.SubscriptionID
$StorageAccountName = $StorageAccount.Name
$StorageType = 'SQL-MI'
$SQLMISize = ($SpaceMetric.Data | Select-Object -First 1).Average/1024
$TotalRequests = ($IOMetric.Data | Select-Object -First 1).Average
$CoreCount = ($CoreMetric.Data | Select-Object -First 1).Average
$Region = $StorageAccount.Location
$RefreshedAt = Get-Date