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!

Think Like an Architect: Introducing the Splunk Certified Cybersecurity Defense ...

In cybersecurity, defenders respond to threats. Architects design the systems that stop them.    As ...

Best Practices: Splunk auto adjust pipeline queue

When you enable autoAdjustQueue in Splunk, maxSize should be understood as the queue size Splunk starts with ...

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...