CIDR Lookup or Join for IP Enrichment

Showing results for 
Show  only  | Search instead for 
Did you mean: 
Please sign in to see details of an important advisory in our Customer Advisories area.

CIDR Lookup or Join for IP Enrichment

L0 Member

I would like to use some custom datasets to enrich some of our XQL searches.  It could be our subnets from our IPAM or in this example the ASN information.  I have used lookups and joins in the past to accomplish this in others tools and would like to do the same with Cortex XQL.  I did look at incidr and incidrlist but it seems to be the opposite of what I'm looking for.


Results would look like below with the ASN org field

Jun 1st 2022curl100.20.0.15AMAZON-02



Base XQL Search

preset = network_story
| filter actor_process_image_name contains "curl" and action_total_upload > 1048576
| fields actor_process_image_name, action_remote_ip


Custom Dataset

dataset = geo_asn_ip4




Bonus Question

I know that XDR already has the ASN information as they have some alerts based off of it.  Is there a way a customer could leverage this data instead of building our own dataset?


Thanks in advance


L3 Networker

Hi @GolfHacker ,


Thanks for posting to our Live Community Forum. Currently the ASN information is not present in the XQL so we recommend leveraging custom datasets just like the one you've created for mapping.




Silviu-Mihail Dascalu

L0 Member

That is good to know that a custom dataset is the only option today.

Do you know of an XQL command that will work with a custom CIDR dataset like I have listed above?

  • 2 replies
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!