Skip to main content

custom dashboard chronicle condition check

  • Oct 8, 2024 1:23 PM UTC
  • 3 replies
  • 104 views

Forum|alt.badge.img+3

Dear Everyone,

Please let me know if below scenario is achievable in chronicle SIEM custom dashboard.

if user belongs to malware_group(ACL), it should capture yes in the report else no.

my acl looks like-- chronicle_soc_users

can i actually use if statement to get the desired result?

Thanks in advance.

Emmie

 

 

3 replies

AymanC
Forum|alt.badge.img+14
  • Bronze 5
  • Oct 9, 2024 12:32 PM UTC

Hi @Emmie-123,

Based on which dashboard functionality you are referring to, if it is using Looker Embedded, this is possible by using the 'if' function[1]

 

 

if(yesno_expression, value_if_yes, value_if_no)

 

 

This thread[2] should also aid in providing an example of this function being used, and its output (if referring to using dashboards utilising looker embedded). Alternatively if this is related to stats and aggregates search, or preview dashboard functionality, then this following reference[3] should help you.


[1] - https://cloud.google.com/looker/docs/functions-and-operators
[2] - Solved: Re: SIEM Dashboard in Google Secops - Google Cloud Community

[3] -  https://cloud.google.com/chronicle/docs/detection/yara-l-2-0-syntax#conditional_logic

Kind Regards,

Ayman


Forum|alt.badge.img+3
  • Author
  • Bronze 1
  • Oct 22, 2024 2:08 PM UTC

Hi @Emmie-123,

Based on which dashboard functionality you are referring to, if it is using Looker Embedded, this is possible by using the 'if' function[1]

 

 

if(yesno_expression, value_if_yes, value_if_no)

 

 

This thread[2] should also aid in providing an example of this function being used, and its output (if referring to using dashboards utilising looker embedded). Alternatively if this is related to stats and aggregates search, or preview dashboard functionality, then this following reference[3] should help you.


[1] - https://cloud.google.com/looker/docs/functions-and-operators
[2] - Solved: Re: SIEM Dashboard in Google Secops - Google Cloud Community

[3] -  https://cloud.google.com/chronicle/docs/detection/yara-l-2-0-syntax#conditional_logic

Kind Regards,

Ayman


Hi @AymanC , Thanks for the input. please confirm what parameter should i use in yesno_expression?

if(yesno_expression, value_if_yes, value_if_no)

 


AymanC
Forum|alt.badge.img+14
  • Bronze 5
  • Oct 23, 2024 9:55 AM UTC

Hi @AymanC , Thanks for the input. please confirm what parameter should i use in yesno_expression?

if(yesno_expression, value_if_yes, value_if_no)

 


Hi @Emmie-123,

The 'yesno_expression' should contain the value you want to match (for example wherever 'malware_group' is), for it to then output 'value_if_yes', or 'value_if_no'.

Kind Regarrds,

Ayman