![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/q-for-powertip.jpg\" "\\"Hey,")
<\/p>\n<\/p>\n
<\/p>\n
Hey Scripting Guy! I need to generate a list of hotfixes that are installed on my servers. I have 100 servers on the network for which I am responsible. Each of the server names is listed in a text file called servers.txt. I need a way to read the text file and then query each of the servers. Can you help me?<\/p>\n<\/p>\n
— GM<\/p>\n
\n
Hello GM, <\/p>\n Microsoft Scripting Guy Ed Wilson here. Today is a special day. For months and months and months we have had a weekly Script Center migration meeting. Today there is not a meeting. That means I have an extra hour to read through e-mail sent to scripter@microsoft.com. It is not that the migration is completed; however, getting the Script Center Script Gallery<\/a> online was a biggie. It is amazing how much one can get done when meetings get canceled (don’t get me wrong—I love meetings; they are a great way to build consensus on projects, an efficient method of disseminating complex information, and a good way to get to know one’s team members.) When you work with a large number of different people on a number of different projects, meeting time can rapidly outpace production time. I am very sure you know what I’m saying. <\/p>\n I looked in the Script Gallery and found the List Installed Hot Fixes<\/font><\/a> script that is seen here. <\/p>\n ListInstalledHotFixes.vbs<\/p>\n <\/strong><\/p>\n strComputer = “.” Set colQuickFixes = objWMIService.ExecQuery _ For Each objQuickFix in colQuickFixes <\/font><\/font><\/span><\/p>\n This is not one of those scripts you want to translate into Windows PowerShell. If you did a direct translation, you would end up with a script that looks like the TranslatedHotFixScript.ps1 seen here. <\/p>\n TranslatedHotFixScript.ps1<\/p>\n <\/strong><\/p>\n $strComputer = “.”<\/p>\n $colItems = get-wmiobject -class “Win32_QuickFixEngineering” -namespace “rootCIMV2” ` foreach ($objItem in $colItems) { <\/font><\/font><\/span><\/p>\n There is nothing wrong with the TranslatedHotFixScript.ps1 script. It will work properly, as seen here: <\/p>\n PS C:> gwmi win32_QuickFixEngineering<\/p>\n <\/font><\/span><\/p>\n The output from the short WMI command is seen here:<\/p>\n GetServersFromTextGetHotFixesWriteToLog.ps1<\/p>\n <\/strong><\/p>\n $servers = Get-Content -path c:fsoservers.txt <\/font><\/font><\/span><\/p>\n The GetServersFromTextGetHotFixesWriteToLog.ps1 script begins by creating two variables that are used to point to the log file and to the text file that holds the names of each of the servers. The text file is a simple file that has a computer name on each line of the file. No additional data is required other than the computer name. The Get-Content<\/b> cmdlet reads the text from the servers.txt file. The ForEach statement is used to walk through the array of computer names that is created by using the Get-Content<\/b> cmdlet to read the contents of the servers.txt file. This is seen here: <\/p>\n $servers = Get-Content -path c:fsoservers.txt <\/font><\/span><\/p>\n Inside the script block for the ForEach<\/b> statement, the first thing we do is write the computer name to the log file. This is done by piping the string directly to the log file. The encoding of the text file is set to ASCII (by default it uses Unicode), and the append<\/b> switch is used to keep the file from overwriting itself. This is seen here: <\/p>\n “Checking hotfixes on $server” | Out-FIle -filepath $logfile -encoding ASCII –append<\/p>\n <\/font><\/span><\/p>\n The Get-WmiObject<\/b> cmdlet is used to retrieve the data from WMI. The resulting management object is piped to the Format-Table<\/b> cmdlet. This is seen here:<\/p>\n Get-WmiObject -class Win32_QuickFixEngineering -Computername $Server |<\/p>\n <\/font><\/span><\/p>\n The Format-Table<\/b> cmdlet will create a table. The columns are the order in which the properties are selected. The autosize<\/b> switch is used to remove excess space between columns. The table is piped to the Out-File<\/b> cmdlet. This is seen here: <\/p>\n Format-Table -property HotFixID, InstalledON, Description -autosize | <\/span><\/p>\n <\/b><\/font><\/p>\n <\/p>\n When the script is run, the only output is written to the log file:<\/p>\n We invite you to follow us on Twitter<\/a> or Facebook<\/a> so that you can keep up to date with the latest Script Center news. If you have a question, you can always post it on the Official Scripting Guys Forum<\/font><\/span><\/a>, or send it to us by e-mail at scripter@microsoft.com<\/font><\/span><\/a>. <\/p>\n \n <\/p>\n<\/p>\n Ed Wilson and Craig Liebendorfer, Scripting Guys<\/span><\/b><\/p>\n","protected":false},"excerpt":{"rendered":" Hey Scripting Guy! I need to generate a list of hotfixes that are installed on my servers. I have 100 servers on the network for which I am responsible. Each of the server names is listed in a text file called servers.txt. I need a way to read the text file and then query […]<\/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":[31,3,203,45],"class_list":["post-52613","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-operating-system","tag-scripting-guy","tag-service-packs-and-hotfixes","tag-windows-powershell"],"acf":[],"blog_post_summary":" Hey Scripting Guy! I need to generate a list of hotfixes that are installed on my servers. I have 100 servers on the network for which I am responsible. Each of the server names is listed in a text file called servers.txt. I need a way to read the text file and then query […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/52613","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=52613"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/52613\/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=52613"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=52613"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=52613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/a-for-powertip.jpg\" "\\"Hey,")
<\/span><\/p>\n<\/p>\n
Set objWMIService = GetObject(“winmgmts:” _
<\/span>& “{impersonationLevel=impersonate}!\\” & strComputer & “rootcimv2”)<\/p>\n
<\/span>(“Select * from Win32_QuickFixEngineering”)<\/p>\n
<\/span>Wscript.Echo “Computer: ” & objQuickFix.CSName
<\/span> <\/span>Wscript.Echo “Description: ” & objQuickFix.Description
<\/span>Wscript.Echo “Hot Fix ID: ” & objQuickFix.HotFixID
<\/span>Wscript.Echo “Installation Date: ” & objQuickFix.InstallDate
<\/span>Wscript.Echo “Installed By: ” & objQuickFix.InstalledBy
Next<\/p>\n
-computername $strComputer<\/p>\n
<\/span>write-host “Caption: ” $objItem.Caption
<\/span>write-host “CS Name: ” $objItem.CSName
<\/span>write-host “Description: ” $objItem.Description
<\/span>write-host “Fix Comments: ” $objItem.FixComments
<\/span>write-host “HotFix ID: ” $objItem.HotFixID
<\/span>write-host “InstallationDate: ” $objItem.InstallDate
<\/span>write-host “Installed By: ” $objItem.InstalledBy
<\/span>write-host “Installed On: ” $objItem.InstalledOn
<\/span>write-host “Name: ” $objItem.Name
<\/span>write-host “Service Pack In Effect: ” $objItem.ServicePackInEffect
<\/span>write-host “Status: ” $objItem.Status
<\/span>write-host
}<\/p>\n![\"Image](\"http:\/\/img.microsoft.com\/library\/media\/1033\/technet\/images\/scriptcenter\/qanda\/hsg\/2009\/august\/hey0826\/hsg-8-26-09-01.jpg\" "\\"Image")
<\/p>\n
The script is easy to understand for someone making a transition from VBScript. The bad thing about TranslatedHotFixScript.ps1 is that it does not take advantage of Windows PowerShell objects. The same basic information can be obtained by typing a single line of code. The alias for the Get-WmiObject<\/b> cmdlet is gwmi<\/b>. When you use the alias, the command becomes the one seen here:<\/p>\n![\"Image](\"http:\/\/img.microsoft.com\/library\/media\/1033\/technet\/images\/scriptcenter\/qanda\/hsg\/2009\/august\/hey0826\/hsg-8-26-09-02.jpg\" "\\"Image")
<\/p>\n
A command-line solution is fine for some short testing, but I prefer to write a script if I am going to be performing a task more than once. The GetServersFromTextGetHotFixesWriteToLog.ps1 is still significantly shorter than the other hotfix scripts (except for the name), yet it does much more. The complete GetServersFromTextGetHotFixesWriteToLog.ps1 is seen here. <\/p>\n
$logfile = “C:fsohotfixlog.txt”
ForEach ($server in $servers)
{
<\/span>“Checking hotfixes on $server” | Out-FIle -filepath $logfile -encoding ASCII -append
<\/span>Get-WmiObject -class Win32_QuickFixEngineering -Computername $Server |
<\/span>Format-Table -property HotFixID, InstalledON, Description -autosize |
<\/span>Out-FIle -filepath $logfile -encoding ASCII -append
}<\/p>\n
$logfile = “C:fsohotfixlog.txt”
ForEach ($server in $servers)
{<\/p>\n
Out-FIle -filepath $logfile -encoding ASCII -append<\/p>\n![\"Image](\"http:\/\/img.microsoft.com\/library\/media\/1033\/technet\/images\/scriptcenter\/qanda\/hsg\/2009\/august\/hey0826\/hsg-8-26-09-03.jpg\" "\\"Image")
<\/p>\n
GM, that is about all there is to reading a text file, retrieving hotfix information, and writing it to a log file. We hope you enjoyed our little excursion today. Join us tomorrow as we continue to review scripts we found in the new Script Center Script Gallery. <\/p>\n