This might help you...

USE [ReportServer]

SELECT c.PATH, s.Description, s.LastStatus, s.LastRunTime

FROM Subscriptions s INNER JOIN CATALOG c ON s.Report_Oid = c.ItemId

WHERE LastRunTime > DATEADD(hh,-12,GETDATE())

ORDER BY s.LastRunTime ASC