Equipment Status Log History
- Andrew Finch
Summary/Use Case
Report Summary
The Equipment Status Log History report provides a detailed log of equipment status changes within a specified facility, capturing each status update, including inventory periods, mounted status, and repair times. This report is especially useful for fleet managers to monitor equipment utilization, track inventory status, and assess maintenance needs over time.
Use Case
Track equipment utilization across different statuses (e.g., In Inventory, Mounted).
Analyze the duration of each status for operational and maintenance planning.
Identify equipment usage patterns for improved fleet allocation and scheduling.
Monitor facility-level status summaries to streamline asset management.
Location: Where to Find It
Reports > RTA Standard Reports Equipment > Equipment > Equipment Status Log History
Please provide a screenshot of the exact location within the software if available.
Data Filter Prompts
You will be prompted for filtering of the Data to specify and narrow down the data that will be pulled. See Data Filter List Below for Options
Parameter List
Parameter Name | Value | Value (Notes) |
|---|---|---|
Only show facility status summary? | False | Choosing ‘True’ will only show the hours summary table by status, otherwise, full status log data will be displayed. |
Data Filter List
Filter Name | Recommended Filter Condition(s) | Value (Options) | Value (Default) |
|---|---|---|---|
Facility | Equal To | 1 - 99999 | 1 |
Equipment Number | Is Between | blank to "zzzzzzzzzzzzzzzz" | blank to "zzzzzzzzzzzzzzzz" |
Status Start Date | Greater Than or Equal To | Any Date Range | 90 Days Previous |
Report Output and Data Elements
The Equipment Status Log History report output includes a comprehensive log of each equipment’s status, grouped by facility and sorted by equipment number and date. Key highlights include:
A detailed log of status changes for each piece of equipment, showing status start and end dates, and duration in days.
A summary table for each facility, summarizing the total time equipment spent in each status (e.g., In Inventory, Mounted, Repair, Scrapped), with grand totals provided for each status.
Report Output
Report Data Elements
Column Number | Column Title | Data Notes |
|---|---|---|
1 | Equipment | Identifier of the equipment item. |
2 | Vehicle | Associated vehicle number that equipment is mounted to. |
3 | Status Start Date | Date and time the status began. |
4 | Status End Date | Date and time the status ended. |
5 | Status | Current status of the equipment (e.g., Mounted). |
6 | Status Duration (In Days) | Calculated duration of the status in days. |