That timestamp should be the last time we saw the machine, it will be stored as first_timestamp, last_timestamp on the machine table. I think the best value to put here is the first not null element of [end_timestamp,start_timestamp,submit_timestamp]