--- alias: user-guide-business-intelligence-dashboard-maintenance-information grafana_json: Library/Build/ConfigFiles/Grafana/MES/dashboards/MaintenanceInformation.json tags: - dashboard - maintenance description: "This dashboard provides insights for monitoring maintenance activities, resource reliability, and equipment downtime" --- # Maintenance Information ## Overview The **Maintenance Information** dashboard provides insights about open maintenance activities, including both corrective and preventive Maintenance Activity Orders (MAOs), as well as resource reliability metrics. It supports maintenance planning, identification of equipment with the most corrective work, and monitoring of recovery times and time between failures. ## Folder * Performance ## Database * DWH (queried via Cube using GraphQL) * CDM (queried via OData) ## Data * Pending Corrective MAOs * Pending Preventive MAOs * Mean Time Between Failures (MTBF) * Mean Time To Recovery (MTTRec) ## Example ![Example of the Maintenance Information dashboard](../images/maintenance_information_dashboard.png) ## Data Breakdown | KPI | Description | Formula | Datasource | | --- | ------ | --- | -----| | **Pending Corrective MAOs** | Measures the number of Corrective Maintenance Activity Orders that have been requested but not completed. | None | Maintenance Order [[user-guide-data-set-index]] | | **Pending Preventive MAOs** | Measures the number of Preventive Maintenance Activity Orders that have been requested but not completed. | None | Maintenance Order [[user-guide-data-set-index]] | | **Mean Time Between Failures (MTBF)** | Quantifies the average uptime of a system before a failure occurs. It reflects reliability - the higher the MTBF, the more time the equipment stays operational between failures. The data shown in this KPI is the average of the time that a Resource spends between Unscheduled/Scheduled Down states. | (Total available time − Total downtime) ÷ Number of failures | `resource_states` in [[user-guide-resourcecube]] | | **Mean Time To Recovery (MTTR)** | Reflects how long, on average, it takes to recover from a failure, that is, how long the machine remains unavailable. The data shown in this KPI is the average of the total downtime that a Resource spends between Unscheduled/Scheduled Down states. | Total downtime ÷ Number of failures | `resource_states` in [[user-guide-resourcecube]] | ## Data Visualization | Panel | Description | Threshold Values | Datasource | |-------|-------------|------------------|------------| | **Overall KPIs** | Displays values for Pending Corrective MAOs, Pending Preventive MAOs, MTBF, and MTTRec. | MTBF should be as high as possible and MTTRec as low as possible. | [[dataplatform-ioteventdefinition-dataset-maintenanceorder]] and `resource_states` cube in [[user-guide-resourcecube]] | | **List of MAOs** | Table showing active MAO details: Schedule Date, Schedule State, Maintenance Activity (MA), Type, Applied To, and Duration. It excludes canceled MAOs.| N/A | [[dataplatform-ioteventdefinition-dataset-maintenanceorder]] | | **Resources with Most Corrective MAOs** | Horizontal bar chart ranking resources by corrective MAO count. | Longest bar represents the highest number of corrective MAOs. | `resource_maintenance` cube in [[user-guide-resourcecube]] | ## Entity Filters ### Single selection * Enterprise * Site ### Multiple/All selection * Facility * Area * Resource {% include-markdown 'includes/pages/dashboards_filter_options.md' %}