Ultrafast X-ray Auger probing of photoexcited molecular dynamics