Drill Planner

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 process follow these steps to complete the process download the template navigate to the bulk configure screen and download the standard drill planner csv template then, go to download > standard drill planner csv template this template includes all required fields for data entry for more information related to the bulk configure screen, go to bulk configuration https //docs kyndryl com/bulk configuration populate data fill 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 unique identifier for the application short name short 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 upload the csv file use the quarterly drill results upload template option on the same screen to upload the populated csv file click create > quarterly drill results upload template validation rules application id and short name must be present blank rows will be ignored view results after 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 main menu , go to services → kyndryl services → intelligent recovery services → recovery dashboard menu → dashboard → drill planner 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 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 features the following features are available in this dashboard filters the 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 the 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 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 the 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 application drill status application id a unique identifier assigned to each application short name a short or abbreviated name for the application tier indicates 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 specifies the type of drill activity sst steady state test fte first time enablement re cert recertification dr status shows whether disaster recovery is enabled for the application enabled or not enabled test quarter indicates the quarter in which the drill was performed (e g , q1, q2, q3, q4) test date the exact date when the drill was executed test status represents 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 displays the next scheduled drill date, calculated based on the application’s tier and previous execution date