Stream Analytics - Possible to Change/Convert miliseconds to seconds ?

Question

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 testName
, Location as runLocation
, message as result
, TimeGenerated as dataeventTime
, DurationMs as durationmetricvalue ----- THIS ONE 
, ItemCount as durationMetriccount
, Type as availabilityMetricname

INTO
    [xxxxxx]
FROM [xxxxxx] 

Input : from Blob Container

Output : SQL and RDL Report Server

Answer 1

I need to convert somehow but not sure if this is correct way.

Somehow? Wrong values? How could we guess, you didn't provide detailed informations.

Please post table design as DDL, some sample data as DML statement and the expected result.

And which values are wrong and why do you think so?

Answer 2

Hello

it helps if you know how the (JSON) messages look like when ingesting them into Azure Stream Analytics.

There are a number of ways, here a few of them.

First, check the input for the sample data option:

This will give a dialog like this:

If data is received, you can save it as a file.

Or you can check the messages within the service providing the stream of data, like Azure Event Hubs:

Or check the Azure Stream Analytics Job extension for Visual Studio Code.

Here, you can test your job on your own PC.

---

This answer is written by myself, not by some AI. If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. All community members with similar issues will benefit by doing so. Your contribution is highly appreciated.