{"id":69103,"date":"2005-08-24T16:57:00","date_gmt":"2005-08-24T16:57:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2005\/08\/24\/how-can-i-determine-when-the-last-patch-from-windows-update-was-applied\/"},"modified":"2005-08-24T16:57:00","modified_gmt":"2005-08-24T16:57:00","slug":"how-can-i-determine-when-the-last-patch-from-windows-update-was-applied","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/how-can-i-determine-when-the-last-patch-from-windows-update-was-applied\/","title":{"rendered":"How Can I Determine When the Last Patch From Windows Update was Applied?"},"content":{"rendered":"

\"Hey, \n

Hey, Scripting Guy! How can I determine when the last patch from Windows Update was applied?

— JP<\/P>\"Spacer\"\"Hey,\"Script<\/A> \n

Hey, JP. You know, you picked a good time to ask this question; that\u2019s because we just published a Tales from the Script<\/B><\/A> column that introduces scripters to the Windows Update object model, and provides a number of sample scripts for managing Automatic Updates. And while the article doesn\u2019t have a script that returns information for just the last update applied to a computer, well, it was easy enough to come up with one:<\/P>

Set objSession = CreateObject(“Microsoft.Update.Session”)\nSet objSearcher = objSession.CreateUpdateSearcher<\/p>\n
Set colHistory = objSearcher.QueryHistory(0, 1)<\/p>\n
For Each objEntry in colHistory\n    Wscript.Echo “Title: ” & objEntry.Title\n    Wscript.Echo “Update application date: ” & objEntry.Date\nNext\n<\/PRE>\n
What\u2019s going on in this little script? Funny you should ask: we were just about to explain that. We begin by creating an instance of the Microsoft.Update.Session<\/B> object. Once we have that object in hand we can call the CreateUpdateSearcher <\/B>method. This gives us an instance of the Searcher object, an object that enables us to search through all the updates that have been applied to a computer. Which is exactly the thing we want to do.<\/P>\n
Next we use the QueryHistory<\/B> method to retrieve the desired updates:<\/P>
Set colHistory = objSearcher.QueryHistory(0, 1)\n<\/PRE>\n
As you can see, in this script we pass QueryHistory two parameters: 0 and 1. The 0 tells the script to begin its search with record 0 in the update history; the 1 tells the script to stop its search after record 1. (That is, before it gets to record 2.) Why do we do that? Well, updates are stored in reverse chronological order, with the most recent update being record 0 and the very first update ever applied being the last record in the collection. Because we want information about only the most recent update, we can make the script run a tad bit faster by limiting the returned data to just that one record. <\/P>\n\n<\/THEAD>\n\n\n
\n
Note<\/B>. We should point out that it\u2019s very easy to retrieve the complete update history for a computer; in fact, the Tales from the Script<\/B><\/A> column includes a script that does just that.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n
<\/DIV>\n
After calling the QueryHistory method we\u2019ll get back a collection (named colHistory) consisting of a single item, an item which just happens to represent the last update that was applied to the computer. All that\u2019s left now is to walk through that collection (and, yes, technically it\u2019s still a collection even though it contains just one item) and echo the title of the update and the date the update was applied:<\/P>
For Each objEntry in colHistory\n    Wscript.Echo “Title: ” & objEntry.Title\n    Wscript.Echo “Update application date: ” & objEntry.Date\nNext\n<\/PRE>\n
In other words, tell us the last time Windows Update did something to this particular computer.<\/P>\n
Incidentally, the Windows Update object model is a mixed-bag: some of the objects can be created on – and thus used against – remote computers while others can\u2019t. Fortunately, this happens to be a script that will<\/I> run against a remote machine. To do that you simply need to add the remote computer name as the second parameter to CreateObject. For example, this line of code causes the script to run against the remote computer atl-dc-01:<\/P>
Set objSession = CreateObject(“Microsoft.Update.Session”, “atl-dc-01”)\n<\/PRE>\n
And the complete script for retrieving the last update from atl-dc-01 would thus look like this:<\/P>
Set objSession = CreateObject(“Microsoft.Update.Session”, “atl-dc-01”)\nSet objSearcher = objSession.CreateUpdateSearcher<\/p>\n
Set colHistory = objSearcher.QueryHistory(1, 1)<\/p>\n
For Each objEntry in colHistory\n    Wscript.Echo “Title: ” & objEntry.Title\n    Wscript.Echo “Update application date: ” & objEntry.Date\nNext\n<\/PRE>\n
And people think that patch management is hard. Not anymore! <\/P><\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! How can I determine when the last patch from Windows Update was applied?— JP Hey, JP. You know, you picked a good time to ask this question; that\u2019s because we just published a Tales from the Script column that introduces scripters to the Windows Update object model, and provides a number of […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[36,3,5,380],"class_list":["post-69103","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-client-side-management","tag-scripting-guy","tag-vbscript","tag-windows-update"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! How can I determine when the last patch from Windows Update was applied?— JP Hey, JP. You know, you picked a good time to ask this question; that\u2019s because we just published a Tales from the Script column that introduces scripters to the Windows Update object model, and provides a number of […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/69103","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=69103"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/69103\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=69103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=69103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=69103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}