Task 6, #24 asks to "use the stats command average function to find the average time for each database query being run." I've gone through all the preliminary labs without much issue. However for this on, the answer in the lab for this problem is:
index=main sourcetype=db_audit | stats avg(Duration) as "time to complete" by Command
However, when I run this in my environment (time set to 'all time'), no results are returned. The lab notes indicate that a table should be returned with one column for avg(Duration) and the value below it.
Any suggestions about this problem? Thanks
... View more