SOLVED

What is the query to get the information about tagged Virtual machines ?

Copper Contributor

Hello,

 

Basically I want to generate the report for all the tagged Virtual machine from Log analytics. I need to know which VMs are tagged and which are not. Could you please help me out to create the query in l;og analytics please.

 

Thanks,

 

Sachin

7 Replies

Any help would be appreciated..

best response confirmed by Stanislav Zhelyazkov (MVP)
Solution
There isn't a log out of the box that has information on tags for Virtual machines. I would suggest to develop something on your. Create a workflow that daily goes trough all your VMs in all Azure subscription and stores which VMs are tagged and which are not in your Log Analytics workspace. That workflow can be a runbook, logic app or azure functions. Whatever service is best for you to develop on. Once you have the log in Log Analytics you can use the query language to find the information you need.
Thanks Stanislav . Will try that option.

Appreciate your help !!!!!

Hi Sachin

Did you manage to write something for your use case. If yes, would you be able to share details as I need almost the same thing.

 

Regards

Piyush

Hello Piyush,

 

Not at the moment as I am trying to create the Run Book for the same. I will update you once that is ready.

 

Regards,

 

Sachin

@Stanislav Zhelyazkov @Sachin Gupta or we can use the Azure Resource Graph Explorer to get the tag values.

resources
extend Tags = tags.<tag name> ( if you wish to extract the values for a particular tag name)
project name, type, Tags

If you wish to get all tags
resources
summarize by name, type, tags

 

1 best response

Accepted Solutions
best response confirmed by Stanislav Zhelyazkov (MVP)
Solution
There isn't a log out of the box that has information on tags for Virtual machines. I would suggest to develop something on your. Create a workflow that daily goes trough all your VMs in all Azure subscription and stores which VMs are tagged and which are not in your Log Analytics workspace. That workflow can be a runbook, logic app or azure functions. Whatever service is best for you to develop on. Once you have the log in Log Analytics you can use the query language to find the information you need.

View solution in original post