XQL Query DNS resolutions

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

XQL Query DNS resolutions

L3 Networker

I'm attempting to pull out the name, type, and value from the dns_resolutions data

The below query results in "FAILED TO RUN QUERY" with no data, removing the alters does return data however no fields available return "value" in the dns_resolutions 

Any help would be appreciated

 

preset= network_story
| filter (dns_query_name != null)
| arrayexpand dns_resolutions

| alter DNS_Expand_Name=json_extract(dns_resolutions, "$.name")
| alter DNS_Expand_Type=json_extract(dns_resolutions, "$.type")

| alter DNS_Expand_Value=json_extract(dns_resolutions, "$.value")

 

below is an example of the expanded view of dns_resolutions

{
  "type""A",
  "value""199.125.15.90"
}
 
2 REPLIES 2

L5 Sessionator

Hi @NathanBradley does it work with any one of the alter statements? You can add one alter statement at a time to determine if something is amiss. 
I would also add the following line '| limit 10' and progressively increase the number to determine what is working.

I ran the exact query that you shared and it works just fine.

L3 Networker

Same results when i add a single alter.

Also,same failed to run result if i change to dataset=xdr_data

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!