CustomerID Time CrashCount EventDescription
20:12:13:14:0A:45 09/19/2012 20:12:13.1 07 Poor IB SNR
20:12:13:14:0A:42 09/19/2012 20:12:13.1 04 HDD FULL
20:12:13:14:0A:45 09/19/2012 20:12:13.1 07 Poor IB SNR 20:12:13:14:0A:45 09/19/2012 20:12:13.1 02 HDD FULL
20:12:13:14:0A:41 09/19/2012 20:12:13.1 05 Poor IB SNR
I have a data of the type shown above. The search that is generating this data is:
<param name="search">sourcetype="$sourcetype$"
| spath path="EID" output=EventID
| spath path="CT" output=Critical
| spath path="SID" output=StbID
| search EventID="$EventID$"
| search Critical="$Critical$"
| search StbID="*"
| fields - _raw
| fields + StbID, _time, EventID
| join type=inner EventID
[ SEARCH sourcetype="jsonformat"
| spath path="EID" output=EventID
| spath path="EventDescription" output=EventDescription
| FIELDS EventID, EventDescription ]
| rename _time AS "Time", StbID AS "CustomerID"
| convert ctime(Time)
| search EventDescription="VMS*"
| join type=inner EventID
[ SEARCH sourcetype="jsonxmlall"
| spath path="EID" output=EventID
| spath path="CNT" output=CrashCount
| spath path="LPD" output=LeakPerDay
| spath path="IO" output=IOwait
| spath path="SNR" output=SNRValue
| spath path="TMP" output=HardDiskTemp
| fields EventID, CrashCount, LeakPerDay, IOwait, SNRValue, HardDiskTemp ]
</param>
I need to sort this search on the basis of each column. Can you help me how to achieve that as I have tried so many things but not able to do that.
Thanks in advance.
... View more