By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Local_Datetime | Machine | State | Duration | State_Text | State_Date | State_Time | Prev_State | Prev_State_Text | Prev_State_Datestamp | Next_State | Next_State_Text | Next_State_Datestamp |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2023-06-01 00:00:00.000 | PC1 | 0 | 300 | Idle | 2023-06-01 | 00:00:00.0000000 | null | null | null | 1 | Active | 2023-06-01 00:05:00.000 |
2023-06-01 00:05:00.000 | PC1 | 1 | 600 | Active | 2023-06-01 | 00:05:00.0000000 | 0 | Idle | 2023-06-01 00:00:00.000 | 0 | Idle | 2023-06-01 00:15:00.000 |
2023-06-01 00:15:00.000 | PC1 | 0 | 373500 | Idle | 2023-06-01 | 00:15:00.0000000 | 1 | Active | 2023-06-01 00:05:00.000 | 1 | Active | 2023-06-05 08:00:00.000 |
2023-06-05 08:00:00.000 | PC1 | 1 | 600 | Active | 2023-06-05 | 08:00:00.0000000 | 0 | Idle | 2023-06-01 00:15:00.000 | 0 | Idle | 2023-06-05 08:10:00.000 |
Local_Datetime | Machine | State | Duration | State_Text | State_Date | State_Time | Prev_State | Prev_State_Text | Prev_State_Datestamp | Next_State | Next_State_Text | Next_State_Datestamp |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2023-06-01 00:00:00.000 | PC1 | 0 | 300 | Idle | 2023-06-01 | 00:00:00.0000000 | null | null | null | 1 | Active | 2023-06-01 00:05:00.000 |
2023-06-01 00:05:00.000 | PC1 | 1 | 600 | Active | 2023-06-01 | 00:05:00.0000000 | 0 | Idle | 2023-06-01 00:00:00.000 | 0 | Idle | 2023-06-01 00:15:00.000 |
2023-06-01 00:15:00.000 | PC1 | 0 | 85500 | Idle | 2023-06-01 | 00:15:00.0000000 | 1 | Active | 2023-06-01 00:05:00.000 | 0 | Idle | 2023-06-02 00:00:00.000 |
2023-06-02 00:00:00.000 | PC1 | 0 | 86400 | Idle | 2023-06-02 | 00:00:00.0000000 | 0 | Idle | 2023-06-01 00:15:00.000 | 0 | Idle | 2023-06-03 00:00:00.000 |
2023-06-03 00:00:00.000 | PC1 | 0 | 86400 | Idle | 2023-06-03 | 00:00:00.0000000 | 0 | Idle | 2023-06-02 00:00:00.000 | 0 | Idle | 2023-06-04 00:00:00.000 |
2023-06-04 00:00:00.000 | PC1 | 0 | 86400 | Idle | 2023-06-04 | 00:00:00.0000000 | 0 | Idle | 2023-06-03 00:00:00.000 | 0 | Idle | 2023-06-05 00:00:00.000 |
2023-06-05 00:00:00.000 | PC1 | 0 | 28800 | Idle | 2023-06-05 | 00:00:00.0000000 | 0 | Idle | 2023-06-04 00:00:00.000 | 1 | Active | 2023-06-05 08:00:00.000 |
2023-06-05 08:00:00.000 | PC1 | 1 | 600 | Active | 2023-06-05 | 08:00:00.0000000 | 0 | Idle | 2023-06-01 00:15:00.000 | 0 | Idle | 2023-06-05 08:10:00.000 |