In Standard mode Federated Search, remote Splunk Cloud or Splunk Enterprise datasets are mapped to local federated indexes named with the federated: prefix.
Analysts and admins with the fsh_search capability can combine federated indexes with standard transforming commands such as stats or timechart without copying raw data into local Cloud storage.
Write a Standard mode SPL query targeting index=federated:sec_events for action=failure and counting failures by src_ip.
index=federated:sec_events action=failure
| stats count by src_ip
| sort -count