no event for reference
I look for to count event appear in period of time for a device reference list, using :
count(t1.[TimeStamp]) as nbEvents
[IotHubInput] t1 TIMESTAMP BY [TimeStamp]
join [DevicesList] t2 on t2.id = t1.id
Give me only count for present device. I would like to have result 0 for device present in reference.
Can't put deviceList in first or join option to have all lines from t2 (like in SQLServer)
ASA does not support an outer join with reference data today.