hint.strategy=shuffle (data

Question

hint.strategy=shuffle (data

Sumit 1

Hi,
I'm trying to build a query using tow different tables like resource & recoveryresouces. If I start query with resources , then I can reuse the table resource using hint.strategy ( data | where type == '') but I'm not able to use hint.strategy for recoveryresources.

In nutshell,
I'm pulling VM Resources & extension using resources table .Similarly I want to pull the data for Back & ASR as well in the same query but I cant use same table twice & instead using hint.strategy =shuffle but it works for resources only & not for recoveryresources.

Sadiqh Ahmed 49,571 Reputation points Microsoft External Staff Moderator

2023-08-09T11:11:08.26+00:00

Hello @Sumit Thank you for reaching out to us on Microsoft Q&A platform. Apologies for delayed response!

Could you please share the complete query?
Sadiqh Ahmed 49,571 Reputation points Microsoft External Staff Moderator

2023-08-11T07:05:46.8566667+00:00

@Sumit Appreciate if you could help us with more details/share the query that you are running.
Sadiqh Ahmed 49,571 Reputation points Microsoft External Staff Moderator

2023-08-14T07:28:17.8266667+00:00

@Sumit We haven't heard back from you. Please reply if you have any questions in this matter and we will gladly continue the discussion.

Sumit 1

Here is the query.
KQL doesnt allow to use same table twice if I use hint.strategy= shuffle , it only allows me to use Table which is called out in the beginning but If I want to call recoveryservicesresources table using hint.strategy it wont give me any data as it still points to resources. So, my query how can I call two different table twice in the query like resources & recoveryservicesresources

resources
| where type =~ 'microsoft.compute/virtualmachines'
| extend VMName=name
| join kind=leftouter hint.strategy=shuffle (data
| where type == "microsoft.compute/virtualmachines/extensions"
| where name =~ 'DependencyAgent'
| extend VMName=tostring(split(id,'/')[8])
| project VMName, ExtensionName=name) on VMName
| project-away VMName1
| join kind= leftouter (recoveryservicesresources
| where type == 'microsoft.recoveryservices/vaults/backupfabrics/protectioncontainers/protecteditems'
|project VMName= tolower(tostring(properties.friendlyName))) on VMName

Sadiqh Ahmed 49,571 Reputation points Microsoft External Staff Moderator

2023-08-28T14:44:34.9833333+00:00

@Sumit The query which you provided is working for me in internal environment and not throwing any error.

The ARG documentation also doesn't explicitly call out that above scenario is unsupported, so I'm guessing it should be supported.

To get a more detailed answer, can you raise a doc feedback item on this article - https://learn.microsoft.com/azure/governance/resource-graph/concepts/query-language#supported-kql-language-elements

and share error details/screenshot if applicable?
Sadiqh Ahmed 49,571 Reputation points Microsoft External Staff Moderator

2023-08-30T17:02:13.7366667+00:00

@Sumit Have you had a chance to see the previous response? If the suggestions were helpful, click “Accept Answer” and Up-Vote. Feel free to reach out to us if you've additional questions in this regard.
Sadiqh Ahmed 49,571 Reputation points Microsoft External Staff Moderator

2023-09-01T10:43:05.8133333+00:00

@Sumit We haven't heard back from you. Please reply if you have any questions in this matter and we will gladly continue the discussion.

Sumit 1

@Sadiqh Ahmed ,
It seems you didnt get the question. hint.strategy ( data | where type == '') query only works for the first table means if you call out resources table as first , then you can pull the data using hint query multiple times but if you use multiple tables like recoveryservicesresources , hint.strategy still uses first table.
I just reverse the query, just test it & you will find out that when you run this query , you will get Extension details as resource is called out firstly

resources
| where type =~ 'microsoft.compute/virtualmachines'
| extend VMName=name
| join kind=leftouter hint.strategy=shuffle (data
| where type == "microsoft.compute/virtualmachines/extensions"
| where name =~ 'DependencyAgent'
| extend VMName=tostring(split(id,'/')[8])
| project VMName, ExtensionName=name) on VMName
| project-away VMName1
| join kind= leftouter (recoveryservicesresources
| where type == 'microsoft.recoveryservices/vaults/backupfabrics/protectioncontainers/protecteditems'
|project VMName= tolower(tostring(properties.friendlyName))) on VMName

But if you use below query , there will be no data for extensions.

recoveryservicesresources
| where type == 'microsoft.recoveryservices/vaults/backupfabrics/protectioncontainers/protecteditems'
|project VMName= tolower(tostring(properties.friendlyName))
| join kind= leftouter (resources
| where type =~ 'microsoft.compute/virtualmachines'
| extend VMName=name
| join kind=leftouter hint.strategy=shuffle (data
| where type == "microsoft.compute/virtualmachines/extensions"
| where name =~ 'DependencyAgent'
| extend VMName=tostring(split(id,'/')[8])
| project VMName, ExtensionName=name) on VMName
| project-away VMName1) on VMName

Sadiqh Ahmed 49,571 Reputation points Microsoft External Staff Moderator

2023-09-04T07:00:06.8566667+00:00

@Sumit I understand that but the point is your scenario is not documented neither it is mentioned as unspported. Which is why I asked you to comment on the doc link for the respective team to confirm and help further.