Get scalar value from table

Using the new OMS Log Analytics query language, how do I get a scalar value out of a table? That is, what is the equivalent of this TSQL query, presuming Table1 has a single row: Select @ScalarVar ...

azure monitor

Query Language

Evgeny Ternovsky
Sep 20, 2017
Tim,

You're looking for toscalar(). For a slightly more advanced example of how to use it (together with makeset() and in()), check out the last section of our aggregations tutorial.

To pseudocode your example, you'd be looking at something like:

let myDateTime = toscalar(Table1 | summarize max(TimeGenerated));

Table 2

| where TimeGenerated between ((myDateTime - 5m) .. (myDateTime + 5m))

| ...

Evgeny Ternovsky

Microsoft

Sep 20, 2017

Tim,

You're looking for toscalar(). For a slightly more advanced example of how to use it (together with makeset() and in()), check out the last section of our aggregations tutorial.

To pseudocode your example, you'd be looking at something like:

let myDateTime = toscalar(Table1 | summarize max(TimeGenerated));

Table 2

| where TimeGenerated between ((myDateTime - 5m) .. (myDateTime + 5m))

| ...

Tim Curwick

Copper Contributor

Sep 20, 2017

Evgeny,

Perfect. Thanks. I knew there was something like that in there somewhere, but I was having trouble finding it in the language reference. I see it now under Scalar Functions.

Forum Discussion

Get scalar value from table

Resources