How to Retrieve Month-by-Month VM and VMSS Counts (Historical Data)

Question

Hello everyone,

I’m looking for a way to see how many VMs and VM Scale Sets were running in my Azure subscription each month, going back to 2022. For example:

September 2022: 10 VMs, 3 VM Scale Sets

October 2022: 11 VMs, 4 VM Scale Sets

… and so on.

My main goal is to get a simple monthly total, without needing the exact sizing or cost of each resource. I’ve tried using Cost Management + Billing and exporting usage details, but I want to confirm if there is a straightforward approach or a best practice to precisely track the counts of these resources month by month.

Any suggestions or guidance on how to accomplish this would be greatly appreciated. Thanks in advance!