Is there a query I can use to show results of Gateway jobs and which ones ran and failed.

I have worked on this for a while with guidance from Support. I'm trying to get a list of failed Jobs from Gateway parent jobs
With the code below I get the lower results pasted results. it retrieves both a listing of the P6 schedules that were retrieved, and gives me a listing of Unifier Projects that failed, When it failed it does not tell me the name of the P6 Project.

If I take out the or fsimsg.msg_name = 'Unifier Request : Service- Project'

Then I get all the jobs that had data Pulled from P6.

If I take out