Click or drag to resize
Alert table
Print this page

The Alert table allows you to retrieve InSight Alerts that have been triggered on a Fleet customer account.

This topic contains the following sections:


When you write templates that access this table, follow these requirements:

  1. Specify the Symbolic Name for the table version to use:

    TableID = Alert-1.0

  2. Specify an Intent that this table supports:

    • Retrieve

  3. Retrieve templates: This table requires the use of a fetcher. The following fetchers are available and are listed from most efficient to least:
    1. Id (Equals/In)
      Id(ExtId) = Equals(Id1)   # You can filter on literals or on variables from the [User] or [Calculated] sections.
      Id(ExtId) = In(["Id1","Id2","Id3"])
    2. TimeTriggered (Between/GreaterThan)

      You can improve the performance of the TimeTriggered fetcher by adding one or more of the following optional filter conditions: DriverId (Equals/In) , UnitId (Equals/In), TriggerValue (Equals/In), or ConditionId (Equals/In).

      TimeTriggered = Between(TimeStart,TimeEnd)  # Timestamp variables from User or Calculated section
                                                  # User either a GreaterThan or Between function
                                                  # like Between(TimeStart,TimeEnd)
      # Optional filters:
      DriverId(ExtId) = Equals("Id1")               # Equals or In   
      UnitId = Equals("MyCode1")                    # Equals or In  
      ConditionId(ExtId) = In("Id1", "Id2", "Id3")  # Equals or In
      TriggerValue(ExternalId) = Equals("Id1")      # Equals or In
Alert column descriptions

This list includes each column's name, which you use in expressions to retrieve data, and data type, which defines how the data is retrieved.

Column Data Type Description
Id Id (primary key) The ID of the alert.
ConditionId Id<Condition> The ID of the condition that generated this alert.
TimeTriggered Timestamp The time that this alert was triggered.
TimeOn Timestamp The time the alert came on. This is the time of the first report that indicated the alert condition.
TimeOff Timestamp The time the alert was turned off. This is the time of the first report that indicated the exception was no longer occurring.
DriverId Id<Driver> The ID of the driver that was assigned to the vehicle when the alert was triggered.
UnitId Id<Unit> The ID of the vehicle that triggered the alert.
MarkerId Id<Marker> The ID of the marker that was involved in the alert, if any.
JobId Id<Job> The ID of the job that was involved in the alert, if any.
Address Address The address at which the alert occurred.
Speed Speed The speed of the vehicle at the time the alert triggered.
SpeedLimit Speed The speed limit where the alert triggered.
TriggerName Text The name of the diagnostic parameter that triggered the alert.
TriggerValue Text The diagnostic parameter value that triggered the alert.

Additional columns:

Column Data Type Description
CustomerId Id (read-only, all Fleet tables) The ID of the customer/owner.
CustomerFullName Text (read-only, all Fleet tables) The human-readable full name of the customer/owner.