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

Deployment (Part 3)

By Ashwin Venugopal -
Image
  To read part 1, please click  here To read part 2, please click  here Microsoft Monitoring Agent (MMA) MMA is used across multiple Microsoft solutions and has undergone a few name changes as its features and functionality have evolved. If it is being considered to be used, then following areas should be covered during a Microsoft Sentinel deployment project: Consider the timelines and the strategy for a migration to AMA (Azure Monitor Agent) before the MMA end-of-life.  Consider the central deployment and management methodology for MMA. Determine which endpoints are in scope for deployment as these affect the log ingestion volume significantly.  Azure Monitor Agent (AMA) Organizations with MMA as the main Microsoft Sentinel agent should start planning the migration to AMA as soon as possible to avoid a rushed migration. One of the main advantages of AMA is the ability to control the log collection policy centrally and apply different policies against different...
Read more

Deployment (Part 1)

By Ashwin Venugopal -
Image
  To read part 2, please click  here To read part 3, please click  here Azure Resources Microsoft Sentinel needs following resources to be created: Subscription (if a dedicated subscription(s) will be used) Resource group(s) Log Analytics workspace(s) Automation rules/playbook Alert rules Workbooks Microsoft Sentinel offers hundreds of alert rules, workbooks, and automation playbook templates along with hunting scripts. The templates can be used to activate/deploy schedule alerts, create customized dashboards, create automation playbooks and perform threat-hunting activities. Generally, once deployed, the resources created have to be adjusted to match the existing environment, configure local credentials, etc. Methods of deployment: Manual- Administrator can manually configures the Microsoft Sentinel resources with the help of Azure portal. Any manual process has the inherent risks of human operator error, lack of compliance with potential change control procedures, and u...
Read more

Design Planning (Part 3)

By Ashwin Venugopal -
Image
  To read part 1, please click  here To read part 2, please click  here Complex Organizational Structures SIEM can be an expensive security control, hence, it is common multiple businesses to contribute to the overall expense. Various organizational units may require a level of access to specific dashboards or sets of data. Microsoft Sentinel offers the ability to assign table-level permissions and limit the level of access to the minimum required to perform requisite job functions.  Role-based Access Control (RBAC) Requirements Microsoft Sentinel offers an extensive list of Azure built-in roles that can be used to provide granular access according to the job requirements and permitted level of access. Some of them are various Microsoft Sentinel dedicated roles: Microsoft Sentinel Contributor- Can perform all engineering-related configuration, such as creating alert rules, configuring data connectors, and additional similar tasks.  Microsoft Sentinel Reader- Can...
Read more