Repository navigation
AMA Migration Helper computer counts incorrect #222
Description
The agentmigrationtracker query uses tolower(ComputerName) in several joins to other queries. ComputerName is not required to be unique across subscriptions (or within subs I believe) and so the joins result in inflated counts for VM resources. I believe that ID should be used but still trying to confirm that.
Activity
shaneholder commentedon May 9, 2024
I changed the parse id in the query to use the full id for the virtualmachines and then to use the id just up to '/extensions' for the extensions. That seems to work. Unfortunately due to corporate restrictions I'm having issues getting the code here. An additional thing I was curious about is if we should be excluding databrick instances from the list.