Thank you for the response! The results look great, I'm new to Splunk and trying to learn the ropes, so help is much appreciated.
Unfortunately, we are having to rebuild the heavy forwarder due to the fact that many events passed from our windows logs are being dropped. This results in not completely reliable data, so although logically your solution should work, we still sometimes have logoff events that do not have a related logon event. Is there a way, once the distinct count and where clause have executed, to filter out the remaining 4634 events?
Thanks.
... View more