topic Re: How to count total with only displaying one stat? in Splunk Search

How to count total with only displaying one stat?

jialiu907 — Tue, 06 Jun 2023 15:26:40 GMT

I am looking to display only one statistic row being named Total with the count of all of the hosts added up, which should equal around 450, give or take. I know how to add it up in the way of using addcoltotals but I am only looking for the Total row, excluding the rest of the stats.

I have attached the base search and the current output.

index=os source=ps host=deml* OR host=sefs* OR host=ingg* OR host=us* OR host=gblc* NOT user=dcv NOT user=root NOT user=chrony NOT user=dbus NOT user=gdm NOT user=libstor+ NOT user=nslcd NOT user=polkitd NOT user=postfix NOT user=rpc NOT user=rpcuser NOT user=rtkit NOT user=colord NOT user=nobody NOT user=sgeadmin NOT user=splunk NOT user=setroub+ NOT user=lp NOT user=68 NOT user=ntp NOT user=smmsp NOT user=dcvsmagent NOT user=libstoragemgmt | dedup user | stats count by host

Re: How to count total with only displaying one stat?

gcusello — Tue, 06 Jun 2023 15:33:13 GMT

Hi @jialiu907,

if you want the total number of distinct hosts, you can use

| stats dc(host) AS host_count

ciao.

Giuseppe

Re: How to count total with only displaying one stat?

ITWhisperer — Tue, 06 Jun 2023 15:35:01 GMT

| stats count

Re: How to count total with only displaying one stat?

jialiu907 — Tue, 06 Jun 2023 15:40:16 GMT

Hey, so that gives me the count of the hosts, but what I am really looking for is to count up all of the numbers on the right side and have one total count of that without doing addcoltotals.