https://community.splunk.com/t5/Splunk-Search/How-to-list-out-all-the-lookups-and-display-count-of-records/m-p/599478#M208661 <P>You could try something like this (although you may get some errors if your definitions aren't complete):</P><LI-CODE lang="markup">| rest/servicesNS/-/-/data/lookup-table-files | table title | map maxsearches=200 search="| inputlookup $title$ | eval title="$title$" | stats count by title"</LI-CODE><P>Also, note you may have to adjust maxsearches depending on how many files you have.&nbsp;</P> Thu, 26 May 2022 18:17:19 GMT ITWhisperer 2022-05-26T18:17:19Z https://community.splunk.com/t5/Splunk-Search/How-to-list-out-all-the-lookups-and-display-count-of-records/m-p/599473#M208660 <P>Hi Friends,</P> <P>&nbsp;</P> <P>I am trying to list out all the available splunk lookups and want to display count of records present in each lookups.</P> <P>However i found rest command to list out all the lookups but how to get count of records for each lookup ?</P> <P>Rest command :&nbsp;</P> <PRE>| rest/servicesNS/-/-/data/lookup-table-files |table title </PRE> <P>&nbsp;I want to display count of records present in each lookup in another column. Is it possible to display with SPL?</P> <P>Requesting your valuable feedback and help.</P> <P>Thank you in advance.</P> <P>Himanshu</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 26 May 2022 18:19:41 GMT https://community.splunk.com/t5/Splunk-Search/How-to-list-out-all-the-lookups-and-display-count-of-records/m-p/599473#M208660 himanshu1 2022-05-26T18:19:41Z https://community.splunk.com/t5/Splunk-Search/How-to-list-out-all-the-lookups-and-display-count-of-records/m-p/599478#M208661 <P>You could try something like this (although you may get some errors if your definitions aren't complete):</P><LI-CODE lang="markup">| rest/servicesNS/-/-/data/lookup-table-files | table title | map maxsearches=200 search="| inputlookup $title$ | eval title="$title$" | stats count by title"</LI-CODE><P>Also, note you may have to adjust maxsearches depending on how many files you have.&nbsp;</P> Thu, 26 May 2022 18:17:19 GMT https://community.splunk.com/t5/Splunk-Search/How-to-list-out-all-the-lookups-and-display-count-of-records/m-p/599478#M208661 ITWhisperer 2022-05-26T18:17:19Z https://community.splunk.com/t5/Splunk-Search/How-to-list-out-all-the-lookups-and-display-count-of-records/m-p/599573#M208695 <P>Thank you so much for your valuable feedback.</P><P>Query is working fine but it gets terminated if it encounters any invalid lookup.</P><P>any workaround to fix this issue ?</P><P>Thank You,&nbsp;</P> Fri, 27 May 2022 11:17:51 GMT https://community.splunk.com/t5/Splunk-Search/How-to-list-out-all-the-lookups-and-display-count-of-records/m-p/599573#M208695 himanshu1 2022-05-27T11:17:51Z