Is there a way to join ScheduledScriptInstance with mapReduceScriptDeployment ? All I'm trying to do is see if a certain MapReduce deployment is running, and if so, some status about the stage.

We're using search to accomplish this in a project. Have you investigated to see if a mapping table is exposed?