Reader small image

You're reading from  Azure IoT Development Cookbook

Product typeBook
Published inAug 2017
Reading LevelIntermediate
PublisherPackt
ISBN-139781787283008
Edition1st Edition
Languages
Tools
Right arrow
Author (1)
Yatish Patil
Yatish Patil
author image
Yatish Patil

Yatish Patil is currently working with Saviant Consulting as a technical project manager. He has delivered enterprise IoT and analytics applications using Microsoft Azure, ASP.NET, MVC, C#, SQL Server, and NoSQL. He has diverse industrial experience in IT and has worked in a variety of domains, such as utilities, manufacturing, and engineering. He has completed his certification in Developing Azure Solutions in the Microsoft Azure Certification. Yatish was also the technical reviewer for a Microsoft Azure-based technology book Microsoft Azure IaaS Essentials, which teaches guides Microsoft Azure subscribers how to design, configure, and build cloud-based infrastructure using Microsoft Azure. Yatish was among the industry speakers at India IoT Symposium, 2016. He delivered the industry session on remote asset monitoring with Microsoft Azure IoT Suite.
Read more about Yatish Patil

Right arrow

IoT Hub query explorer

IoT Hub supports a SQL-like language to retrieve information regarding device twins, jobs, and message routing. Basically, you can write a basic SQL command and that will be executed against the device registry.

Each query follows the syntax like SQL; it has the standard SELECT, FROM, and WHERE keywords used to retrieve the result set in the result window.

How to do it...

In this section, we will follow the steps to use the query explorer and retrieve the device information in the results window:

  1. we will select the IoT Hub IoTHubCookBook service from the Azure portal.
  2. Select Query Explorer:
  1. Using the execution windows, type the query you want to execute:
  1. The output will be shown in the result...
lock icon
The rest of the page is locked
Previous PageNext Chapter
You have been reading a chapter from
Azure IoT Development Cookbook
Published in: Aug 2017Publisher: PacktISBN-13: 9781787283008

Author (1)

author image
Yatish Patil

Yatish Patil is currently working with Saviant Consulting as a technical project manager. He has delivered enterprise IoT and analytics applications using Microsoft Azure, ASP.NET, MVC, C#, SQL Server, and NoSQL. He has diverse industrial experience in IT and has worked in a variety of domains, such as utilities, manufacturing, and engineering. He has completed his certification in Developing Azure Solutions in the Microsoft Azure Certification. Yatish was also the technical reviewer for a Microsoft Azure-based technology book Microsoft Azure IaaS Essentials, which teaches guides Microsoft Azure subscribers how to design, configure, and build cloud-based infrastructure using Microsoft Azure. Yatish was among the industry speakers at India IoT Symposium, 2016. He delivered the industry session on remote asset monitoring with Microsoft Azure IoT Suite.
Read more about Yatish Patil