strComputer = “.”\nSet objWMIService = GetObject(“winmgmts:” _\n & “{impersonationLevel=impersonate}!\\\\” & strComputer & “\\root\\cimv2”)\nSet colOperatingSystems = objWMIService.ExecQuery _\n (“Select * from Win32_OperatingSystem”)\nFor Each objOperatingSystem in colOperatingSystems\n Wscript.Echo objOperatingSystem.ServicePackMajorVersion _\n & “.” & objOperatingSystem.ServicePackMinorVersion\nNext\n<\/PRE>\nNow you might be thinking, \u201cOh, the latest<\/I> service pack. But I need to know about all<\/I> the service packs that have been installed on a computer.\u201d If that\u2019s the case, relax; when you install, say, Service Pack 3.0, you automatically get everything that was included in Service Packs 1.0 and 2.0. Because of that, it doesn\u2019t really matter whether Service Pack 1.0 was installed; by installing Service Pack 3.0, you got all the functionality of Service Pack 1.0. Which is a somewhat convoluted way of saying that all you really care about is the latest service pack that was installed on a computer. And the preceding script will do just that.<\/P>\n
But what about those hot fixes we mentioned; how can you audit a computer and see which hot fixes have been installed? Try this script:<\/P>
strComputer = “.”\nSet objWMIService = GetObject(“winmgmts:” _\n & “{impersonationLevel=impersonate}!\\\\” & strComputer & “\\root\\cimv2”)\nSet colQuickFixes = objWMIService.ExecQuery _\n (“Select * from Win32_QuickFixEngineering”)\nFor Each objQuickFix in colQuickFixes\n Wscript.Echo “Computer: ” & objQuickFix.CSName\n Wscript.Echo “Description: ” & objQuickFix.Description\n Wscript.Echo “Hot Fix ID: ” & objQuickFix.HotFixID\n Wscript.Echo “Installation Date: ” & objQuickFix.InstallDate\n Wscript.Echo “Installed By: ” & objQuickFix.InstalledBy\nNext\n<\/PRE>\nTwo things to keep in mind here. First, hot fixes haven\u2019t always been released in standard fashion. That doesn\u2019t mean they don\u2019t work, it just means that some hot fixes might not populate all the above fields; for example, many hot fixes won\u2019t return a value for the InstallDate property. Second, hot fix information is recorded in several places on your computer and, because there hasn\u2019t always been a standard way of doing this, WMI checks all of these locations and retrieves hot fix information. That\u2019s good, except that once in awhile a hot fix will actually record information in multiple locations. Again, that\u2019s not really a problem; it just means that when you get your information back from WMI you might see or 2 or 3 instances of hot fix QFE 1111111. That\u2019s because QFE 1111111 recorded information about itself in several different spots.<\/P>\n
Hey, that\u2019s right: we did<\/I> mention Windows Update, didn\u2019t we? Well, if you\u2019ve installed the latest version of Windows Update, you might very well have a new COM object that enables you to retrieve update information. For example:<\/P>Set objSession = CreateObject(“Microsoft.Update.Session”)\nSet objSearcher = objSession.CreateUpdateSearcher\nintHistoryCount = objSearcher.GetTotalHistoryCount\n‘Wscript.Echo intHistoryCount<\/p>\nSet colHistory = objSearcher.QueryHistory(1, intHistoryCount)<\/p>\n
For Each objEntry in colHistory\n Wscript.Echo “Operation: ” & objEntry.Operation\n Wscript.Echo “Result code: ” & objEntry.ResultCode\n Wscript.Echo “Date: ” & objEntry.Date\n Wscript.Echo “Title: ” & objEntry.Title\n Wscript.Echo “Description: ” & objEntry.Description\n Wscript.Echo “Client application ID: ” & objEntry.ClientApplicationID\n Wscript.Echo “Server selection: ” & objEntry.ServerSelection\n Wscript.Echo “Service ID: ” & objEntry.ServiceID\n i = 1\n For Each strStep in objEntry.UninstallationSteps\n Wscript.Echo i & ” — ” & strStep\n i = i + 1\n Next\n Wscript.Echo “Uninstallation notes: ” & objEntry.UninstallationNotes\n Wscript.Echo “Support URL: ” & objEntry.SupportURL\n Wscript.Echo\nNext\n<\/PRE>\n
To be honest, we only know for sure that the Microsoft.Update.Session object gets installed on Windows XP (and is automatically installed when you install XP Service Pack 2). If you\u2019re running Windows 2000, you might want to visit Windows Update, install the latest version, then run the preceding script and see if it works.<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! How can I tell which service packs have been installed on my computers?— FR Hey, FR. That\u2019s a very good question; as you know better than we do, in this day and age it\u2019s really important to make sure all your computers have the latest service pack, the latest hot fixes, and […]<\/p>\n","protected":false},"author":596,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-85949","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! How can I tell which service packs have been installed on my computers?— FR Hey, FR. That\u2019s a very good question; as you know better than we do, in this day and age it\u2019s really important to make sure all your computers have the latest service pack, the latest hot fixes, and […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/85949","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\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=85949"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/85949\/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=85949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=85949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=85949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/q-for-powertip.jpg\" "\\"Hey,"){kind=small}
\n![Spacer](\"https:\/\/devblogs.microsoft.com\/scripting\/wp-content\/uploads\/sites\/29\/2019\/05\/spacer.gif\"){kind=small}
![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/a-for-powertip.jpg\" "\\"Hey,"){kind=small}
![\"Script](\"http:\/\/img.microsoft.com\/library\/media\/1033\/technet\/images\/scriptcenter\/ad.jpg\" "\\"Script")
<\/A> \n