KQL Search

Query Details

HomeAI ToolsDevice Query

KQL Query Visits

Query

# KQLQuery Visits

## Query Information

#### Description
Visualize the visits to [KQLQuery.com](KQLQuery.com) in a columnchart.

#### References
- https://www.KQLQuery.com/

## Defender For Endpoint
```KQL
DeviceNetworkEvents
| where RemoteUrl has "kqlquery.com"
| summarize TotalDevices = dcount(DeviceId) by bin(Timestamp, 1d)
| render columnchart with(title="kqlquery.com visits", xtitle="Date", ytitle="TotalDevices")
```
## Sentinel
```KQL
DeviceNetworkEvents
| where RemoteUrl has "kqlquery.com"
| summarize TotalDevices = dcount(DeviceId) by bin(TimeGenerated, 1d)
| render columnchart with(title="kqlquery.com visits", xtitle="Date", ytitle="TotalDevices")
```

Explanation

This query retrieves information about the visits to KQLQuery.com and visualizes it in a column chart. It counts the number of unique devices accessing the website each day and plots it on the chart. The chart is titled "kqlquery.com visits" and the x-axis represents the date while the y-axis represents the total number of devices.

Details

Bert-Jan Pals profile picture

Bert-Jan Pals

Released: December 30, 2023

Tables

DeviceNetworkEvents

Keywords

Devices,Intune,User

Operators

wherehassummarizedcountbybinrender

Actions