Skip to main content

I am trying to execute a manual action -UDM query through Chronicle SOAR and it is giving me error

  • Dec 16, 2024 11:41 AM UTC
  • 4 replies
  • 94 views

Vaishnoodevi
Forum|alt.badge.img+2

Query trying to run is :

$e.metadata.event_type = "USER_LOGIN"
$e.security_result.action = "BLOCK"
$e.security_result.summary = "LogonFailed"
$principaluser = $e.principal.user.userid
$principalip = $e.principal.ip
match:
$principaluser over 10m
outcome:
$count=count($e.principal.user.userid)

 

4 replies

James_E
Staff
Forum|alt.badge.img+8
  • Staff
  • Dec 16, 2024 2:57 PM UTC

This seems to be a limitation on the API and not something within the Execute UDM Query integration. A simple Yara-L query like below will execute, but not a "detection" based yara-l statement(s) as it does in the Search UI. You should open a support case for this.

metadata.event_type = "USER_LOGIN"
security_result.action = "BLOCK"
security_result.summary = "LogonFailed"


Forum|alt.badge.img+8
  • Staff
  • Dec 16, 2024 4:35 PM UTC

Hello,

I can confirm the same behavior in our test instance in SOAR but trying the same query directly in SIEM does not give me any error. As mentioned please open  support case to investigate. 

 

 


AymanC
Forum|alt.badge.img+14
  • Bronze 5
  • Dec 16, 2024 11:47 PM UTC

Hi @Vaishnoodevi,

The reason this is failing, is because you are using a Pre-GA feature, known as 'Statistics and Aggregations'[1] which is not currently supported in that action, nor is available as an API endpoint.

[1] - https://cloud.google.com/chronicle/docs/investigation/statistics-aggregations-in-udm-search


Vaishnoodevi
Forum|alt.badge.img+2
  • Author
  • Bronze 1
  • Mar 4, 2025 5:55 AM UTC

Thank you @AymanC  and @TonyH I have raised a feature request with the google team.