Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

AMA Migration Helper computer counts incorrect #222

Open
shaneholder opened this issue May 9, 2024 · 1 comment
Open

AMA Migration Helper computer counts incorrect #222

shaneholder opened this issue May 9, 2024 · 1 comment

Comments

@shaneholder
Copy link

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.

@shaneholder
Copy link
Author

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant