Splunk Search

how to display time of event as a table column

seanlon11
Path Finder

I have the following query:

host=wps03 mc_getLDAPGroupsTimer | table time host username mc_getLDAPGroupsTimer | sort -mc_getLDAPGroupsTimer

I am trying to get the date and time to display in the table, so I can see what happened when, but I obviously have the syntax incorrect. Or, maybe this is not possible for some logical reason.

How can I display the date and time of an event in a table?

Thanks, Sean

Tags (1)
1 Solution

southeringtonp
Motivator

You have the right idea, but you appear to be missing the underscore at the beginning of the _time field.

View solution in original post

southeringtonp
Motivator

You have the right idea, but you appear to be missing the underscore at the beginning of the _time field.

seanlon11
Path Finder

Awesome, worked like a charm!

Get Updates on the Splunk Community!

The All New Performance Insights for Splunk

Splunk gives you amazing tools to analyze system data and make business-critical decisions, react to issues, ...

Good Sourcetype Naming

When it comes to getting data in, one of the earliest decisions made is what to use as a sourcetype. Often, ...

See your relevant APM services, dashboards, and alerts in one place with the updated ...

As a Splunk Observability user, you have a lot of data you have to manage, prioritize, and troubleshoot on a ...