3 – Data
Overhead Crane

id | asset_id | assetName | asset_state_type_id | Current Status |
---|---|---|---|---|
25 | 3 | Overhead Crane | 1 | Off-shift |
ASSET STATUS DATA
id | assetID | assetName | State | thingName | Start time | End time | Duration (Secs) | Duration (Mins) | User |
---|---|---|---|---|---|---|---|---|---|
65,612 | 3 | Overhead Crane | Off-shift | 2020-03-31 16:44:36 | 2020-03-31 16:44:42 | 360.00 | 6.00 | ||
65,613 | 3 | Overhead Crane | Idle | 2020-03-31 16:44:42 | 2020-03-31 16:44:46 | 240.00 | 4.00 | ||
65,619 | 3 | Overhead Crane | Busy | 2020-03-31 16:44:46 | 2020-04-02 17:27:49 | 10,522,980.00 | 175,383.00 | ||
65,626 | 3 | Overhead Crane | Idle | 2020-04-02 17:27:49 | 2020-04-02 17:45:39 | 64,200.00 | 1,070.00 | ||
65,629 | 3 | Overhead Crane | Off-shift | 2020-04-02 17:45:39 | 2020-04-03 08:27:51 | 3,175,920.00 | 52,932.00 | ||
65,630 | 3 | Overhead Crane | Idle | 2020-04-03 08:27:51 | 2020-04-03 08:49:58 | 79,620.00 | 1,327.00 | ||
65,634 | 3 | Overhead Crane | Off-shift | 2020-04-03 08:49:58 | 2020-04-10 15:04:19 | 37,635,660.00 | 627,261.00 | ||
65,635 | 3 | Overhead Crane | Busy | 2020-04-10 15:04:19 | 2020-04-10 15:04:26 | 420.00 | 7.00 | ||
65,649 | 3 | Overhead Crane | Idle | 2020-04-10 15:04:26 | 2020-04-14 16:53:25 | 21,128,340.00 | 352,139.00 | ||
65,650 | 3 | Overhead Crane | Busy | 2020-04-14 16:53:25 | 2020-04-14 16:53:34 | 540.00 | 9.00 | ||
id | assetID | assetName | State | thingName | Start time | End time | Duration (Secs) | Duration (Mins) | User |