# New to KQL and Azure. Is there a basic  KQL to test functionality

**URL:** <https://community.dynatrace.com/t/new-to-kql-and-azure-is-there-a-basic-kql-to-test-functionality/50508>\
**Category:** Cloud platforms\
**Tags:** azure, extensions\
**Created:** [February 28, 2025, 2:57pm UTC](https://community.dynatrace.com/t/new-to-kql-and-azure-is-there-a-basic-kql-to-test-functionality/50508 "2025-02-28T14:57:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![runatyr](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/runatyr/32/11396_2.png) [@runatyr](https://community.dynatrace.com/u/runatyr)\
**Post date:** [February 28, 2025, 2:57pm UTC](https://community.dynatrace.com/t/new-to-kql-and-azure-is-there-a-basic-kql-to-test-functionality/50508/1 "2025-02-28T14:57:18Z")

</div>

Good morning Dynatrac-ians !&nbsp;😁

I am in the process of leveraging an extenstion in dyantrace manged that connects to Azure and is capable of executing a Kusto Query from Azure.

So, my challenge is… I still a novice when it comes to Azure and KQL.

**Does anyone know of a basic KQL command in Azure I could run against the simplest thing to prove it works in Azure before I try it through the Dynatrace extension?**

**Anything really… the more generic and universal the better!**

Thank you as always community!

-runatyr

---

<div class="post-metadata">

**Author:** ![kayjayeff1](https://avatars.discourse-cdn.com/v4/letter/k/13edae/32.png) [@kayjayeff1](https://community.dynatrace.com/u/kayjayeff1)\
**Post date:** [February 28, 2025, 3:39pm UTC](https://community.dynatrace.com/t/new-to-kql-and-azure-is-there-a-basic-kql-to-test-functionality/50508/2 "2025-02-28T15:39:03Z")

</div>

There are lots of options.&nbsp; Here is a query I run to retrieve a list of tables in our Log Analytics Workspace and the last time a log was inserted.

```markup
search * | summarize LastLog=max(TimeGenerated) by $table | sort by LastLog asc

```

---

<div class="post-metadata">

**Author:** ![runatyr](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/runatyr/32/11396_2.png) [@runatyr](https://community.dynatrace.com/u/runatyr)\
**Post date:** [February 28, 2025, 4:48pm UTC](https://community.dynatrace.com/t/new-to-kql-and-azure-is-there-a-basic-kql-to-test-functionality/50508/3 "2025-02-28T16:48:13Z")

</div>

I think I found the space to run this from… I had to select KQL in the far right.

Is this what you would anticipate?

 ![runatyr_1-1740761497983.png](https://global.discourse-cdn.com/dynatrace/original/3X/2/d/2db369279f4a615d0fde8f855b465caf6512b907.png)

---

<div class="post-metadata">

**Author:** ![kayjayeff1](https://avatars.discourse-cdn.com/v4/letter/k/13edae/32.png) [@kayjayeff1](https://community.dynatrace.com/u/kayjayeff1)\
**Post date:** [February 28, 2025, 7:51pm UTC](https://community.dynatrace.com/t/new-to-kql-and-azure-is-there-a-basic-kql-to-test-functionality/50508/4 "2025-02-28T19:51:14Z")

</div>

yes those are the results I would expect from that query. That query is doing summarization of data. If you want actual log entries pick one of the table names that is the output of the above KQL.

for example this will return all logs from AppRequests for the last hour

```auto
AppRequests
| where TimeGenerated >= ago(1h)

```
