Machine remins in HARD_REBOOT status

Adding query for #1224518.

Change-Id: I8edbbc94d0c1255c49e88dcd9307e33652959d09
Merge "Machine remins in HARD_REBOOT status"