Splunk AppDynamics

Analytical ADQL query

Rathinakararaj_
New Member

I am looking for an analytical query to fetch list of URLs from browser records that does not match a pagename  with http and without http and with partial URL segments...

example : select * from browser records where pagename is not in ("abc.com", "https://abc.com",%abc.com%) 

Labels (1)
Tags (1)
0 Karma
1 Solution

Morelz
Motivator

Hi @Rathinakararaj.Sundaraj 

Can you not use something like below?

SELECT * FROM browser_records WHERE pagename not like "*abc.com*"

Ciao

View solution in original post

Morelz
Motivator

Hi @Rathinakararaj.Sundaraj 

Can you not use something like below?

SELECT * FROM browser_records WHERE pagename not like "*abc.com*"

Ciao

Get Updates on the Splunk Community!

Splunk Observability Cloud's AI Assistant in Action Series: Auditing Compliance and ...

This is the third post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...