I have the below search
index=main sourcetype=summa
| rex "::\s(?<timestamp>\S+)\s"
| rex "^\S+\s(?<userid>\S+)\."
| sort userid timestamp
|transaction login startswith="Logged in" endswith="Processing complete"
| rex "^\S+\s(?<userid>\S+)\."
Which provide the rsultlinke Table-1, I want fix few things in T-1.
1. The reuslt should display some thing like this now this details are spread in two rows one after the other.
USER-id, Login time, log out time, number of login sessaion
Thanks
Rajan
Table-1
4/3/13 11:46:12.000 AM
SNM4 rajan.#### :: 04/03/13 11:46:12 :: User rajan logged in
SNM4 rajan.857F :: 04/03/13 11:46:13 :: Processing complete
host=hostname Options| sourcetype=summa Options| source=C:\Data\splunk\fxr\snm4-logger.log Options
4/3/13 11:46:08.000 AM
SNM4 verify.#### :: 04/03/13 11:46:08 :: User verify logged in
SNM4 different.855F :: 04/03/13 11:46:12 :: Processing complete
4/3/13 11:45:58.000 AM
SNM4 suman.#### :: 04/03/13 11:45:58 :: User suman logged in
SNM4 suman.853F :: 04/03/13 11:45:59 :: Processing complete
host=hostname Options| sourcetype=summa Options| source=C:\Data\splunk\fxr\snm4-logger.log Options
... View more