/build/static/layout/Breadcrumb_cap_w.png

How are you notifying end-users patches are complete for their remote machine?

We have a large number of work from home users and every month it is a struggle to complete patches.

Using the K1000 we have the procedure set to push out the patches, but there isn't a "You're done for the month" notification.


How are you letting your users know they are complete? Is there a way to automate a notification or is the best way just to watch their machine and email them manually when it's finished?



Thanks for the help!


0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Posted by: Nico_K 1 month ago
Red Belt
1

I would go the other way around:
Patch as normal and having a monthly report for missing patches and if a system fails, notify them individually.


Comments:
  • That's essentially how we are currently doing it Sir. I was hoping someone had figured a way through this and could share their brilliance.

    Thanks for the response. - AFCUjstrick 1 month ago
    • understand, but I need to say: I don't like emails "all ok", emails with "there is a problem" I don't like either, but THESE emails are interesting enough to read and not only to delete. - Nico_K 1 month ago
Posted by: Hobbsy 4 weeks ago
Red Belt
1

Top Answer

So here is some SQL to get you started in the right direction. This query shows all Devices that do not have a patch missing and have run a schedule successfully within the last 30 days


SELECT 

PATCH_SCHEDULE_MACHINE_STATUS.MACHINE_ID,

PATCH_SCHEDULE_MACHINE_STATUS.NOTPATCHED,

PATCH_SCHEDULE_MACHINE_STATUS.LAST_RUN

FROM

PATCH_SCHEDULE_MACHINE_STATUS

WHERE

PATCH_SCHEDULE_MACHINE_STATUS.NOTPATCHED = 0 AND

(((TIMESTAMP(PATCH_SCHEDULE_MACHINE_STATUS.LAST_RUN) <= NOW() AND TIMESTAMP(PATCH_SCHEDULE_MACHINE_STATUS.LAST_RUN) > DATE_SUB(NOW(),INTERVAL 30 DAY))))


You could of course use this as a smart label, so any machines that have patched completely within the last 30 days are in the label. The next step would be to work out how to send an email to each machine user in the label.


Comments:
 
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