1
select `ncp`.`ClientID` AS `ClientID`,`ncp`.`HotfixID` AS `HotfixID`,`ncp`.`KBID` AS `PatchKB`,`ncp`.`Title` AS `PatchTitle`,replace(`ncp`.`OS`,'dows','') AS `PatchOS`,`ncp`.`CategoryName` AS `PatchCategory`,`ncp`.`Severity` AS `PatchSeverity`,`ncp`.`CvssScore` AS `PatchCVSSScore`,`ncp`.`ReleaseDate` AS `PatchDateReleased`,((`ncp`.`TotalInstalled` + `ncp`.`TotalFailed`) + `ncp`.`TotalNotAttempted`) AS `PatchesApproved`,`ncp`.`TotalInstalled` AS `PatchesInstalled`,`ncp`.`TotalFailed` AS `PatchesFailed`,`ncp`.`TotalNotAttempted` AS `PatchesNotAttemped` from `labtech`.`noncompliantpatches` `ncp`