The Event logs in Usability monitoring show a Spot's recorded status changes. You can use them to find out, for example, when a device was marked as inactive or active again. This status history is separate from a task completion report. However, the logs do not include every status change.
This guide covers viewing history and exporting to Excel in the browser. Event logs data is limited to Spots you have permission to access. Statistics data is limited by folder permissions. Exporting does not extend these permissions.
Check recorded status changes
- From the browser's main menu, open Assets, devices, tools → Usability monitoring.
- Select the Event logs tab.
- Find the Spot using the search field below its column heading. Limit the event dates using the date range filter below the Timestamp column. You can also filter by statuses, user, folder and reason for the change. Search by device cards field value above the table searches Spots by the values in their data fields.
- Check the Timestamp, Status from, Status to, User and Reason for status change, where available.
- Open Full history events from the Spot's row when you need its earlier recorded events. The history opens with the newest event first, and you can filter it using the window's column filters.
The Event logs overview shows each Spot's most recent recorded event. The date range filter filters these most recent events: it does not find each Spot's most recent change within the selected period. If the latest event falls outside the filter range, the Spot may be omitted from the list even if it has older events within that period. Remove the filter, find the Spot and open its Full history events.
In the history, Status from describes the status before the event and Status to the status after it. The status after an earlier history event serves as the status before the next event. An unrecorded intermediate status may therefore be absent even from the Status from value on a later row.
Distinguish the current status from the status history
The browser status labels are Active, Inactive, Faulty and Disabled. On Android and iOS, Active is displayed as In Use and Faulty as At Fault. The browser's Inactive status is displayed as Not in use on Android and iOS; it represents the same status on all three platforms.
A normal status change first saves the Spot's current status. A history row is created separately in the background, so the current status may appear before the log row. The event timestamp records when the status was saved, rather than when background processing finished. Normal status changes on mobile also use this shared processing; the time of a mobile update is determined on the server.
- Saving the same status again does not add a history event.
- Inactive → Faulty and Faulty → Inactive do not add a history event, even though the current status changes. On mobile, the corresponding changes are Not in use ↔ At Fault.
- The setting linking task and Spot statuses is not a prerequisite for recording history. It controls the effects on tasks.
Example: A Spot is changed from Active to Inactive and then to Faulty. The first change creates a history row; the second does not. The current status is Faulty, but Status to on the latest history row remains Inactive even after background processing has finished.
To check the current status, open the Spot's name link in the overview and look at the Status field on the form's Basic info tab. The Status text at the top of Full history events is also based on the history row's status when opened, so it alone does not confirm the current status. After saving, check the current status and the logs by reopening each separately. A missing log row alone does not mean that saving the status failed.
Full history events means the entire recorded history. Neither this view nor the Excel export can recover events that were not recorded. An empty history also does not prove that the device's status has never changed. Changing statuses and disabling Spots are covered in the separate Spot status and removal guide.
If you are investigating the utilization percentage, compare the history with the same period as on the Statistics tab. Statistics are calculated utilization data, rather than a list of status changes or a reading from the device's physical operating hours meter. Calculation methods, schedules and limitations of the results are explained in the guide to interpreting Usability monitoring.
Prepare the Excel export
- In Usability monitoring, select the Statistics or Event logs tab.
- In Statistics, select the period in the Statistics for the selected timerange field above the table. In Event logs, use the date range filter in the Timestamp column. Apply any other searches and filters you need.
- Check the data and the columns you need. If you are exporting visible columns, set the column visibility before opening the export window.
- Select Export view to Excel above the table. In the Export to Excel window that opens, choose from the following export methods.
Export the rows loaded into the table
Select Export loaded rows when you only need the data already loaded into the table. When pagination is used, the file may not include all rows matching the search.
This export uses a fixed set of export columns specific to the view. The All columns and Visible columns only options for the full export do not control the export of loaded rows.
Export all rows matching the filters
- Select All columns or Visible columns only. The default is All columns.
- To apply the column heading filters, select Export only filtered rows. This option appears when column filters are active and is off by default.
- Start the export by selecting Export all statistics or Export all event logs.
- Wait for completion. The file is generated in the background, and the download starts automatically once it is ready.
The full export is not limited to rows already loaded into the table. The selected Statistics period and device card field value search, as well as the Event logs device card field value search, are retained in the export. Column heading filters are applied only if you select Export only filtered rows. This also applies to the Event logs date range filter: without this option, the export may include events outside the period filtered on screen.
Export all event logs exports the overview data, usually one latest event per Spot. The button does not collect every Spot's earlier status changes. The Full history events window does not have its own Excel export button.
What does the file contain?
The Event logs export columns are Spot, Timestamp, Status from, Status to, User and Folder. The reason for the change is not included in Excel, even if it appears in the table. In the full export, Visible columns only selects the visible columns from this list. Background export timestamps are displayed in the service's time zone. Spot and folder names are retrieved from the data available at the time of export; they are not a history of the names at the time of each event.
The Statistics export columns are Spot, Folder, Usage schedule, Date range, Hours in use, Hours not in use, Desired in use, Status, Usage-% and Uptime %. In the full export, the visible columns option limits this list. Date range shows the first and last day of the included daily data, so it may be shorter than the range you requested. The Usage schedule name identifies the schedule that currently applies; it alone does not indicate which schedule was used to calculate older daily data.
In Statistics, Status refers to whether the target has been met, rather than the Spot's current status. There is a difference between export methods here: in the table, On target means a utilization rate of exactly 100 percent, but in the full background export, results above 100 percent are also marked On target. In the table, the same result above 100 percent is Out of target. Always check the percentage alongside the label.
The Statistics background export formats hours and percentages as text values with two decimal places; percentage text also includes the percent sign. Convert the values to numbers in Excel before making your own calculations. If Uptime % has not been calculated, its cell is empty in the background export; in the loaded rows export, it contains a dash.
Verify the export result
Open the downloaded file and check the Spot names, row count, columns and date range. Compare a few rows with the source view using the same filters. In Event logs, make particularly sure whether you need the latest events or the entire recorded history. Check the reason for the change in the browser, as it is not exported to the file.
If the export fails or takes too long, the view displays a notification. Starting the export alone does not mean the file is ready. Try again after the notification and check that the file actually downloaded.
Exporting does not change the Spot's current status, status change history or utilization data. Editing history and resetting utilization are separate actions.