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
| stats count
Hi @jialiu907,
if you want the total number of distinct hosts, you can use
| stats dc(host) AS host_count
ciao.
Giuseppe
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.