Asset performance reports in the Hardware Asset Workspace
Summarize
Summary of Asset performance reports in the Hardware Asset Workspace
The asset performance reports in the Hardware Asset Workspace provide ServiceNow customers with detailed insights into the operational efficiency of their hardware assets. These reports measure key performance indicators (KPIs) such as asset availability, mean time between failures (MTBF), mean time to repair (MTTR), and total asset task time. Tracking these KPIs helps organizations monitor asset health, improve maintenance, reduce downtime, and optimize asset lifecycle management.
Show less
Key Features
- Asset KPIs Measurement: Calculates asset availability, MTBF, MTTR based on asset operational schedules and associated tasks like repairs and incidents.
- Operational Schedule Integration: Uses defined operational schedules linked to assets to accurately reflect uptime and downtime within business hours.
- Outage Management: Automatically creates and merges outage records for unplanned downtime events and incidents, ensuring precise downtime tracking.
- Asset Hierarchy Outage Propagation: Outages on required child assets affect parent assets and vice versa, allowing accurate reporting across asset dependencies.
- Scheduled KPI Calculations: Weekly scheduled jobs update asset KPIs and generate reports, with options to calculate historical data for existing assets.
- Reporting Access: KPI reports are accessible via the asset form sidebar and the Asset analytics view, displaying individual and aggregate asset performance metrics.
Key Outcomes
- Reduced Unplanned Downtime: Real-time monitoring and outage tracking enable proactive issue detection and prevention.
- Enhanced Maintenance Efficiency: Metrics such as MTTR and MTBF support better scheduling and resource allocation for repairs.
- Extended Asset Life and ROI: Early detection of wear allows timely maintenance, maximizing equipment longevity.
- Improved Financial Planning: Identification of underperforming assets or locations facilitates informed investment decisions.
- Compliance with Service Levels: Monitoring asset availability ensures alignment with SLAs and production requirements.
Considerations and Requirements
- Model categories must be opted in for KPI tracking; opting in parent categories does not automatically include child categories.
- The First Used field on hardware assets must have a valid timestamp for accurate tracking; missing values exclude assets from KPIs.
- KPIs are not calculated for pallets, consumables, or bundle assets.
- An operational schedule must be defined or a default schedule is applied to calculate KPIs accurately.
- KPI calculation starts when an asset moves to the In use state and stops when it is Retired or Missing.
Practical Use for ServiceNow Customers
By leveraging asset performance reports, customers can gain a comprehensive understanding of hardware asset health and operational efficiency. This enables improved maintenance planning, better resource utilization, and strategic financial decisions. The integration with operational schedules and automatic outage tracking ensures accurate and actionable performance data, which is essential for meeting service levels and maximizing asset value. Customers are encouraged to configure model categories, operational schedules, and regularly run scheduled KPI calculation jobs to maintain up-to-date insights.
Gain insights into the overall operational efficiency of your organization's hardware assets by using the asset performance reports available in the Asset analytics view.
- Asset availability to determine when the asset is operational
- Mean time between failures (MTBF) to measure reliability
- Mean time to repair (MTTR) to measure repair efficiency
- Total asset task time summary to measure the total time worked on the related tasks for an asset and its child assets.
Benefits of tracking asset performance
- Reduce unplanned downtime
- Real-time asset health monitoring can prevent and predict issues before they cause downtime.
- Improve maintenance efficiency
- Metrics like MTTR and MTBF help you schedule maintenance more effectively, reducing wasted time, and improving technician efficiency.
- Maximize asset life and return on investment (ROI)
- By detecting early signs of wear and tear and scheduling timely repairs, organizations can make their equipment last longer and delay the need for replacements.
- Enhance financial planning
- Performance insights help identify models or locations with poor performance or ongoing problems, guiding better investment choices.
- Align operations with service levels
- Tracking availability ensures that assets achieve the required uptime targets set by service level agreements (SLAs), compliance standards, or production schedules.
Considerations, requirements, and limitations
- To track additional hardware model categories in KPIs, opt in the relevant HAM resource categories. Otherwise, newly added model categories do not appear in performance metrics or dashboards.
- The First Used field on HAM assets must contain a valid timestamp for accurate asset performance tracking. Assets with missing or invalid First Used values are excluded from performance calculations, creating gaps in lifecycle and utilization reporting.
- Asset key performance indicators (KPIs) aren't calculated for pallets, consumable, and bundle assets.
- Asset KPIs aren't calculated by default.
- To track asset KPIs including Asset availability, MTBF, and MTTR, complete these configurations:
- Opt in to the model categories of the assets for which you want to monitor the KPIs.Note:If a model category has child categories, selecting the parent category for performance tracking doesn’t automatically include the child categories. You need to opt in to the specific child categories you want to track.
- Define an operation schedule, which is a collection of schedule entries that specify the operational status and total operational duration for any entity that references the schedule. The schedule entries define calendar hours of
operation within a schedule.
For details, see Create an operational schedule for hardware assets.
Note:If an operational schedule isn't defined, the Default operation schedule is applied. - Create an Asset schedule to associate the hardware assets with an operational schedule.Note:If an asset isn't associated with an operational schedule, the Default asset schedule will be applied.
- Opt in to the model categories of the assets for which you want to monitor the KPIs.
- The calculation of asset KPIs for hardware assets begins when the asset transitions to the In use state for the first time.
- KPIs are tracked until the state of the asset changes to Retired or Missing.
Calculation of asset KPIs
The KPIs are calculated based on the tasks associated with the asset and the operational schedule of the asset. The KPI values are stored in the Asset availability [sn_ent_asset_availability] table, which extends the Service Availability table.
Performance tracking for assets that belong to a model category opted in for performance tracking begins when the asset’s state changes to In use for the first time. A record is then created in the Asset Availability table with Asset availability % set to 100. The Asset availability % value decreases when the asset experiences an outage.
- Outage record creation
- An outage record is created in the Outages [cmdb_ci_outage] table in the following unplanned outage scenarios:
- The state of an asset changes from In use to any of the following:
- In stock - Pending repair
- In stock - Pending disposal
- In stock - Defective
- An incident is created
The outage record is closed when:- The status of the asset changes back to In use.
- The incident is closed.
The duration of the outage is calculated when the repair task is closed.
- The state of an asset changes from In use to any of the following:
- Handling overlapping outages
-
Outages can overlap due to multiple events being logged within the same time window. To maintain accurate KPI calculations, overlaps between unplanned outages are handled with these rules:
- When multiple unplanned outages, such as an asset moving from In use to In stock - pending repair state and an incident being created on the same asset, occur during overlapping time periods, they are not treated as separate outages. Instead, they are merged into a single outage to avoid overstating downtime.
- The total duration of this combined outage is calculated by merging all overlapping time intervals.
- A sample outage calculation is here:
- Outage A: 10:00 AM – 12:00 PM
- Outage B: 11:30 AM – 1:00 PM
Result: The resulting outage window is 10:00 AM – 1:00 PM (a single 3-hour outage).
- Passing on outages through the asset hierarchy
- In an asset hierarchy, outage on assets or their child assets are handled as follows:
- If a child asset with the Required field set to true experiences an outage, its parent asset will also have the outage.
- If a parent asset has an outage, all its child assets will also have the outage.
| Asset KPI | Formula |
|---|---|
| Asset availability (in %) |
|
| Mean time between failures (MTBF) (in hours) |
|
| Mean time to repair (MTTR) (in hours) |
|
| Variable | Definition |
|---|---|
| Operating hours | The duration from when the asset first transitioned to the In use state until the current date and time within the asset schedule. |
| Planned downtime | The duration from when the asset transitioned from the Work in progress state to the Closed complete state. |
| Unplanned downtime | The duration from when the asset transitions from the In use state to any repair state, such as In stock - Pending repair, In stock - Pending disposal, or In stock - Defective, until it returns to the In use state, within the
asset schedule. If there are overlapping durations between the repair state and an incident on the same asset, the combined duration of both is considered. The asset schedule is also considered when determining the outage duration. |
| Total unplanned outages | The count of total outage records for an asset. Overlapping and concurrent outages are consolidated as one outage. |
Accessing asset KPI reports
- Contextual sidebar of the asset Form: You can view the following reports by using the options available in the contextual sidebar of the asset form.
- Asset performance tab on the Asset analytics view: You can view the average values of the KPIs, including Average availability, Average MTTR, and Average MTBF, for all the assets that are being tracked. Additionally, you can see a list of the assets that contributed to the calculation of these KPIs. For details, see Asset analytics view in the Hardware Asset Workspace.
Scheduled job for calculation of asset KPIs
- The Calculate asset performance KPIs scheduled weekly job runs every Saturday to calculate the KPIs for the assets that belong to the model categories opted in for performance tracking. These KPIs are then
reflected in the Asset availability and related KPIs report, which displays the most recent KPI values.Note:To track historical KPIs for existing assets in the opted-in model categories, run the Calculate availability for historical data job. This job considers the following tasks associated with an asset to calculate the outages and KPIs:
- RMA task
- Repair task
- Troubleshoot task
- Evaluate task
- Recall task
- The Asset availability data collection scheduled weekly job runs every Sunday to calculate the average values of the KPIs that includes Average availability, Average MTTR, and Average MTBF. The job then generates the reports in the Asset performance tab of the Asset analytics view.