title: Query WSUS Database For Required Updates Per Server
body: <p>I searched the internet far and wide looking for a way to query the WSUS database to view the number of updates that need to be installed on a server. I found a partial answer on the following blog, but this answer will assume if the update is pending approval it is still required by a server (WSUS assumes this in their UI as well).</p>
  
  <p><a href="http://theboywonder.co.uk/2010/11/04/sql-query-for-wsus-3-needed-updates/" rel="nofollow">http://theboywonder.co.uk/2010/11/04/sql-query-for-wsus-3-needed-updates/</a></p>