Eng4586: Fix @SnapshotStatus

Turn @SnapshotStatus into a non-blocking sysproc which gathers all the node info from a single call.