WSUS Product Team Blog

WSUS Product Team thoughts, information, tips and tricks and beyond :-)

WSUS 3 Developer's Blog - API samples... (part 2) 3 more scripts coming

WSUS 3 Developer's Blog - API samples... (part 2) 3 more scripts coming

  • Comments 162
  • Likes

http://www.microsoft.com/technet/scriptcenter/scripts/sus/server/default.mspx?mfr=true

Sorry it's a bit of a slow process - but we're still trying to trickle out more API examples based on scenario requests from customers and ISVs.

3 more scripts will be up sometime today, including:

  • Importing your AD group structure as target groups.
  • Show list of computers needing reboots
  • A basic report on only updates that have been approved. You can do things like scheduling this report via "Scheduled Tasks," and archive the reports on a regular basis.  We've also gathered data over time, and used Excel to show trending graphs.  If you're interested in some tips/tricks on displaying reports within Excel, comment here and we'll share our experience.

 

Comments
  • Please go on blogging on reporting. Post about Excel would be appreciated.

    Thanks.

  • Please include samples on pulling out the inventory data, hw and sw.

    Thanks.

  • Hello,

    I would be interested too in some help about displaying data in Excel with graphs. My main objective is to be able to make a graph of the evolution of the up-to-date machines over the time.

    Thanks in advance.

  • Would it be possible to show how to add another Inventory Item to collect?  i.e. Win32_Bios Serialnumber?

  • I'm just a huge fan of WSUS. And, if you look macroeconomically at the patch management software market, you can tell that others are too. What do I mean? Only that once WSUS 2.0 came out, there seemed to be a bunch of patch management companies that

  • I am looking for a script that will run the "Computer Tabular Status" report from WSUS 3.0 - where it lists the total updates, the needed updates, the failed updates... etc, for each machine without going into much detail about each update. We're looking for a summary of the update statistics for each computer, in a list (pretty much exactly the way the "Computer Tabular Status" report would look.

    I am in a very big need of this script to use for automated reporting for our clients.

  • I am trying to run the sample scripts on my client machine against a remote WSUS server.  

    I started with script that lists computers that need a reboot (here: http://www.microsoft.com/technet/scriptcenter/scripts/sus/server/susvms08.mspx).  Then I changed the GetUpdateServer() call to GetUpdateServer("servername", $false).  

    This fails universally from PowerShell.  However, if I port the script to C# it works.  

    When it fails in PowerShell this is error message that I get.

    Exception calling "GetUpdateServer" with "2" argument(s): "The type initializer for 'Microsoft.UpdateServices.Internal.Constants' threw an exception."

    Do you guys have any suggestions on how to get the remote API working via PowerShell?

    Thanks, Eric

  • Hello! great idea of color of this siyte!

  • Currently, I found that the reports show that the clients are not compliance but to my org, it had had been fully patched except for those not approved updates. I need a report that shows only the computers that are fully patched with my approved updates. Please advise.

  • My name is Elena. To me of 20 years.

    I would like to get acquainted with you if you not against.

    I Look forward to hear you soon with impatience.   <a href="http://toplop.com/?idAff=59">Dating</a>">http://toplop.com/?idAff=59">Dating</a>[url=http://toplop.com/?idAff=59]Dating[/url]

  • My name is Elena. To me of 20 years.

    I would like to get acquainted with you if you not against.

    I Look forward to hear you soon with impatience.   <a href="http://toplop.com/?idAff=59">Adult">http://toplop.com/?idAff=59">Adult Dating</a>[url=http://toplop.com/?idAff=59]Adult Dating[/url]

  • My name is Elena. To me of 20 years.

    I would like to get acquainted with you if you not against.

    I Look forward to hear you soon with impatience.   <a href="http://toplop.com/?idAff=59">Adult">http://toplop.com/?idAff=59">Adult Dating</a>[url=http://toplop.com/?idAff=59]Adult Dating[/url]

  • Hi, I wrote some vbscript last spring that queried the wsus 2.0 tables using sqloledb provider.   I realize we should migrate to powershell probably, but how could I get my vbscript working again against the WSUS 3.0 Windows Internal Database?  I think it's really sql 2005 embedded edition but I can't figure out how to connect anymore and I need a quick-fix before re-writing in powershell.

    thanks,

    Bruce

  • Good day, was wondering if its possible to script the date of when an updated was installed? Would greatly appreciate it.

    Thanks

    Rich

  • If you want do delete your site from our spam bases - just email us with domain of your site:

    abuse-here@inbox.ru

    thank you!

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment