Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,917 questions
4 answers
One of the answers was accepted by the question author.
Azure Analytics Query to group the date and events
We have a huge data of analytics from past few months & I am looking for a query to group the events in the order of date.
asked 2021-08-31T18:11:10.417+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 27%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Amrutha
21
Reputation points
commented 2021-09-15T20:43:23.1+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft
19,386
Reputation points Microsoft Employee
4 answers
IoTHubQuota Exceeded
Im a developer with many years experience, but a newbie to azure and to python I am working on an IoT project where I have a number of Raspberry Pi units sending telemetry data to Azure. To facilitate this I have set up the following in the cloud 1…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 35%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
4 answers
Azure Stream Analytics: ML Service function call in cloud job results in no output events
Hey, I've got a problem with an Azure Stream Analytics (ASA) job that should call an Azure ML Service function to score the provided input data. The query was developed und tested in Visual Studio (VS) 2019 with the "Azure Data Lake and…
asked 2020-07-16T16:57:01.43+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 96%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPL%3C/text%3E%3C/svg%3E)
Philipp Lehmann
6
Reputation points
answered 2020-07-18T10:09:45.22+00:00
Philipp Lehmann
6
Reputation points
3 answers
Im trying to send Data from my IoTHub Input to my Sql Database output, but tables stay empty?
Hello everyone, Im currently working on a university-project and I'm connecting my Raspberry Pi Pico with Azure. The Pico is sending temperature data, which is recieved in the IoTHub Input im my analytics stream, but when I'm trying to send the data to…
asked 2024-03-20T14:33:58.6733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 89%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESO%3C/text%3E%3C/svg%3E)
Snack Overflow
0
Reputation points
answered 2024-03-20T15:53:31.9666667+00:00
Sander van de Velde
30,096
Reputation points MVP
3 answers
One of the answers was accepted by the question author.
How to fix azure.eventhub.exceptions.AuthenticationError: CBS Token authentication failed
I'm attempting to run a sample event generator to familiarize myself with Azure Event Hubs and Azure Stream Analytics. import asyncio from azure.eventhub.aio import EventHubProducerClient from azure.eventhub import EventData import json import…
asked 2023-02-26T03:27:04.21+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 93%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBL%3C/text%3E%3C/svg%3E)
Bill LaLonde
50
Reputation points
answered 2023-11-09T07:01:27.02+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 87%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Mariyam Thomas
20
Reputation points
3 answers
How can I get a report of who created resources in Azure Analytics?
Hello, I'm trying to get reports of who creates resources in Azure, for example, I have analytic workspaces created but would like to see who created?
asked 2022-03-04T14:40:28.227+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 34%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELP%3C/text%3E%3C/svg%3E)
Lou Pereira
11
Reputation points
edited the question 2023-05-15T05:08:41.8633333+00:00
PRADEEPCHEEKATLA-MSFT
81,646
Reputation points Microsoft Employee
3 answers
Azure stream analytics
Hello everyone Is there any document based on azure stream analytics input as Eventhub and output as power Bi
asked 2023-03-10T06:36:01.02+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 68%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
soundarya G
0
Reputation points
answered 2023-03-13T08:26:59.79+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 70%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELL%3C/text%3E%3C/svg%3E)
LiJia Liu
170
Reputation points MVP
3 answers
Telemetry data JSON body is encrypted. IoT Message route is used to route data directly to Blob storage.
Hi, So I am running Advantech device on Rasberry Pi using ModBus which then use Node Red workflow and Azure IOT hub node to connect to Azure IOT hub directly. I am able to connect to IoT hub and telemetry data is being sent successfully to iot hub. In…
asked 2022-12-19T14:33:36.707+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 60%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUA%3C/text%3E%3C/svg%3E)
Umair Akhtar
41
Reputation points
commented 2023-01-17T12:51:50.2333333+00:00
LeelaRajeshSayana-MSFT
13,871
Reputation points
3 answers
Azure stream anlytics test query output is different from Sql database logged output.
So i have this query in which Azure stream analytics test query output is different from Sql database logged output. SELECT DeviceId, System.Timestamp() AS Windowtime, AVG(temperature) as Temperature, AVG(humidity) as…
asked 2022-11-14T12:19:24.69+00:00
Umair Akhtar
41
Reputation points
commented 2022-11-17T23:48:32.193+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
BhargavaGunnam-MSFT
28,081
Reputation points Microsoft Employee
3 answers
No data was found for preview
Using terraform, I've created an IoT hub and a Stream analytics job. The input verifies correctly, the IoT hub shows data coming in. However when I select Query to test my streaming job, it always says there is no data available in the…
asked 2021-07-02T11:43:13.493+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 0%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
Exie
6
Reputation points
commented 2022-05-09T07:06:34.35+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 99%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Shreelakshmi C R
41
Reputation points
3 answers
Processing Azure Storage Logs to Azure SQL with Stream Analytics
Hi Azure Community! I have a Storage Account and a CDN to make my images and videos faster to download/view. I would like to count the views/downloads of my files periodically to an azure database, let's say every 2 hours. I was thinking of Azure…
asked 2021-03-25T10:56:45.873+00:00
simon brami
1
Reputation point
answered 2021-04-01T19:45:45.313+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 44%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Samara Soucy - MSFT
5,051
Reputation points
3 answers
One of the answers was accepted by the question author.
SSIS ETL Tool
Is the latest version of SSIS a fully cloud-based ETL tool?
asked 2021-02-05T20:37:45.827+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 35%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Sridhar Vuligonda
21
Reputation points
accepted 2021-02-12T14:24:47.13+00:00
Sridhar Vuligonda
21
Reputation points
3 answers
Azure Logic App : Logs not showing in Log Analytics workspace and AzureDiagnostics log table
I have been following the following article : https://learn.microsoft.com/en-gb/azure/logic-apps/monitor-logic-apps-log-analytics But even after following all the steps in the article , I cant see any data in Logic Apps Management section of my…
asked 2020-08-26T17:02:29.473+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 16%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
Mulchandani, Jaideep
1
Reputation point
commented 2020-10-20T07:20:56.967+00:00
MayankBargali-MSFT
69,841
Reputation points
2 answers
Why 'Custom App' option is not shown under 'Add Source' in event stream of Microsoft Fabric.
We are trying to consume messages from Kafka. Created a new event stream in Microsoft Fabric. 'Custom App' option is not shown under 'Add Source' or 'New Source' in event stream of Microsoft Fabric real-time analytics
asked 2024-05-11T11:04:14.82+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 92%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Karthika Samidurai
0
Reputation points
commented 2024-05-20T07:19:29.7+00:00
PRADEEPCHEEKATLA-MSFT
81,646
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
How to ingest CDC data from SQL DATA SYNC to Event hub?
Hi we have a scenario to implement real-time CDC from SQL DATA SYNC to Azure SQL DB. Which tools are good for near real-time processes and prices as well. By using data bricks we can merge stream data into delta lake. But How to ingest real-time…
asked 2020-11-10T12:28:43.067+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 54%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETG%3C/text%3E%3C/svg%3E)
THIMMAIAH GARI,PRASHANTH,,
201
Reputation points
edited an answer 2024-04-24T06:51:50.8266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 91%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Shane Blake
0
Reputation points
2 answers
How to recover Stream Analytics job to normal Running status from Degraded state?
Hello, My stream analytics job had been working fine with IoT Hub stream input and SQL DB as reference input, output is written to storage account. Yesterday there was an unplanned Azure service issue with IoT Hub in my region and it lasted for around 6…
asked 2024-02-22T03:01:24.33+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 30%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVH%3C/text%3E%3C/svg%3E)
Vishwanath Hariharan
30
Reputation points
commented 2024-03-13T13:28:08.0033333+00:00
Vishwanath Hariharan
30
Reputation points
2 answers
Stream Analytics Job Output Stuck
I have a stream analytics job with an MQTT JSON input and a postgreSQL output. I noticed that if a certain JSON parameter that is part of the message no output rows are generated. I couldn't find any related info in the logs. Restarting the stream…
asked 2021-11-12T14:36:21.217+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 1%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Lior Bahat
1
Reputation point
edited a comment 2024-02-01T17:13:59.93+00:00
Sander van de Velde
30,096
Reputation points MVP
2 answers
How to configure Azure and Entra ID logs into Log Analytics for Kusto Query?
Hi All, I need some help and suggestions to configure Azure and Entra ID logs into Log Analytics for Kusto Query. What are the procedures and what is the cost involved? Thanks.
asked 2023-12-07T14:30:00.8666667+00:00
EnterpriseArchitect
4,916
Reputation points
commented 2024-01-03T16:01:15.8+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 17%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Givary-MSFT
29,171
Reputation points Microsoft Employee
2 answers
Stream Analytics - Possible to Change/Convert miliseconds to seconds ?
Hi, i wrote for ASA a query and i am facing with one colum here. But the time output is wrong i think and in my RDL Report Server i am also getting no correct results I need to convert somehow but not sure if this is correct way. SELECT Name as…
asked 2023-11-08T11:25:52.9533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 46%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sutheswaran, Suwhathi
70
Reputation points
commented 2023-11-20T08:46:46.2633333+00:00
PRADEEPCHEEKATLA-MSFT
81,646
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Stream Analytics Job - no output in SQL
Hello Team, i am facing with Stream Analytics Job with Output for SQL. I wrote a query and the output showing me the results which I expects. But somehow the results is not showing in my SQL table. I am running out of ideas. Not sure why it’s not…
asked 2023-11-01T18:52:40.7266667+00:00
Sutheswaran, Suwhathi
70
Reputation points
commented 2023-11-08T12:03:44.4766667+00:00
Sutheswaran, Suwhathi
70
Reputation points