Equipment Status Log History

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

image-20241112-215257.png

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

image-20241112-215318.png

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

image-20241112-215401.pngimage-20241112-215514.png

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.