https://community.splunk.com/t5/Splunk-Search/Can-you-help-me-figure-out-why-my-query-is-not-working/m-p/382900#M172187 <P>Hi</P> <P>try like</P> <PRE><CODE>index=* |stats count by sourcetype, index </CODE></PRE> Thu, 28 Mar 2019 12:56:07 GMT vnravikumar 2019-03-28T12:56:07Z https://community.splunk.com/t5/Splunk-Search/Can-you-help-me-figure-out-why-my-query-is-not-working/m-p/382899#M172186 <PRE><CODE>index=* |stats count by sourcetype |table index sourcetype count </CODE></PRE> <P>The above query displays the sourcetype and count details, but not the index details, Please help me figure out how to proceed.</P> Thu, 28 Mar 2019 11:02:31 GMT https://community.splunk.com/t5/Splunk-Search/Can-you-help-me-figure-out-why-my-query-is-not-working/m-p/382899#M172186 VijaySrrie 2019-03-28T11:02:31Z https://community.splunk.com/t5/Splunk-Search/Can-you-help-me-figure-out-why-my-query-is-not-working/m-p/382900#M172187 <P>Hi</P> <P>try like</P> <PRE><CODE>index=* |stats count by sourcetype, index </CODE></PRE> Thu, 28 Mar 2019 12:56:07 GMT https://community.splunk.com/t5/Splunk-Search/Can-you-help-me-figure-out-why-my-query-is-not-working/m-p/382900#M172187 vnravikumar 2019-03-28T12:56:07Z https://community.splunk.com/t5/Splunk-Search/Can-you-help-me-figure-out-why-my-query-is-not-working/m-p/382901#M172188 <P>You might want to look at this free course as well: <A href="https://www.splunk.com/en_us/training/free-courses/splunk-fundamentals-1.html">https://www.splunk.com/en_us/training/free-courses/splunk-fundamentals-1.html</A></P> Thu, 28 Mar 2019 13:49:43 GMT https://community.splunk.com/t5/Splunk-Search/Can-you-help-me-figure-out-why-my-query-is-not-working/m-p/382901#M172188 amiracle 2019-03-28T13:49:43Z https://community.splunk.com/t5/Splunk-Search/Can-you-help-me-figure-out-why-my-query-is-not-working/m-p/382902#M172189 <P>Fixed.. Don't use <CODE>index=*</CODE> when searching over index time fields </P> <PRE><CODE>| metasearch | stats count by sourcetype, index </CODE></PRE> Thu, 28 Mar 2019 14:07:02 GMT https://community.splunk.com/t5/Splunk-Search/Can-you-help-me-figure-out-why-my-query-is-not-working/m-p/382902#M172189 skoelpin 2019-03-28T14:07:02Z https://community.splunk.com/t5/Splunk-Search/Can-you-help-me-figure-out-why-my-query-is-not-working/m-p/382903#M172190 <P>|metasearch index=* | stats count by sourcetype, index</P> <P>is working fine</P> Sun, 31 Mar 2019 03:36:23 GMT https://community.splunk.com/t5/Splunk-Search/Can-you-help-me-figure-out-why-my-query-is-not-working/m-p/382903#M172190 VijaySrrie 2019-03-31T03:36:23Z