1
select `hf`.`ComputerID` AS `ComputerID`,`hf`.`HotFixID` AS `HotfixID`,`hfd`.`Manufacturer` AS `PatchManufacturer`,`hfd`.`Title` AS `PatchProduct`,`hf`.`OS` AS `PatchOS`,`hf`.`Installed` AS `PatchIsInstalled`,`hf`.`Success` AS `PatchIsCWAInstalled`,if((year(`hf`.`FinishedDate`) = 0),NULL,`hf`.`FinishedDate`) AS `PatchInstalledDate`,if((`hf`.`Version` = ''),'Stay Current','Specific') AS `PatchApproveAction`,ifnull(elt((`hf`.`Action` + 2),'Not Set','Update Only','Install/Update'),'Unknown') AS `PatchUpdateAction`,if((trim(`hf`.`InstalledVersion`) <> ''),`hf`.`InstalledVersion`,'0') AS `PatchVersionInstalled`,if((`hf`.`Version` = ''),`ver`.`LatestVersion`,`hf`.`Version`) AS `PatchVersionApproved`,`ver`.`LatestVersion` AS `PatchVersionLatest`,`f_VersionCompare`(if((`hf`.`Version` = ''),`ver`.`LatestVersion`,`hf`.`Version`),if((`hf`.`InstalledVersion` <> ''),`hf`.`InstalledVersion`,'0'),'.') AS `PatchVersionCompliant` from ((`labtech`.`hotfix` `hf` join `labtech`.`hotfixdata` `hfd` on((`hf`.`HotFixID` = `hfd`.`LTProductKey`))) left join `labtech`.`productversioncontrol` `ver` on((`hfd`.`LTProductKey` = `ver`.`LTProductKey`))) where ((`hfd`.`IsThirdParty` = 1) and (`hf`.`Approved` = 2) and ((`hf`.`Version` = `hfd`.`Version`) or ((`hf`.`Version` = '') and (`ver`.`LatestVersion` = `hfd`.`Version`))))