Correlation search Threat - Risk Correlation By System - Lookup Gen was getting hung and not completing
Running Threat - Risk Correlation By System - Lookup Gen on the ES SHC was getting hung

If you use crt +shift+E to expand the macro, `get_asset(dest)`, it looks like this:
| lookup update=true asset_lookup_by_str asset as "dest" OUTPUTNEW _key as dest_asset_id,asset as dest_asset,asset_tag as dest_asset_tag,bunit as dest_bunit,category as dest_category,city as dest_city,country as dest_country,dns as dest_dns,ip as dest_ip,is_expected as dest_is_expected,lat as dest_lat,long as dest_long,mac as dest_mac,nt_host as dest_nt_host,owner as dest_owner,pci_domain as dest_pci_domain,priority as dest_priority,requires_av as dest_requires_av,should_timesync as dest_should_timesync,should_update as dest_should_update
| lookup asset_lookup_by_cidr asset as "dest" OUTPUTNEW _key as dest_asset_id,asset as dest_asset,asset_tag as dest_asset_tag,bunit as dest_bunit,category as dest_category,city as dest_city,country as dest_country,dns as dest_dns,ip as dest_ip,is_expected as dest_is_expected,lat as dest_lat,long as dest_long,mac as dest_mac,nt_host as dest_nt_host,owner as dest_owner,pci_domain as dest_pci_domain,priority as dest_priority,requires_av as dest_requires_av,should_timesync as dest_should_timesync,should_update as dest_should_update
| lookup asset_lookup_default_fields key as dest OUTPUTNEW pci_domain as dest_pci_domain, is_expected as dest_is_expected, requires_av as dest_requires_av, should_timesync as dest_should_timesync, should_update as dest_should_update
The problem is with the kvstore lookup asset_lookup_by_str asset being large and running into an identified bug, SPL-261387. The bug states:
Workaround
Update the macro definition get_asset() by removing the update=true and forcing the search to run on the indexers instead of locally
| Revision | Publish Date | Comments |
|---|---|---|
1.0 |
29-Sep-2026
|
Initial Release |