Possible addition to Patch Remedy Print Report

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
dbitters
Posts: 55
Joined: Tue May 18, 2021 8:11 pm
2

Possible addition to Patch Remedy Print Report

Post by dbitters »

The Patch Remedy Print report at the customer level has 5 columns, including the percentage level, which is very helpful.
What are your thoughts on including a column for "Last PR Update".
I think this would be a nice addition because if a group of systems is broken, in sleep mode/hibernation mode, or turned off during the patch schedule, it can be hard to troubleshoot and rule out something as simple as the machine not being left on during the scheduled time frame.
It would be great to have that column so someone could sort it to quickly see which systems have not applied updates within, say, the last 30 days.
I'm sure others would find adding that column to be very helpful. I know that would alleviate a lot of manual work and be extremely helpful to our team.

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

Re: Possible addition to Patch Remedy Print Report

Post by Cubert »

So what we want is to query the agent for its last official update run? Add that as a column to list.


I could run something like...

Code: Select all

 gwmi win32_quickfixengineering |sort installedon -desc 
Which would return something like...
Source Description HotFixID InstalledBy InstalledOn
------ ----------- -------- ----------- -----------
CUBESTATION Update KB5033920 NT AUTHORITY\SYSTEM 1/11/2024 12:00:00 AM
CUBESTATION Security Update KB5034123 NT AUTHORITY\SYSTEM 1/11/2024 12:00:00 AM
CUBESTATION Update KB5032393 NT AUTHORITY\SYSTEM 11/15/2023 12:00:00 AM
CUBESTATION Update KB5029517 NT AUTHORITY\SYSTEM 9/17/2023 12:00:00 AM
Actually mor like this...

Code: Select all

# Get the Current date
$currentDate = Get-Date

# Get the date 30 adys ago
$thirtyDaysAgo = $currentDate.AddDays(-30)

# Get all the Updates installed since 30 days ago
Get-HotFix | Where-Object {$_.InstalledOn -gt $thirtyDaysAgo}

Which produces the same thing but limits the return to just last 30 days.
Source Description HotFixID InstalledBy InstalledOn
------ ----------- -------- ----------- -----------
CUBESTATION Update KB5033920 NT AUTHORITY\SYSTEM 1/11/2024 12:00:00 AM
CUBESTATION Security Update KB5034123 NT AUTHORITY\SYSTEM 1/11/2024 12:00:00 AM

Since there are any number of updates that could happen, maybe a list of these updates should be shown in agent status area.


As for capturing the very last date and displaying with the agent data is possible. Fitment may be a bit of a squeeze, may need to rearrange some items to get it all to fit.

Post Reply

Return to “Patch Remedy 5”