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?
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.