SOLVED

Monitoring data connectors in Sentinel - Check if any connectors are down

%3CLINGO-SUB%20id%3D%22lingo-sub-2156160%22%20slang%3D%22en-US%22%3EMonitoring%20data%20connectors%20in%20Sentinel%20-%20Check%20if%20any%20connectors%20are%20down%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2156160%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EYou%20will%20have%20to%20forgive%20my%20basic%20Azure%20knowledge%2C%20as%20I'm%20a%20DBA%20looking%20after%20about%20250%20servers%20for%20various%20clients%2C%20but%20have%20been%20asked%20by%20my%20company%20if%20I%20could%20write%20some%20KQL%20that%20will%20alert%20them%20if%20a%20data%20connector%20goes%20down%20or%20is%20deleted.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20managed%20to%20write%20some%20KQL%20that%20tells%20me%20if%20a%20resource%20hasn't%20raised%20any%20events%20in%20the%20last%20hour%20or%20X%20hours%2C%20depending%20on%20the%20resource%2C%20but%20when%20I%20try%20and%20create%20an%20alert%20based%20on%20this%20KQL%20it%20passes%20validation%2C%20but%20then%20I%20get%20the%20message%20failed%20to%20create%20the%20rule%20as%20your%20query%20contains%20%22union%22%20and%20%22search%22.%20I%20have%20read%20it's%20not%20possible%20to%20use%20union%20and%20search%20in%20such%20queries%2C%20but%20is%20there%20an%20alternative%20method%3F%20Due%20to%20the%20amount%20of%20connectors%20we%20have%2C%20we%20don't%20want%20to%20create%20an%20individual%20alert%20rule%20for%20each%20connector.%3C%2FP%3E%3CP%3EWe'd%20like%20to%20set%20the%20query%20to%20run%20every%20hour%20or%20so%20and%20get%20an%20alert%20if%20no%20events%20have%20been%20raised%20by%20a%20data%20connector.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20is%20there%20anyway%20to%20specifically%20check%20if%20a%20data%20connector%20that%20previously%20existed%20is%20no%20longer%20working%20or%20has%20been%20deleted%3F%20And%20how%20do%20you%20actually%26nbsp%3B%20delete%20a%20data%20connector%20once%20you've%20created%20it%3F%20Is%20it%20possible%20to%20do%20it%20from%20the%20porta%20las%20I%20can't%20seem%20to%20find%20a%20way%20to%20do%20it%20for%20my%20testing%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20and%20sorry%20for%20my%20lack%20of%20Azure%20knowledge%2C%20but%20learning%20all%20the%20time!%20If%20anyone%20needs%20DBA%20help%2C%20more%20than%20happy%20to%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

You will have to forgive my basic Azure knowledge, as I'm a DBA looking after about 250 servers for various clients, but have been asked by my company if I could write some KQL that will alert them if a data connector goes down or is deleted.

 

I have managed to write some KQL that tells me if a resource hasn't raised any events in the last hour or X hours, depending on the resource, but when I try and create an alert based on this KQL it passes validation, but then I get the message failed to create the rule as your query contains "union" and "search". I have read it's not possible to use union and search in such queries, but is there an alternative method? Due to the amount of connectors we have, we don't want to create an individual alert rule for each connector.

We'd like to set the query to run every hour or so and get an alert if no events have been raised by a data connector.

 

Also, is there anyway to specifically check if a data connector that previously existed is no longer working or has been deleted? And how do you actually  delete a data connector once you've created it? Is it possible to do it from the porta las I can't seem to find a way to do it for my testing

 

Thanks and sorry for my lack of Azure knowledge, but learning all the time! If anyone needs DBA help, more than happy to help.

2 Replies
Best Response confirmed by sijmalik (Occasional Contributor)
Solution

@sijmalik 

 

Search and Union wildcards are not allowed (i.e union *) but you can name the Tables, as per this simple example using two common Tables:

union SecurityAlert, SecurityEvent
| limit 10

(within a Analytics scheduled rule in Azure Sentinel) 

@Clive Watson Ah. OK, yes I was using union *, it works fine when I put the table names in. Thanks Clive, much appreciated!

 

So, just being a bit cheeky does anyone know how to delete a connector, as I need to do this for testing? I'm assuming I have to use HTTP and pass in the URI parameters. But as an example, I've got an Azure SQL Database connector that I want to delete. Where would I find the connector ID? I tried just putting in 'Azure SQL Database' in the connector ID parameter but I got a 204 code back.

 

Thanks