Splunk Search

distinct count not working on summary index (sistats)

loganramirez
Path Finder

Splunk Enterprise 9.0.6 and building a summary index of sourcenumbers (count) and distinct destinations called (dc(destinationnumber))

When i run this:

...
| stats count dc(destinationnumber) by sourcenumber


I get something like

sourcenumber,count,dc(destinationnumber)
+15551234567,10,8

indicating it called 10 times to 8 different numbers.
adsf
perfect.

But with this:

...
| sistats count dc(destinationnumber) by sourcenumber

 

i get:

psrsvd_ct_destinationnumber,psrsvd_gc,psrsvd_v, psrsvd_vm_destinationnumber
10,10,1,+19991234567;2,+18881234567;2,+17771234567;1,+15551234567;1 (etc)

Found no clear help in the sistats page and other posts like this one it seems to work (though older posts and not using count)

Best guess is that vm column 'preserves' the details, but idk why dc() isn't working like I expect.

Labels (1)
Get Updates on the Splunk Community!

Exporting Splunk Apps

Join us on Monday, October 21 at 11 am PT | 2 pm ET!With the app export functionality, app developers and ...

Cisco Use Cases, ITSI Best Practices, and More New Articles from Splunk Lantern

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Build Your First SPL2 App!

Watch the recording now!.Do you want to SPL™, too? SPL2, Splunk's next-generation data search and preparation ...