Fundamentals 3 Flashcards
What the count aggregation function do?
Returns the number of occurrences of the field X.
What the dc aggregation function do?
Returns the count of distinct values of the field X.
What the sum aggregation function do?
Returns the sum of the values of the field X.
What the min aggregation function do?
Returns the minimum value of the field X.
What the max aggregation function do?
Returns the maximum value of the field X.
What the avg aggregation function do?
Returns the average of the values of field X.
What the median aggregation function do?
Returns the middle-most value of the field X.
What the range aggregation function do?
Returns the difference between the max and min values of the field X.
What the stdev (Standard Deviation) aggregation function do?
Returns the sample standard deviation of the field X.
What the var (Variance) aggregation function do?
Returns the sample variance of the field X.
When aggregation functions are used?
When you want to summarize values from events into a single meaningful value.
These aggregation functions can be used with which commands?
stats, chart and timechart.
All aggregation functions accept what type of fields?
Numeric
How to match a specific field value to be used on the count function?
Using eval, like count(eval(field=”value”))
When do you use phrases as names, how you need to call the field name on a eval expression?
Using single quotes.
What the fieldsummary command do?
Calculate summary statistics for fields in your events.
What the is_exact column on the fieldsummary result means?
If there are more values than returned in the distinct count, this is set to 0, if not, as a 1.
In the fieldsummary, how many distinct values for a field will be returned? How it can be changed?
100, by using maxvals=X argument.
What the appendpipe command do?
It’s used to append a subpipeline search data to your results.
What the list multivalue function do?
Returns a list of up to 100 values of the field X as a multivalue entry.
What does the eventstats command do?
Generate statistics for fields in searched events and save into new fields on the results.
What does the streamstats command do?
Generate statistics for fields in searched events and save into new fields on the results, but in a stream manner, in a per-event basis.
What the current argument of streamstats do?
Include the current event in the sum, default is True.
What the window argument of streamstats do?
Specifies the number of events to use when computing the statistics. Default is 0 (all)
What the time_window argument of streamstats do?
Specify the time windows which the sum is done. Falt is None.
Which are the three main arguments of streamstats?
current, window and time_window.
What are the three types of operations that can be done with eval?
Arithmetic, concatenation and Boolean.