1
select `cmp`.`ClientID` AS `ClientID`,`cmp`.`ComputerID` AS `ComputerID`,`cmp`.`Name` AS `NAME`,`sched`.`DefScheduleID` AS `DefScheduleID`,`sched`.`Schedule` AS `BackupSchedule`,`sched`.`FirstRun` AS `BackupScheduleFirstRun`,`sched`.`LastRun` AS `BackupScheduleLastRun`,(`sched`.`IsOldSchedule` = 0) AS `BackupScheduleActive`,`lbt`.`JobTypeName` AS `BackupJobType`,`lbs`.`SubTypeName` AS `BackupJobSubType`,`job`.`StartTime` AS `BackupJobStartTime`,`job`.`EndTime` AS `BackupJobEndTime`,`stat`.`StatusName` AS `BackupJobStatus`,if((`stat`.`StatusName` = 'Completed'),NULL,(select time_to_sec(timediff(`labtech`.`h_backupjobs`.`StartTime`,`job`.`StartTime`)) from `labtech`.`h_backupjobs` where ((`labtech`.`h_backupjobs`.`JobStatus` = 5) and (`labtech`.`h_backupjobs`.`StartTime` >= `job`.`StartTime`) and (`labtech`.`h_backupjobs`.`DefinitionGUID` = `job`.`DefinitionGUID`) and (`labtech`.`h_backupjobs`.`JobTypeID` = `job`.`JobTypeID`) and (`labtech`.`h_backupjobs`.`JobSubTypeID` = `job`.`JobSubTypeID`)) limit 1)) AS `JobNextSuccessInterval` from (((((`labtech`.`h_backupjobs` `job` join `labtech`.`backupdefinitionschedules` `sched` on(((`job`.`DefinitionGUID` = `sched`.`DefinitionGUID`) and (`job`.`JobTypeID` = `sched`.`JobTypeID`) and ((`sched`.`JobSubTypeID` = 3) or (`job`.`JobSubTypeID` = `sched`.`JobSubTypeID`))))) join `labtech`.`computers` `cmp` on((`job`.`ComputerID` = `cmp`.`ComputerID`))) left join `labtech`.`l_backupjobtype` `lbt` on((`job`.`JobTypeID` = `lbt`.`JobTypeId`))) left join `labtech`.`l_backupjobsubtype` `lbs` on((`job`.`JobSubTypeID` = `lbs`.`SubTypeId`))) left join `labtech`.`l_backupjobstatus` `stat` on((`job`.`JobStatus` = `stat`.`StatusId`))) where ((`job`.`StartTime` >= `sched`.`FirstRun`) and (`job`.`StartTime` <= `sched`.`LastRun`))