Microsoft Sentinel Logs & Writing Queries (part 3 of 3)

By Ashwin Venugopal -


 

To read part 1, please click here
To read part 2, please click here



The Results Window

It is located below the query window and obviously shows the results of your queries. I can also hide or show columns, filter the results as well as change how the results look.

The results window header

As the name suggests it is at the very top of the results window and offers information related to the results. The left side will tell you the information regarding your query while to the right of that is a stopwatch icon which is a very important tool to determine the efficiency of the running query. On the far right, is the total number of records returned which can be any number from 0 to 10,000 and help you to determine if there is a requirement to refine the query further or not. 

The table tab

On the left side of the page there are two tabs that allows you to define and filter your queries. On the far left is the default Table view showing the results in a column/row format. The Chart tab is next to it and shows the results in a chart. Whether you choose the Table or Chart tab, the following items will always be shown-
  1. Display time- It provides you the information of the time zone to show the time in the results window. You can change it with the help of drop-down menu or use Settings section to know how to change it for all the results window.
  2. Copy request ID- This button is located on the far right side and can provide GUID representing the request copied into the clipboard. It will come in handy if you ever want to contact Microsoft for support to easily locate the query and assist you.

There is a listing of the results column required to be shown, below the grouping area. You can simply click on the name of the column to sort the results which will sort in ascending order for the first time while in descending order next time. 

The result footer

As the name suggests, it is located at the bottom of the screen which can allow you to page forward as well as back through your results, show you which page number you are on, and change how many items can be shown on the page for this particular result window. Its parts are described below-

  1. The go to the first page button will take you to the first page results and is active only when you have more than one page of results while you are not on the first page of results.
  2. The X listing depicts the the current page you are on and Y one represents total number of pages.
  3. The go to the next page button simply take you to the next page of results which is active only if you have more than one page of results and you are not on the last page of results.
  4. The go to the last page button simply take you to the last page of results which is active only if you have more than one page of results and you are not on the last page of results.
  5. The drop-down menu for items per page helps you to change the number of rows the results are shown on this particular page of results. You can choose 50, 100, 150 or 200 items per page. 

The chart tab

If you want to view the results graphically, you can select the Chart tab. A drop-down menu present can change the type of chart shown which can be named after the currently selected graphical choice, but the fields will differ after that.



To read part 1, please click here
To read part 2, please click here














Comments

Post a Comment

Popular posts from this blog

Query, Visualize, & Monitor Data in Azure Sentinel

By Ashwin Venugopal -
Image
  Azure Sentinel Workbooks Several ready for use templates are provided by the Azure Sentinel that can be used to create your own workbook and then modify them as needed for Contoso. Most of the data connectors it uses to ingest data come with their own workbooks, but better insight can be obtained by simply looking into the data that is being ingested by using tables and visualizations, including bar and pie charts. You can also make your own workbook easily by using this data from the beginning instead of using the predefined templates. Workbook Page You can easily access the workbook page from the Azure Sentinel from the navigation pane which consists of the: Workbook header- You can add a new workbook and review the saved workbooks as well as templates that are available on the workbook page. Templates section- You can access existing workbook templates on the Templates tab. You can save some of the workbooks for quick access and they will appear on the My Workbooks tab.  From the
Read more

Work with String Data Using KQL Statements

By Ashwin Venugopal -
Image
  Extract Data from Unstructured String Fields Unstructured string fields often contains the Security log data and requires parsing to extract data. There are multiple ways of pulling information from string fields in KQL and the two primary operators used are extract and parse.  Extract It gets a match for a regular expression from a text string. You can convert the extracted substring to the indicated type.  Arguments regex- A regular expression. captureGroup- A positive int constant indicating the capture group to extract. 0 stands for the entire match, 1 for the value matched by the first '('parenthesis')' in the regular expression, 2 or more for subsequent parenthesis.  text- A string to search. typeLiteral- An optional type literal. If provided, the extracted substring is converted to this type.  Returns If regex finds a match in text- the substring matched against the indicated capture group captureGroup, optionally converted to typeLiteral. If there's no mat
Read more

Threat Hunting in Microsoft Sentinel (part 1)

By Ashwin Venugopal -
Image
  To read part 2, please click  here To read part 3, please click  here Introducing the Microsoft Sentinel Hunting Page Threat hunting is a series activities performed while investigating and as there are no guidelines to perform it, the available tools on the Microsoft Sentinel can be introduced to perform better in your investigations. Firstly, you have to choose the Hunting link in the Microsoft Sentinel navigation menu to get to the Hunting page which is divided into the following sections: The header bar- It is located at the top of the page as usual and contains Refresh as well as timespan drop down menu. The New Query button can help you with creating a new query and the Run all queries button can run all the hunting queries in the background while also updating the hunting query list section with the number of results found.  The summary bar- Here, you can view the total number of queries available to run, the total number of bookmarks, the number of results from running live
Read more