https://community.splunk.com/t5/Splunk-AppDynamics/Analytical-ADQL-query/m-p/718452#M1000 <P>Hi&nbsp;<A href="https://community.appdynamics.com/t5/user/viewprofilepage/user-id/150273">@Rathinakararaj.Sundaraj</A>&nbsp;</P> <P>Can you not use something like below?</P> <P>SELECT * FROM browser_records WHERE pagename not like "*abc.com*"</P> <P>Ciao</P> Mon, 14 Jun 2021 10:46:43 GMT Morelz 2021-06-14T10:46:43Z https://community.splunk.com/t5/Splunk-AppDynamics/Analytical-ADQL-query/m-p/718451#M999 <P>I am looking for an analytical query to fetch list of URLs from browser records that does not match a pagename&nbsp; with http and without http and with partial URL segments...</P><P>example : select * from browser records where pagename is not in ("abc.com", "<A href="https://abc.com" target="_blank" rel="noopener nofollow noreferrer">https://abc.com</A>",%abc.com%)&nbsp;</P> Mon, 14 Jun 2021 09:43:41 GMT https://community.splunk.com/t5/Splunk-AppDynamics/Analytical-ADQL-query/m-p/718451#M999 Rathinakararaj_ 2021-06-14T09:43:41Z https://community.splunk.com/t5/Splunk-AppDynamics/Analytical-ADQL-query/m-p/718452#M1000 <P>Hi&nbsp;<A href="https://community.appdynamics.com/t5/user/viewprofilepage/user-id/150273">@Rathinakararaj.Sundaraj</A>&nbsp;</P> <P>Can you not use something like below?</P> <P>SELECT * FROM browser_records WHERE pagename not like "*abc.com*"</P> <P>Ciao</P> Mon, 14 Jun 2021 10:46:43 GMT https://community.splunk.com/t5/Splunk-AppDynamics/Analytical-ADQL-query/m-p/718452#M1000 Morelz 2021-06-14T10:46:43Z