How To Import, Export, and Share Workbooks in Azure Sentinel

5 min read

In this quick article, I will share with you how to import, export, and share workbooks in Azure Sentinel.

Introduction

Azure Sentinel is a cloud-native Security Information Event Management (SIEM) and Security Orchestration Automated Response (SOAR) solution. Azure Sentinel delivers intelligent security analytics and threat intelligence across the enterprise, providing a single solution for alert detection, threat visibility, proactive hunting, and threat response.

Workbooks is one of many features that is included in Azure Sentinel that falls under Threat Management which is something you must consider for visualizing your data in Azure Sentinel more effectively.

How To Import, Export, and Share Workbooks in Azure Sentinel 1

The good news is that all the different workbooks Templates shown in the figure below are pulled live from the Azure Sentinel GitHub repository, which I highly encourage you to check it out. At the time of this writing, there are 71 templates ready to use. Microsoft is constantly adding new templates too.

How To Import, Export, and Share Workbooks in Azure Sentinel 2

Additionally, you can also contribute and build your custom workbooks. What if you want to import and export workbooks and share it with others?

Prerequisites

To follow this article, you need to have the following:

  1. Azure subscription – If you don’t have an Azure subscription, you can create a free one here.
  2. Log Analytics workspace – To create a new workspace, follow the instructions here Create a Log Analytics workspace.
  3. Azure Sentinel – To enable Azure Sentinel at no additional cost on an Azure Monitor Log Analytics workspace for the first 31-days, follow the instructions here.
  4. Available data in your Azure Sentinel/Log Analytics workspace.

Import workbooks

To import workbooks in Azure Sentinel, take the following steps:

  1. Open Azure Portal and sign in with a user who has Azure Sentinel and Azure Workbooks Contributor permissions.
  2. Click All services found in the upper left-hand corner. In the list of resources, type Azure Sentinel. As you begin typing, the list filters based on your input.
  3. Click on Azure Sentinel and then select the desired Workspace.
  4. From Azure Sentinel’s sidebar, select Workbooks under the Threat Management section and then click + Add workbook. How To Import, Export, and Share Workbooks in Azure Sentinel 3
  5. Click the Edit button by pressing the pen button as shown in the figure below. How To Import, Export, and Share Workbooks in Azure Sentinel 4
  6. Then click on this button </> to enter the Advanced Editor. How To Import, Export, and Share Workbooks in Azure Sentinel 5
  7. Please delete all the current JSON info template. How To Import, Export, and Share Workbooks in Azure Sentinel 6
  8. For this example, I will use a published template on GitHub called (User Map): https://github.com/Azure/Azure-Sentinel/blob/master/Workbooks/UserMap.json
  9. Click the RAW button, then select all the text (CTRL+A), then copy it (CTRL+C). How To Import, Export, and Share Workbooks in Azure Sentinel 7
  10. Then back to Azure Sentinel paste it (CTRL+V) into the Advanced Editor. Press the Apply button, and adjust the workbook settings based on your needs, and then click Save. How To Import, Export, and Share Workbooks in Azure Sentinel 8
  11. Give the Workbook a descriptive title, choose where to save the report (Save To), the desired Subscription, the Resource group name, and Location. If you want to let others in your organization use the workbook, under Save to select Shared reports. If you want this workbook to be available only to you, select My reports. Then click Save again. How To Import, Export, and Share Workbooks in Azure Sentinel 9

Once the workbook is imported, you will see it under My workbooks tabs as shown in the figure below. You can use it by clicking on ‘View saved workbook‘, you can ‘View template‘ or ‘Delete‘ it.

How To Import, Export, and Share Workbooks in Azure Sentinel 10

Export workbooks

To export workbooks in Azure Sentinel, take the following steps:

  1. Open Azure Portal and sign in with a user who has Azure Sentinel and Azure Workbooks Contributor permissions.
  2. Click All services found in the upper left-hand corner. In the list of resources, type Azure Sentinel. As you begin typing, the list filters based on your input.
  3. Click on Azure Sentinel and then select the desired Workspace.
  4. From Azure Sentinel’s sidebar, select Workbooks under the Threat Management section and then choose the desired workbook that you want to export.
  5. Once the workbook page opens, click on the Edit button by pressing the pen button as shown in the figure below. How To Import, Export, and Share Workbooks in Azure Sentinel 11
  6. Then click on this button </> to enter the Advanced Editor.
  7. Then select all the text (CTRL+A) under Gallery Template which is in JSON format, and then copy it (CTRL+C) as shown in the figure below. How To Import, Export, and Share Workbooks in Azure Sentinel 12
  8. You can also download the template by pressing the download button as shown in the figure below. The ‘Gallery Template‘ will download the file as .workbook and the ‘ARM Template‘ will be a JSON file. The content of the file is similar to the template shown in the previous step. How To Import, Export, and Share Workbooks in Azure Sentinel 13
  9. Open the JSON template with your favorite editor such as VS Code, and then push it to GitHub / Azure DevOps private repository.
  10. Once you finish click Cancel.

You can repeat the same steps described above to import the workbook.

That’s it there you have it!

Sharing workbooks

You can also share workbooks with other users in three simple steps:

  1. Select the desired workbook that you want to share from the list of workbooks and then click ‘View saved workbook‘.
  2. Once the workbook page opens, click on the share button, then you get a link with the name ‘Share a link to this report‘ on the right-hand side as shown in the figure below. How To Import, Export, and Share Workbooks in Azure Sentinel 14
  3. This will give you a link URL that can be shared with other users, however, in order to access that URL, that person must have an Azure account, and must have an Azure Sentinel Workbook Reader access. Otherwise, they won’t be able to see it. This is not an authenticated link, they need to have a login with sufficient permissions to be able to see that URL.
  4. You can also share the link via email which will open the mail app on your machine to send it.

Summary

In this article, I showed you how to import and export workbooks in Azure Sentinel, so you can work with workbooks more effectively and share with other team members in your organization.

The power of Azure Sentinel comes from the ability to detect, investigate, and remediate threats. To do this, you must first ingest data in the form of alerts from different security providers, such as Azure Security Center or other Microsoft solutions, as well as other third-party solutions.

Additional resources I highly encourage you to check:

__
Thank you for reading my blog.

If you have any questions or feedback, please leave a comment.

-Charbel Nemnom-

Related Posts

About Charbel Nemnom 579 Articles
Charbel Nemnom is a Cloud Architect, Swiss Certified ICT Security Expert, Microsoft Most Valuable Professional (MVP), and Microsoft Certified Trainer (MCT), totally fan of the latest's IT platform solutions, accomplished hands-on technical professional with over 17 years of broad IT Infrastructure experience serving on and guiding technical teams to optimize the performance of mission-critical enterprise systems. Excellent communicator is adept at identifying business needs and bridging the gap between functional groups and technology to foster targeted and innovative IT project development. Well respected by peers through demonstrating passion for technology and performance improvement. Extensive practical knowledge of complex systems builds, network design, business continuity, and cloud security.

Be the first to comment

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.