Skip to content

Instantly share code, notes, and snippets.

@cheeto-bandito

cheeto-bandito/Kusto.kql

Created July 13, 2023 16:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cheeto-bandito/17015373379498306ab679a45d9e5668 to your computer and use it in GitHub Desktop.
Save cheeto-bandito/17015373379498306ab679a45d9e5668 to your computer and use it in GitHub Desktop.
Download ZIP
Wellstar Solr Log Query
Raw
Kusto.kql
let _betweenTime1 = datetime(2023-07-08 19:29:00);
let _betweenTime2 = datetime(2023-07-13 19:30:59);
let _containerInventory = (ContainerInventory
| where TimeGenerated between (_betweenTime1 .. _betweenTime2)
| distinct ContainerID, ContainerHostname);
ContainerLog
| where TimeGenerated between (_betweenTime1 .. _betweenTime2)
| lookup kind=leftouter _containerInventory on ContainerID
| sort by TimeGenerated asc
| where ContainerHostname startswith "sc-solr-solrcloud-"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment