Describe the bug
The retirement.kql code doesn't contain the latest retired VM SKU's issued by Microsoft
https://learn.microsoft.com/en-us/azure/virtual-machines/sizes/retirement/retired-sizes-list
To Reproduce
Run the report against a subscription with retired VM SKU's and no results are produced.
Expected behavior
The retired SKU's should be detected and reported on
Not sure if there's a way around that other than manually updating the query, but I added this to mine and it's working.
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_d", 1000,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_ds", 1001,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_dv2", 1002,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_dsv2", 1003,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_av2", 1004,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_amv2", 1005,
(tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_b" and tolower(tostring(properties.hardwareProfile.vmSize)) contains "v1"), 1006,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_f", 1007,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_fs", 1008,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_fsv2", 1009,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_g", 1010,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_gs", 1011,
tolower(tostring(properties.hardwareProfile.vmSize)) contains "m192", 1012,
tolower(tostring(properties.hardwareProfile.vmSize)) contains "nvv3", 1013,
tolower(tostring(properties.hardwareProfile.vmSize)) contains "nvv4", 1014,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_nv", 1015
Describe the bug
The retirement.kql code doesn't contain the latest retired VM SKU's issued by Microsoft
https://learn.microsoft.com/en-us/azure/virtual-machines/sizes/retirement/retired-sizes-list
To Reproduce
Run the report against a subscription with retired VM SKU's and no results are produced.
Expected behavior
The retired SKU's should be detected and reported on
Not sure if there's a way around that other than manually updating the query, but I added this to mine and it's working.
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_d", 1000,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_ds", 1001,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_dv2", 1002,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_dsv2", 1003,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_av2", 1004,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_amv2", 1005,
(tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_b" and tolower(tostring(properties.hardwareProfile.vmSize)) contains "v1"), 1006,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_f", 1007,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_fs", 1008,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_fsv2", 1009,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_g", 1010,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_gs", 1011,
tolower(tostring(properties.hardwareProfile.vmSize)) contains "m192", 1012,
tolower(tostring(properties.hardwareProfile.vmSize)) contains "nvv3", 1013,
tolower(tostring(properties.hardwareProfile.vmSize)) contains "nvv4", 1014,
tolower(tostring(properties.hardwareProfile.vmSize)) startswith "standard_nv", 1015