Projections combine with your search statements to specify which columns display for your search results, and how your search results appear in the list. By default, Alert Logic displays search results in descending order by time received and log message. The Search Assistant helps you create projections by providing suggestions as you type.
Every projection statement must start with SELECT, which specifies the data field names that appear as columns in the search results list. The order of the SELECT fields in the projection determines the order, from left to right, of the columns in the results list. You can combine this projection clause with others to further customize the display of your results.
SELECT [Time Received], [Message] ORDER BY [Time Received] DESC
Use AS to create an alias for a field name. The alias ensures the search result displays a cryptic field name as a column name with a more readable, descriptive name. You must type the alias between quotation marks.
Use ORDER BY in a projection to specify the SELECT data field by which to sort search results. You must follow the ORDER BY clause with either DESC or ASC to specify descending or ascending order. If you want to order the results by a column that you named using AS, you must use the alias value you created, including the quotation marks.
Use GROUP BY in the projection to specify a data field by which to group search results. If you want to group the results by a column that you named using AS, you must use the alias value you created, including the quotation marks.
Use COUNT to display the total number of results that match one or more of the SELECT fields.
SELECT [User Name], COUNT (Message) AS "MessageCount" ORDER BY "MessageCount" DESC GROUP BY [Host Name]
Use HAVING to specify that the statement you create displays search results where aggregated values meet the conditions determined by the field you specify.
Use SUM to return the total from a specified numeric column in the results.
Use AVG to return the average value of the specified numeric column.
Use MIN to return the smallest value of the specified numeric column.
Use MAX to return the largest value of the specified numeric column.