Scripting Question

K1000 - Tips on Creating Report Scripts

04/25/2017 1108 views
I am new to SQL, and have been tasked with compliance reporting for our patches.  I have tried to go through the archives here, but am unable to find the scripts that I need.  I am looking to create 2 separate scripts.  The first would show what CRITICAL patches were downloaded for the month.  The Second would show which computers received these patches and whether the install was successful or not.  I was wondering if anyone out there have already created scripts like these or could offer tips on how to write them?  Thank you for your help
2 Comments   [ + ] Show comments


  • So you don't want to see all the patches applied to machines, just the statuses of patches labeled "critical" that were downloaded in the past month? That would mean the report wouldn't show you critical patches that were applied where the patches are older than a month.
  • By "for the month" do you mean "only during the current month" or "since a month ago"? E.G. today is the 3rd of May so "current month" would only give you patches from the last three days, while "since a month ago" would concern patches from April 3rd to May 3rd.

Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:


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