This worked for me. Thank you a ton! ... View more

If your queries have anything in common that will allow you to group then you can use post-process searching instead of 18 inline searches. ... View more

First install DB Connect V3 : https://splunkbase.splunk.com/app/2686/ Then run a search like this: | dbxquery shortnames=t "SELECT * FROM (SELECT rval.*,ROWNUM as rn FROM(select count(*) as count,count(1) over() as tcount, Xipm as location from documentreporting where xidcprofile='IpmApp_1' and XIPM_APP_1_9 is not null group by XIPM_APP_1_9 rval )WHERE rn >=1 AND rn <= 100" ... View more