Scripting Question

Get the percent patched and not patched at the bottom of the column (custom row)

06/26/2020 339 views

Hello, in my custom report, I want to get the percent patched and not patched at the bottom of the column patched and not patched. Please help. I use KACE version 10. 


Here, the total of patched and unpatched count is 1372. So the patched percent will be ((67+516+68+534)/1372)*100. Similarly for the unpatched percent. 

These numbers are not fixed because this a monthly patching report and the numbers will change every month. Thank you. 

0 Comments   [ + ] Show comments


All Answers


I'm not aware of a way to change the HTML report. I recommend instead doing the following:

Export as csv/xlsx.

Use a custom Excel file to build a power query to import the exported data as a source, and process your data as a data table to formulate the result values you want.

Answered 07/01/2020 by: mtatro
Yellow Belt

This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ