Patch Management Solution

 View Only

creating automation policy with Raw SQL Query

  • 1.  creating automation policy with Raw SQL Query

    Posted Jul 31, 2012 05:19 PM

    I'm looking to create a automation policy that will email a user every day with the following information - machines with scheduled maintenance windows for the day and if there are any patches that are staged to be installed for each machine with a maintenance window.  There doesn't appear to be any canned reports already setup with this information and I'm looking at the tables in the db and can't identify the exact items to use.  has anybody setup a raw SQL query to gather this type of information already?