---
title: Drill Planner
slug: drill-planner
docTags: 
createdAt: 2026-09-24T00:43:43.171Z
---

The Drill Planner is designed for a specific customer to manage Disaster Recovery (DR) test results periodically (quarterly, annually, etc.). It enables users to upload data related to DR drills for multiple applications and view the results in a dedicated dashboard.

It helps organizations track and analyze DR test outcomes, including metrics such as:

- Number of tests completed
- Tests passed or failed
- Pending or overdue tests

This data is used to ensure compliance and readiness for disaster recovery scenarios.

# Process flow diagram

The following diagram illustrates the underlying process flow:

::Image[]{src="https://api.archbee.com/api/optimize/QU1TIK52ntw5Jsos0uOt5/H_DAib2XQx26QOJ2PAV6T_image.png" size="70" isUploading="false" width="892" height="580" darkWidth="892" darkHeight="580" showCaption="false"}

# Process

Follow these steps to complete the process:

1. **Download the template:&#x20;**&#x4E;avigate to the **Bulk Configure** screen and download the **Standard Drill Planner CSV Template**. Then, go to **Download&#x20;**> **Standard Drill Planner CSV template.&#x20;**&#x54;his template includes all required fields for data entry.

:::hint{type="info"}
For more information related to the Bulk Configure screen, go to: [Bulk Configuration](https://docs.kyndryl.com/bulk-configuration).
:::

2. **Populate Data:&#x20;**&#x46;ill in the template with DR test details for each application.

**CSV file for uploading drill results**

The following fields are mandatory to fill in the downloaded CSV file. You must ensure to populate the following information before uploading the CSV file.

- **App ID:&#x20;**&#x55;nique identifier for the application.
- **Short Name:&#x20;**&#x53;hort name of the application.

**Columns descriptions**

See the following column descriptions:

- **App ID**: Unique identifier for the application
- **Short Name**: Short name of the application
- **Platform**: Open System, Cloud, Mainframe
- **Resiliency Tier (RT)**: Tier 1, and 2 (Application needs to be tested every year from the date of the last test), Tier 3 (Application need to be tested 2 years once)
- **Category**: SST (Steady State Test), FTE (First Time Enablement), Re-Cert (Re Certification)
- **Disaster Recovery Status**: Enabled / Not Enabled
- **MF Dependency**: Yes / No
- **Planned Start Date**: Date of DR test
- **Status**: Pass / Fail&#x20;

3. **Upload the CSV file:&#x20;**&#x55;se the **Quarterly Drill Results Upload Template** option on the same screen to upload the populated CSV file. Click **Create > Quarterly Drill Results Upload Template.**&#x20;
4. **Validation Rules:&#x20;**&#x41;pplication ID and Short Name must be present. Blank rows will be ignored.&#x20;
5. **View Results:&#x20;**&#x41;fter a successful upload, the data will be processed and displayed in the **Drill Planner** dashboard.

# Access the Dashboard

To access to this dashboard, from the Kyndryl Bridge main menu :inlineImage[]{src="https://api.archbee.com/api/optimize/QU1TIK52ntw5Jsos0uOt5/NK7Yw9tQgnlqBGwu7eG4H-20260601-205917.svg" alt caption width="57" height="57"}, go to **Services** → **Kyndryl Services** → **Intelligent Recovery Services&#x20;**→ **Recovery** **Dashboard** **menu** → **Dashboard&#x20;**→**&#x20;Drill Planner.**

::Image[]{src="https://api.archbee.com/api/optimize/QU1TIK52ntw5Jsos0uOt5/-CjU4vsu_v_2861mUjFzx_image.png" size="40" isUploading="false" width="744" height="1022" darkWidth="744" darkHeight="1022" showCaption="false"}

If you have not uploaded the completed CSV file to the **Bulk Configure** screen, the following message appears. Click **Upload drill templates** to go to the **Bulk Configure** screen.

::Image[]{src="https://api.archbee.com/api/optimize/QU1TIK52ntw5Jsos0uOt5/NmrssnyObGFGDKUuaP9vw_image.png" size="40" isUploading="false" width="702" height="696" darkWidth="702" darkHeight="696" showCaption="false"}

After the CSV file is uploaded, the Drill Planner dashboard displays the validated data. When users upload Q4 information, a message with a refresh link appears. This indicates that the dashboard is displaying the current year's data and is ready to show next year's data.

Refreshing resets the information, recalculating pending and overdue items for all applications.

![](https://api.archbee.com/api/optimize/QU1TIK52ntw5Jsos0uOt5/bYvvY1n9Vmr-VvI_6QmGm_image.png)

# Features

The following features are available in this dashboard:

- **Filters:&#x20;**&#x54;he Filter feature enables users to refine the dashboard view by applying specific criteria after uploading a CSV file. Users can expand or collapse filter options, select applications and states from the available choices, and apply the filter to update the displayed data. Once applied, all dashboard elements, including graphs, widgets, and the data table, dynamically adjust to reflect the selected filters, ensuring a tailored and focused data view.
- **Key Metrics:**
  - **Total Applications**: Displays the total number of applications included in the uploaded data.
  - **Completed**: Shows the count of successful DR drills.
  - **Failed**: Indicates the number of drills that were executed but failed.
  - **Pending**: Represents applications that still need to be tested. This includes overdue items, failed drills, and those scheduled for the current cycle.
  - **Overdue**: Calculated during the year-end process. It includes drills that were supposed to be executed but were missed or failed in the previous year.
  - **Compliance Status**: Displays the percentage of successful vs. failed drills in a graphical format for quick compliance assessment.
- **Select Year:&#x20;**&#x54;he Drill Planner includes a year‑based view that helps users to review drill data for both the current and previous years. For the current year, the view displays planning‑related metrics such as Pending and Overdue drills, along with the Next Year Planned information.

  When a past year is selected, the Drill Planner automatically switches to a historical view: Pending and Overdue metrics are hidden, the Next Year Planned column is omitted from the Application Drill Status table, and only outcome‑based metrics such as total, completed, failed, and compliant drills are shown.

  In addition, the metrics section heading updates to reflect the selected year, making it clear which year’s data is being viewed. Filters, table data, and downloads update dynamically based on the year selection, while the 3-year trend view remains unchanged to provide consistent long‑term insights.&#x20;
- **Graphs**
  - **Current Year View (Left)**: Shows quarterly drill results for the current year, including pass/fail counts.
  - **Three-Year Trend (Right)**: Consolidates data for the last three years (e.g., 2023, 2024, 2025), highlighting success and failure trends.
  - **Success Percentage Line**: A blue line indicates the success rate for each quarter. Hovering over a point shows detailed percentages.
  - **Target Indicator**: A green line indicates the target success rate for comparison.
- **Download:&#x20;**&#x54;he Download button allows users to export the data displayed in the dashboard’s data table into an Excel file for offline viewing. The downloaded file exactly matches the table, preserving column names, order, and data integrity. When filters are applied, only the filtered data is included in the download.&#x20;
- **Application drill status**
  - **Application ID:&#x20;**&#x41; unique identifier assigned to each application.
  - **Short Name:&#x20;**&#x41; short or abbreviated name for the application.
  - **Tier:&#x20;**&#x49;ndicates the resiliency tier of the application, which determines drill frequency:
    - Tier 1 & Tier 2: Highest priority; drills performed annually.
    - Tier > 2: Lower priority; drills performed once every two years.
- **Category:&#x20;**&#x53;pecifies the type of drill activity:
  - SST: Steady State Test
  - FTE: First Time Enablement
  - Re-Cert: Recertification
- **DR Status:&#x20;**&#x53;hows whether Disaster Recovery is enabled for the application:
  - Enabled or Not Enabled
- **Test Quarter:&#x20;**&#x49;ndicates the quarter in which the drill was performed (e.g., Q1, Q2, Q3, Q4).
- **Test Date:&#x20;**&#x54;he exact date when the drill was executed.
- **Test Status:&#x20;**&#x52;epresents the current status of the drill:
  - Scheduled: Drill planned but not yet executed
  - Success: Drill completed successfully
  - Failed: Drill executed but failed
  - Overdue: Drill was due but not performed within the scheduled cycle
- **Next Test Planned:&#x20;**&#x44;isplays the next scheduled drill date, calculated based on the application’s tier and previous execution date.
