Kaseya Community

Send report based on missing patches

  • Hello,

    Is there a way to send a report with missing patches based on the number of missing patches.

    So I want to send a report to someone when a client is missing at least 5 patches.

    Does someone have some experience with it?

     

    Regards

  • Im doing some testing with the following solution:

    1. Created a SQL view for general patch data (mine includes missingApproved, missingManual, etc)

    2. Use a procedure durring our nightly maintenance to check this value for the machine, write this value to the procedure log (ex. IF missingApproved is Greater Than 4, write "Patch Alert: This machine is missing #missingApproved# patches"

    3. Configure a scheduled report to look for the "Patch Alert" procedure log entry And list the results.