1
select distinct sql_no_cache `labtech`.`hotfix`.`HotFixID` AS `HotfixID`,`labtech`.`hotfix`.`ComputerID` AS `ComputerID`,`labtech`.`clients`.`Name` AS `Client`,`labtech`.`locations`.`Name` AS `Location`,`labtech`.`computers`.`Name` AS `computer`,`labtech`.`hotfix`.`OS` AS `OS`,`labtech`.`computers`.`MAC` AS `MAC`,`labtech`.`computers`.`RouterAddress` AS `IPAddress`,ifnull(`labtech`.`computerpatchingstats`.`OverallCompliance`,0) AS `DeviceCompliance`,if((`labtech`.`hotfix`.`Approved` = 0),'Not Set',if((`labtech`.`hotfix`.`Approved` = 1),'Ignore',if((`labtech`.`hotfix`.`Approved` = 2),'Approve',if((`labtech`.`hotfix`.`Approved` = 3),'Remove','Deny')))) AS `ApprovalPolicy`,if((`labtech`.`hotfix`.`Failed` = 0),if((`labtech`.`hotfix`.`Installed` = 0),if((`labtech`.`hotfix`.`Pushed` = 0),'Not Attempted','Pushed'),'Installed'),'Failed') AS `PatchState`,ifnull(`labtech`.`computerpatchingstats`.`vPro`,0) AS `vPro`,ifnull(`labtech`.`computerpatchingstats`.`WOL`,0) AS `WOL`,if((`labtech`.`computers`.`LastContact` < (now() + interval -(10) minute)),0,1) AS `Connected`,`labtech`.`computers`.`IdleTime` AS `IdleTime`,if(((`labtech`.`computers`.`IdleTime` > 300) and (`labtech`.`computers`.`LastContact` > (now() + interval -(10) minute))),1,0) AS `Idle`,ifnull(`labtech`.`computerpatchingstats`.`DaytimePatching`,0) AS `DaytimePatching`,ifnull(`labtech`.`computerpatchingstats`.`JobsRunning`,0) AS `PatchJobRunning`,ifnull(`labtech`.`computerpatchingstats`.`PendingReboot`,0) AS `PendingReboot`,ifnull(`labtech`.`computerpatchingstats`.`LastPatchJobFailed`,0) AS `LastPatchJobFailed`,ifnull(`labtech`.`computerpatchingstats`.`NoPatchInventory`,0) AS `NoPatchInventory`,ifnull(`labtech`.`computerpatchingstats`.`WSUSEnabled`,0) AS `WSUSEnabled`,ifnull(`labtech`.`computerpatchingstats`.`OutOfDateWUA`,0) AS `OutofDateWUA`,ifnull(`labtech`.`computerpatchingstats`.`MissingBaseline`,0) AS `MissingBaseline`,ifnull(`labtech`.`computerpatchingstats`.`Stage`,0) AS `Stage`,(select count(0) from `labtech`.`h_patching` where ((locate(`labtech`.`hotfix`.`HotFixID`,`labtech`.`h_patching`.`Patches`) > 0) and (`labtech`.`h_patching`.`ComputerID` = `labtech`.`hotfix`.`ComputerID`))) AS `PatchJobs`,ifnull((select `maintenancemode`.`TimeStart` from `labtech`.`maintenancemode` where (`maintenancemode`.`ComputerID` = `labtech`.`hotfix`.`ComputerID`)),now()) AS `MaintenanceBegin`,ifnull((select `maintenancemode`.`Durration` from `labtech`.`maintenancemode` where (`maintenancemode`.`ComputerID` = `labtech`.`hotfix`.`ComputerID`)),-(1)) AS `MaintenanceDuration`,ifnull((select `maintenancemode`.`Mode` from `labtech`.`maintenancemode` where (`maintenancemode`.`ComputerID` = `labtech`.`hotfix`.`ComputerID`)),-(1)) AS `MaintenanceMode` from ((((`labtech`.`hotfix` join `labtech`.`computers` on((`labtech`.`hotfix`.`ComputerID` = `labtech`.`computers`.`ComputerID`))) join `labtech`.`clients` on((`labtech`.`computers`.`ClientID` = `labtech`.`clients`.`ClientID`))) join `labtech`.`locations` on((`labtech`.`computers`.`LocationID` = `labtech`.`locations`.`LocationID`))) join `labtech`.`computerpatchingstats` on((`labtech`.`computers`.`ComputerID` = `labtech`.`computerpatchingstats`.`ComputerId`)))