Splunk Search

Trying to search a Workday index for direct deposit change requests from unknown addressess

blmclaws
Engager

We use Workday as our payroll system and have a Workday add-on with logs in an index called dmc_workday_index. I want to see the attempts over 5 to change direct deposit information within Workday that are coming from unknown source IP's. We thought something like below which works except for the last part referring to the != expression. I want something more efficient anyway. Hoping someone has a few good suggestions.

index=dmc_workday_index taskDisplayName="Manage Payment Elections" | stats count by ipAddress | where (count > 5) ipAdress != "64.147.0.0/16"

0 Karma
1 Solution

mayurr98
Super Champion

you should try this

index=dmc_workday_index taskDisplayName="Manage Payment Elections"  ipAddress!="64.147.0.0/16"| stats count by ipAddress | where count > 5

Is there a field called ipAdress? and it has values in CIDR format? if not then you need to try this:

index=dmc_workday_index taskDisplayName="Manage Payment Elections"  ipAddress!="64.147.*"| stats count by ipAddress | where count > 5

let me know if this helps!

View solution in original post

0 Karma

mayurr98
Super Champion

you should try this

index=dmc_workday_index taskDisplayName="Manage Payment Elections"  ipAddress!="64.147.0.0/16"| stats count by ipAddress | where count > 5

Is there a field called ipAdress? and it has values in CIDR format? if not then you need to try this:

index=dmc_workday_index taskDisplayName="Manage Payment Elections"  ipAddress!="64.147.*"| stats count by ipAddress | where count > 5

let me know if this helps!

0 Karma

blmclaws
Engager

That worked. Thank you so much for the quick reply.

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...