Introducing Workbooks (part 2)

By Ashwin Venugopal -


 

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



Creating Workbooks

You can create your own workbook using following ways:
  • Creating a workbook using a template- By following the steps given below, you can create your own workbook using a template which is easier as you have a basis to start from-

  1. Click on the Save button on the templates's details page. 
  2. A pop-up window will ask you about the location to save the new workbook which should be the same where your Log Analytics workspace resides. 
  3. Now you can click OK to create a new workbook under My workbooks, with the same name as the template.

This is a very simple method to create a workbook that can be modified as required.

  • Creating a new workbook from scratch- This method is a bit more complicated as it requires creating a workbook, and then its editing as it is already saved with a default query assigned to it. You have to perform the following steps-  

  1. Click the Add workbook button on the header which will create a workbook.
  2. The new workbook consists of texts and a query step already to give you a headstart. 
  3. Now you can click on the Save icon in the header to save the workbook which will open a Save dialog box.

Now, you just have to edit the workbook so that you can modify the existing steps or add your own steps.

Editing a Workbook

If you want to edit your workbook, you have to perform following steps:
  1. Go to either of the tabs.
  2. Select the workbook in question.
  3. Now, select the View saved workbook button on the workbook's detail pane. 

Note- You cannot edit a workbook template directly as it must be saved first and then edited, but if you have created a workbook from scratch, then, you have to go to the My workbooks tab to edit it.

At the top of the page where header of buttons is shown, the first one on the left is Edit button which change the workbook view to edit mode. Each step in a workbook have its own Edit button so that the changes can be individually.

After you are finished with the editing, you can click on the Done Editing button in the header barto revert to the view mode. Now you can easily ensure that the edits you have just made are working properly or not before Saving them. 

Managing Workbooks

Managing a workbook involves deleting, moving, and sharing workbooks. Click on the Open button while looking for a saved workbook which will open a Saved workbooks blade. At the top of it is the New button which can create a new workbook, the Refresh button to refresh the view, and the Save all button to save all the changes. Below this is the Subscription drop-down menu to change the subscription you are looking at along with a search box to search for particular workbooks. 

There is a list of all the workbooks below named as My reports, which only you can see, and Shared reports which everyone can see. Each workbook will be shown in a separate row with its name and an icon to show if the workbook is created from a template or not. There is a context-sensitive menu icon which help you to delete, rename, move, or pin the workbook to a dashboard (to offer a shortcut).





To read part 1, 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