KQL Validations for Multiple data sources hunting queries

[v-vdixit]

Required items, please complete

Change(s):

• fixed the failing kql validations for multiple data sources and other related hunting queries

Reason for Change(s):

• failing kql validations

Version Updated:

• Required only for Detections/Analytic Rule templates
• See guidance below

Testing Completed:

• See guidance below

Checked that the validations are passing and have addressed any issues that are present:

• See guidance below

Guidance <- remove section before submitting

---

Before submitting this PR please ensure that you have read the following sections and filled out the changes, reason for change and testing complete sections:

Thank you for your contribution to the Microsoft Sentinel Github repo.

Details of the code changes in your submitted PR. Providing descriptions for pull requests ensures there is context to changes being made and greatly enhances the code review process. Providing associated Issues that this resolves also easily connects the reason.

Change(s):

• Updated syntax for XYZ.yaml

Reason for Change(s):

• New schema used for XYZ.yaml
• Resolves ISSUE #1234

Version updated:

• Yes
• Detections/Analytic Rule templates are required to have the version updated

The code should have been tested in a Microsoft Sentinel environment that does not have any custom parsers, functions or tables, so that you validate no incorrect syntax and execution functions properly. If your submission requires a custom parser or function, it must be submitted with the PR.

Testing Completed:

• Yes/No/Need Help

Note: If updating a detection, you must update the version field.

Before the submission has been made, please look at running the KQL and Yaml Validation Checks locally. https://github.com/Azure/Azure-Sentinel#run-kql-validation-locally

Checked that the validations are passing and have addressed any issues that are present:

• Yes/No/Need Help

Note: Let us know if you have tried fixing the validation error and need help.

References:

• Guidance for Detection checks
• General contribution guidance
• PR validation troubleshooting

---

[v-vdixit]

Hi @vakohl, please check and provide your feedback on this, thanks!

[v-atulyadav]

Hi @vakohl, please provide your feedback on this. Thanks

[v-atulyadav]

Hi @vakohl, please check and provide your feedback on this. Thanks

[v-atulyadav]

Hi @vakohl, please provide your feedback on this. Thanks

[v-atulyadav]

Hi @vakohl, please check and provide your feedback on this. @v-vdixit also check for branch conflicts. Thanks

[v-atulyadav]

Hi @vakohl, please provide your feedback on this. Thanks

[v-atulyadav]

Hi @vakohl, please check and provide your feedback on this. @v-vdixit also check for branch conflicts. Thanks

[v-atulyadav]

Hi @vakohl, please check and provide your feedback on this. Hi @v-vdixit, can you please check for branch conflicts. Thanks

[v-atulyadav]

Hi @vakohl , check out the fixes from @v-vdixit. Thanks