System error (Duplicate property names) while running ASA job at IoT edge

Question

Hello,

I am trying to run the following query, but it shows the error as duplicate property name. However the names are different

Questions:

1. How can I name this property as I cannot use * for all selection?
2. I am trying measure time for execution taken by ASA job on edge device, Could you please suggest the solution for exit time? I cannot use UDF function on edge solution.

Thanks..

Answer 1

I don't have an answer for your second question, maybe you could post that as a separate question. But for your first question:
If you have properties with the same name (both of yours end with .temperature, so the property will be called temperature, you can give them an alias. Your query could be

SELECT
  timeCreated,
  machine.temperature AS machineTemperature,
  machine.pressure AS machinePressure,
  ambient.temperature AS ambientTemperature,
  ambient.humidity AS ambientHumidity,
  System.Timestamp as t1

This will make sure that you don't have duplicate property names.

Answer 2

Hello @ankita m ,

to get insights about your Azure IoT Edge solution, host, and modules, check out this metrics collector module from Microsoft.

Check out these visualizations.

One of the views is:

The Modules view shows how the individual modules on a device are performing.

If this is not good enough for you, you can always try to compare the telemetry creation time and the output of your job using customer module logic and routing.