Hi,
I'm having this type of queries, how can i run this in splunk:
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
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"