Agent(s) Up To Date - percentage calculation

Patch Remedy 5 is the next generation of the Plugins4Automate Patch Remedy family of products.
This forum is used to support Patch Remedy 5 only, if your using a previous version of Patch Remedy please see the forum for that version below.
Inside you will find the documentation project for the plugin were you can get insights on how to operate and use Patch Remedy 5.
Post Reply
sewkaz
Posts: 5
Joined: Tue Feb 22, 2022 7:03 pm
2

Agent(s) Up To Date - percentage calculation

Post by sewkaz »

How is the calculation done? Looks like something is a bit off or I do not understand it. How can it be 99.37% for a client that have agents with so low coverage?
Attachments
issue with calculation.png
issue with calculation.png (190.34 KiB) Viewed 789 times

User avatar
Cubert
Posts: 2430
Joined: Tue Dec 29, 2015 7:57 pm
8
Contact:

Re: Agent(s) Up To Date - percentage calculation

Post by Cubert »

Because we assume that an agent with 0 zero patching is not scanning. Thus it must be disabled in plugin and as such we do not count excluded agents.


If you have 50 agents and exclude 49 of them, what ever the 1 agents patch percentage is would be your clients percentage. We exclude agents we are not in management of from our stats. We also directly scan agents for patch statuses. We do not rely on the collections preformed by Automate.

Th failed counter is not used in percentage calculations as they may be superseded by other patches and thus they were skipped or failed to install. We see this a lot with the Defender definition updates which tend to drive those numbers. The available hotfix number represents all patches not installed that are also not hidden or excluded as of the date of scan.


We also round the percentages at the agent percentage view, so 100% maybe 99.5% in real terms.



We use this SQL formula to calculate percentages in this view

Code: Select all

Select round((Installed / (Available + installed)) * 100)) as Percent

User avatar
Cubert
Posts: 2430
Joined: Tue Dec 29, 2015 7:57 pm
8
Contact:

Re: Agent(s) Up To Date - percentage calculation

Post by Cubert »

Now to capture total client percentages this logic is used.

Code: Select all

round((All Installed patch counts for client / (All Installed Patch count for client + All available patch counts for client) * 100),2)
(1249 / (1249+10) *100) = 99.21%


Client has 8 agents for a total patch installed of 1249 patches across the 8 agents, There are 10 available patches total across all agents under client. the total patch score for that client would be 99.21%

sewkaz
Posts: 5
Joined: Tue Feb 22, 2022 7:03 pm
2

Re: Agent(s) Up To Date - percentage calculation

Post by sewkaz »

Ok but this can show false results e.g. I have a Windows 2008 R2 that have installed 1.5k updates and 2 are missing and a fresh WS2019 release that have only 10 patches and all of them are missing. Based on that calculation, it will show in the calculation that I'm all good, because the total of 12 not installed patches for that client will not be visible in the % summary. This will give me a false positive feeling because not digging in I will not know that one of the machine have all the patches missing.
I know this will show up in the table under the client but for a fast overlook that calculation can lead to a false feel of being secured in that field.
Not better to count it based per agent and calculate the average that way?

User avatar
Cubert
Posts: 2430
Joined: Tue Dec 29, 2015 7:57 pm
8
Contact:

Re: Agent(s) Up To Date - percentage calculation

Post by Cubert »

We provide percentages at all levels. When you select a client and the total client percentage is displayed, Also is displayed how that number is broken down by looking into the agents percentages in the list view of the clients view.

So although you get an over all percentage the same view shows who has what percentage.



image1.png
image1.png (87.98 KiB) Viewed 774 times

A couple of other things to now note. You might notice that the dots are different colors (see blue arrows) In the client dropdown tree view, it tells you agent is offline. The more orangish color dot in the agent percentage view shows it is excluded from Patch Remedy and thus is not part of the percentages displayed. It also shows zeros across the board.

The other bule arrow points out a new counter in 1.0.5.6 that will display the actual count of available patches for client and or agent when selected.

1.0.5.6 has a minor bug fix and added counters. It was released last night so you should check your hosts plugin logs to see if the upgrade was seen by your automated updater.

Logs look like this
LTAgent v220.57 - 2/23/2022 11:02:49 PM - Plugin PatchRemedy, Version=1.0.5.6, Culture=neutral, PublicKeyToken=null: Current Version is (1.0.5.6) and the available version is (1.0.5.6):::
LTAgent v220.57 - 2/23/2022 11:02:49 PM - Plugin PatchRemedy, Version=1.0.5.6, Culture=neutral, PublicKeyToken=null: Plugin version is current:::

Post Reply

Return to “Patch Remedy 5”