Hello Community members,
I hope this message finds you well. I'm currently working on a project that involves querying data using Kusto Query Language (KQL) for a specific use case. While I've made some progress, I've encountered a challenge with a particular query that I could use some guidance on.
In my current task, I have a datatable containing a list of device names, and I need to retrieve their corresponding operating system information from the DeviceInfo table. My goal is to create a join between the two tables and extract fields like OSVersion, DeviceType, OSArchitecture, and more.
However, despite my best efforts, I'm not getting the expected results from my query. When I attempt to retrieve the operating system information based on the device names, the query seems to return empty results, which isn't aligning with what I anticipated.
Here's a simplified version of the KQL query I've been using:
**let MyDataTable = datatable (DeviceName: string) [ "PC1", "PC2", "PC3" ];
MyDataTable
MyDataTable | join kind=inner (DeviceInfo) on DeviceName | project DeviceName, OSVersion, DeviceType, OSArchitecture, OSPlatform, ClientVersion, LoggedOnUsers**
My expectation is that the query should successfully join the MyDataTable with the DeviceInfo table using the DeviceName as the key and provide me with the requested operating system information. However, it seems like I'm missing something, as I'm not getting the desired fields populated.
I would greatly appreciate any assistance, insights, or suggestions the community can provide to help me troubleshoot and resolve this issue. If anyone has encountered a similar situation or can spot any potential pitfalls in my approach, your guidance would be immensely valuable.
Thank you in advance for your time and assistance. I'm looking forward to your responses and working together to tackle this challenge.
Best regards,
Sergio
I tried to run the script using different commands, and also modify the script in diffent ways always with the same result.
