Introducing Workbooks (part 1)

By Ashwin Venugopal -


 

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



An Overview of the Workbooks Page

Firstly, you have to select Workbooks page from the Microsoft Sentinel navigation blade to view following icons:
  • The Workbook Header- There are total number of workbooks saved, to the right of it total number of templates, and far-right side is the total number of templates that can be updated under the Refresh and Add workbook buttons.

  • The Templates View- The My Workbooks and Templates tabs can be seen below the workbook header where the My Workbook tab shows all the accessible workbooks including shared as well personal whereas the Templates tab shows all the templates available to be used. You can select any tab. At the My Workbooks tab, every report have a green bar since every report is available to view. After that there is an icon representing the company that created the template, then the template name, and the company's name under this. 

  • Workbook Detail View- After selecting a workbook, its information can be seen on the details window on the far-right of the Workbooks page which will also show the icon, name, and company name at the top of the screen. The Relevant Data connectors can be seen under the Required data types showing which data connectors are used to ingest the needed data and scrolling down will also show one or more reports representing how the report will look.

  • Missing Required Data types- The complete list of the required data types are present under the workbook detail view and lists one or more data types needed for this workbook to function correctly. The green checkbox icon represents the availability of the needed data source in your environment while the cross check icon shows the otherwise. You can also create a workbook from a template without any required data types although it will have no information and may lead to an error.

  • Saved Template Buttons- There are a series of buttons at the bottom of the screen the change according to the template saved or not. Each of these buttons are described as follows-  

  1. If the template is saved as a workbook, then the first button will be View saved workbook which can help you to look at the workbook you have created from the template along with the changes you have made to it. However, if the template is not saved as the workbook, then the Save button is shown which will help you to create a new workbook from a template. 
  2. Next is the View template button which will show whether or not you have saved the template as a workbook already. It allows you to have a fully interactive view of the template although you can only refresh it but cannot save or modify it from this view.
  3. The third button will depend on the saving or not saving of the template as a workbook. If the template is saved then the Delete button will be shown which will cause a validation pop up to appear on clicking and on confirming, the workbook along with all the changes you have made will be deleted.  

If the workbook is created without any help of an existing template, then the View template button will not be shown.






To read part 2, please click here
To read part 3, 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

Planning for Implementing SAP Solutions on Azure (Part 2 of 5)

By Ashwin Venugopal -
Image
  To read part 1 please click  here To read part 3 please click  here To read part 4 please click  here To read part 5 please click  here Load Balancing The load balancer uses probe ports to determine as well as route the traffic to an active DBMS node, but of there's any failover then the most common SAP application architecture can automatically reconnect against the private virtual IP address without the need for the SAP application to reconfigure it, while the load balancer redirect the traffic against the private virtual IP address without any need for the SAP application to reconfigure. The loaf balancer also offers an option of DirectServerReturn which if configured, can help in directing the traffic from the DBMS VM to the SAP application layer directly to the application layer without routing through the load balancer. But, if it isn't configured, then the return traffic to the SAP application layer is routed through the load balancer. You can also use Azure Load Balan
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