Splunk Search

Sum session value from several servers?

mibo
New Member

Hi all,
I've been trying hard for two days now, but doesn't seem to find how to query to get the following graph:

I have three servers. All three have a performance counter called "Active SMTP Sessions" which returns the following field
"Active SMTP Sessions" = 23

I'd like a graph that shows the total amount of SMTP sessions, a sum of the same performance counter from all three servers.

I've managed to do a timechart showing the three values by host followed by the addtotal, and that's nice.
But I really only want the Total on my chart, not all thre servers plus total.

Any ideas?

Tags (2)
0 Karma

hexx
Splunk Employee
Splunk Employee

This doesn't do the trick?

... | timechart sum(active_SMTP_sessions) AS "Total active SMTP sessions"

Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Developer Spotlight with Denis Gladkikh

From Splunk Engineer to Kubernetes App Builder Denis GladkikhWhat happens when a lifelong developer turns a ...

Governing Enterprise AI, Bringing Cisco Telemetry Home, and More from Splunk Lantern

Splunk Lantern is Splunk’s customer success center that provides practical guidance from Splunk experts on key ...

Agentic SOC Triage: Investigating Splunk ES Notables with MCP Server and a Local LLM

The Problem: Too Many Alerts, Too Little Context Security operations teams running Splunk Enterprise Security ...