All Apps and Add-ons

Palo Alto App Traffic Dashboard Error

iguarino
New Member

If I try to query by IP in the traffic dashboard, I get the following error:

Error in 'TsidxStats': WHERE clause is not an exact query

Please let me know how I can resolve this error. I'm running splunk 6 on windows with the latest version Palo Alto app.

Thanks!

0 Karma
1 Solution

jtrivilino
Engager

Here is the solution to the issue:

Under the Palo Alto App -> Traffic Dashboard -> Edit -> Edit Source (XML)

You'll see a block of XML code towards the top defining the inputs. The issue is that there are no prefix and suffix identifiers for the first several fields (src_ip, dst_ip, dst_port, and src_user). So, we need to defined those lines of code in order for the search bars to work properly. You'll end up with a chunk of code that looks like this (replacing the [ and ] brackets with appropriate XML < and > brackets):

[input type="text" token="src_ip"]

  [label]Source IP[/label]
  [default][/default]
  [prefix]src_ip="[/prefix]
  [suffix]"[/suffix]

[/input]

[input type="text" token="dst_ip"]

  [label]Destination IP[/label]
  [default][/default]
  [prefix]dst_ip="[/prefix]
  [suffix]"[/suffix]

[/input]

[input type="text" token="dst_port"]

  [label]Destination Port[/label]
  [default][/default]
  [prefix]dst_port="[/prefix]
  [suffix]"[/suffix]

[/input]

[input type="text" token="src_user"]

  [label]Source User[/label]
  [default][/default]
  [prefix]src_user="[/prefix]
  [suffix]"[/suffix]

[/input]

Hope this helps!

View solution in original post

jtrivilino
Engager

Here is the solution to the issue:

Under the Palo Alto App -> Traffic Dashboard -> Edit -> Edit Source (XML)

You'll see a block of XML code towards the top defining the inputs. The issue is that there are no prefix and suffix identifiers for the first several fields (src_ip, dst_ip, dst_port, and src_user). So, we need to defined those lines of code in order for the search bars to work properly. You'll end up with a chunk of code that looks like this (replacing the [ and ] brackets with appropriate XML < and > brackets):

[input type="text" token="src_ip"]

  [label]Source IP[/label]
  [default][/default]
  [prefix]src_ip="[/prefix]
  [suffix]"[/suffix]

[/input]

[input type="text" token="dst_ip"]

  [label]Destination IP[/label]
  [default][/default]
  [prefix]dst_ip="[/prefix]
  [suffix]"[/suffix]

[/input]

[input type="text" token="dst_port"]

  [label]Destination Port[/label]
  [default][/default]
  [prefix]dst_port="[/prefix]
  [suffix]"[/suffix]

[/input]

[input type="text" token="src_user"]

  [label]Source User[/label]
  [default][/default]
  [prefix]src_user="[/prefix]
  [suffix]"[/suffix]

[/input]

Hope this helps!

cckevin
Engager

Thanks. It solve the problem.

0 Karma

cckevin
Engager

I have the same error with Splunk 6 also. Any solution??

0 Karma
Get Updates on the Splunk Community!

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...