You can configure a stream analytics job which you can configure to create queries and filter data by machine. Here you will find an example.
This article can also give you a good overall picture of things possible.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi. We are trying to migrate to Azure our app which shows data from multiple IoT devices arranged in SQL tables. From what we read we believe the trick will be done with IoT Hub + Stream Analitics + SQL Az database +Az Web App. We hava many grey areas as to how to implement this, specially the stream input to the Stream Analytics. How to dicern between the different devices which sent the corresponding messages. Could you give us a starting point for this? Which specific azure doc should I read?
Thanks
Hello @QST Ingeniería ,
as @Alberto Morillo confirmed, your expectations are right.
You need to connect an IoTHub as input to an Azure Stream Analytics Job.
In this blog post, the almost complete flow is shown: device -> iot-hub -> ASA job -> SQL server (including the AAD security).
If you want to experience a hands-on experience, check out eg this MS Learn module.