powershell check if kb is installed on remote computer powershell check if kb is installed on remote computer

This script will check if the computer is pingable and if pingable connects to the remote computer to get the patch details. But, it is little challenging to get the accurate details after patch installation if any system\server is still missing this patch or not. Summary: Learn how to use Windows PowerShell to quickly find installed software on local and remote computers. This is a basic PowerShell script that can be used to determine if a KB related update is installed. # grab the machines that have failed and save them for next run sweep wmic qfe list, How to show that an expression of a finite type must be one of the finitely many possible values? More info about Internet Explorer and Microsoft Edge. Why is this sentence from The Great Gatsby grammatical? It's part of the PSDiagnostics module. The Get-Hotfix cmdlet uses the Win32_QuickFixEngineering WMI class to list hotfixes that are I found a related link just for your reference. Find centralized, trusted content and collaborate around the technologies you use most. Get-ChildItem -Path 'Registry::HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Component Based Servicing\Packages'. If you preorder a special airline meal (e.g. After that, Get-WindowsUpdate. You can also see Boe's biography in the Day 1 blog. $dev = 0 How do you know it doesn't return all updates? i searched many templates to run PowerShell script for fetching KB's status, but not working any more. Also I tried filter installed updates from next script result: The array notation [-1] selects the most recent installed hotfix. By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. Asking for help, clarification, or responding to other answers. "Total devices passed: $totalpassed" | Out-File $output -Append By clicking Post Your Answer, you agree to our terms of service, privacy policy and cookie policy. $error | Out-File $failed -Append The Get-Hotfix cmdlet is used to check for hotfixes that are installed. NOTE! As part of this PowerShell script, I have created a PowerShell function get-installed patch with error handling. NOTE! Site design / logo 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA. The second command pulls from the Programs and Features section and will output just KB, type, installed by, and installed on. In addition, I tested it in my lab environment and I would like to share the screenshot for your reference: How I've done it in the past. console when Im done and the code is gone. Thanks again for your help! https://code.visualstudio.com/ Opens a new window. includes the asterisk (*) wildcard. most of them seem too complicated in my opinion. I appreciate your patience. In a technical forum questions need to be clear and complete. First, in an administrative PowerShell console, download and install the PSSoftware PowerShell module from the PowerShell Gallery by running Install-Module PSSoftware. Whether on a local machine or running on a remote PowerShell session, to install a Chocolatey package is the same command, choco install. scripts. The Win32_QuickFixEngineering WMI class represents Ive seen a lot of functions and scripts this week to accomplish that task, but qualified domain name (FQDN) of a remote computer. Some other possibilities: Grep %windir%\Windowsupdate.log for the KB number. So I put together a PowerShell script that can be used to get the Windows version for a local or remote computer (or group of computers) which includes the Edition, Version and full OS Build values. In the scenario of testing for Windows updates that are installed specifically for WannaCry, Ill Welcome to the Snap! What is the correct way to screw wall and ceiling drywalls? It lists the installed hotfixes on the local or one or more remote computers. The Credential parameter specifies a user account that has obtain a list of computer names from a text file. By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. Get-HotFix uses the Description parameter to specify hotfix types. I am trying to search for hotfix installed on list of computers. Is there a solutiuon to add special characters from software and how to do it. Is there a solutiuon to add special characters from software and how to do it, Styling contours by colour and by line thickness in QGIS. If a You need to hear this. A limit involving the quotient of two sums. By the time I get it figured out the reason I started to connect to the Windows Update servers and download the updates if found. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. Connect and share knowledge within a single location that is structured and easy to search. The Get-Hotfix cmdlet gets all hotfixes installed on the local computer. Get-Hotfix With this useful command you can show all installed Updates on the localhost. script because the shelf life isnt long enough to justify writing a function. my organization. Your daily dose of tech news, in brief. is an IT service provider. Or you can use SCCM CMPivot to get the details of Patch Installation Status. )(?=\])' ) | ? get-wmiobject -class win32_quickfixengineering -ComputerName 'remote computer name'. Let's go through some of the processes and the ways to speed up the process. objects in $A are sent down the pipeline to ForEach-Object. Microsoft patch Tuesday for the month of May 2019 brought us some critical updates one of which highly discussed is CVE-2019-0708 vulnerability. I wanted to know if i can remote access this machine and switch between os or while rebooting the system I can select the specific os. PowerShell remoting enabled on the servers you want to scan. wmic qfe. The company I work for wants to use Powershell and my script is almost complete just trying to find out why it keep telling me that doesnt find the PC even though it is online and is patched. Or use reg.exe to export the corresponding install keys. Learn how to use Powershell to list the installed updates on a computer running Windows in 5 minutes or less. Is there any updates of the case? I would welcome any suggestions on this. In this case,e PowerShell can help us with more accurate details, I wrote a PowerShell script and it worked perfectly to get the details of KB number (KB4499175 or KB4499180) and installed date with computer name from remote server. What are some of the best ones? So I ended up fixing the problem and this will give me the info that I am looking for the only thing that I noticed in the error handling is if you dont have access to the computer it will tell you the KB isn't found. From the output of systeminfo you can extract the info for the KBs and set it to see if any of the KBs match and do an if statement to say yes it exists print to screen it is there and just loop through the output to say yes or no for each KB you specify. I decided to let MS install the 22H2 build. The nature of simulating nature: A Q&A with IBM Quantum researcher Dr. Jamie We've added a "Necessary cookies only" option to the cookie consent popup. What's the command-line utility in Windows to do a reverse DNS look-up? How do I get the current username in Windows PowerShell? Type the NetBIOS name, an Internet Protocol (IP) address, or a fully I placed the Patches variable inside of Invoke-Command to make the script PowerShell 2.0 I had try next scripts: Get-HotFix , wmic qfe list , Get-WmiObject -Class Win32_QuickFixEngineering . } rev2023.3.3.43278. The Scripting Wife and I were lucky enough to attend the first PowerShell User Group meeting in Corpus Christi, If you did not have the correct version/module, Powershell would throw an error about command not found. Opens a new window. But I used the word grep here as in "to grep" to indicate the process in stead of literally meaning the utility "grep". Take a look at the PSWindowsUpdate module in the PowerShell gallery. Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. So after further investigation of my script it looks like when it goes through the function if the computer is active and has the patch then the script works fine with no issues. Theyre generally generic enough to be used in multiple scenarios. Next script don't return all installed Windows updates too: I have no more ideas and I will be grateful for help. I'll keep working on it, I just need to dig more in my Webinar: Reduce Complexity & Optimise IT Capabilities. Windows XP: How can I get the system language from command-line? What Is the Difference Between 'Man' And 'Son of Man' in Num 23:19? But this script return not all updates. "Total devices failed: $totalfailed" | Out-File $output -Append Asking for help, clarification, or responding to other answers. To continue this discussion, please ask a new question. I added a "LocalAdmin" -- but didn't set the type to admin. Or from powershell, just adjust it for your needs: PowerShell 2.0 contains the get-hotfix cmdlet, which is an easy way to check if a given hotfix is installed on the local computer or a remote computer. Perhaps because it's configured to roll off after that time but I'm just pointing out that in some cases not finding it in that log may not indicate it's absent from the system. I would like to check if a particular KB is installed on all 200 computers or NOT. (Test-Path -path "$DirectoryToSaveTo")) #create it if not existing { New-Item "$DirectoryToSaveTo" -type directory | out-null } #Create a new Excel object using COM $Excel = New-Object -ComObject Excel.Application $Excel.visible = $True $Excel = $Excel.Workbooks.Add() $Sheet = $Excel.Worksheets.Item(1) $sheet.Name = 'Patch status - ' #Create a Title for the first worksheet $row = 1 $Column = 1 $Sheet.Cells.Item($row,$column)= 'Patch status' $range = $Sheet.Range("a1","f2") $range.Merge() | Out-Null $range.VerticalAlignment = -4160 #Give it a nice Style so it stands out $range.Style = 'Title' #Increment row for next set of data $row++;$row++ #Save the initial row so it can be used later to create a border #Counter variable for rows $intRow = $row $xlOpenXMLWorkbook=[int]51 #Read thru the contents of the Servers.txt file $Sheet.Cells.Item($intRow,1) ="Name" $Sheet.Cells.Item($intRow,2) ="Patch status" $Sheet.Cells.Item($intRow,3) ="OS" $Sheet.Cells.Item($intRow,4) ="SystemType" $Sheet.Cells.Item($intRow,5) ="Last Boot Time"$Sheet.Cells.Item($intRow,6) ="IP Address" #sets the font and color for the headers for ($col = 1; $col le 6; $col++) { $Sheet.Cells.Item($intRow,$col).Font.Bold = $True $Sheet.Cells.Item($intRow,$col).Interior.ColorIndex = 48 $Sheet.Cells.Item($intRow,$col).Font.ColorIndex = 34 } $intRow++ Function GetUpTime { param([string] $LastBootTime) $Uptime = (Get-Date) - [System.Management.ManagementDateTimeconverter]::ToDateTime($LastBootTime) "Days: $($Uptime.Days); Hours: $($Uptime.Hours); Minutes: $($Uptime.Minutes); Seconds: $($Uptime.Seconds)" } #This will try every computer in computers txt against the following$computers = Get-Content -Path $computerListforeach ($computer in $computers) { #If it cant find an IP address it will jump down to the catch and write PC not online#if it can find the KB it will continue down the list and write it out to the excel file#if it can find the KB it will jump to the catch see that the ip is not null so it will write out the the KB isnt found try { $IpV4 = (Test-Connection -ComputerName $computer -count 1).IPV4Address.ipaddressTOstring if ($KbInFo = Get-HotFix -Id $Patch -ComputerName $computer -ErrorAction 1) { $kbiNstall="$patch is installed" } $OS = Get-WmiObject -Class Win32_OperatingSystem -ComputerName $Computer -ErrorAction SilentlyContinue $sheetS = Get-WmiObject -Class Win32_ComputerSystem -ComputerName $Computer -ErrorAction SilentlyContinue $sheetPU = Get-WmiObject -Class Win32_Processor -ComputerName $Computer -ErrorAction SilentlyContinue $drives = Get-WmiObject -ComputerName $Computer Win32_LogicalDisk | Where-Object {$_.DriveType -eq 3} -ErrorAction SilentlyContinue $OSRunning = $OS.caption + " " + $OS.OSArchitecture + " SP " + $OS.ServicePackMajorVersion $systemType=$sheetS.SystemType $date = Get-Date $uptime = $OS.ConvertToDateTime($OS.lastbootuptime) $sheet.Cells.Item($intRow, 1) = $computer $sheet.Cells.Item($intRow, 2) = $kbiNstall $sheet.Cells.Item($intRow, 3) = $OSRunning $sheet.Cells.Item($intRow, 4) = $SystemType $sheet.Cells.Item($intRow, 5) = $uptime $sheet.Cells.item($intRow, 6) = $IpV4 } catch { If($IpV4 -eq $null){ $sheet.Cells.Item($intRow, 1) = $computer $sheet.Cells.Item($intRow, 2) = "PC is not online"} else{ $sheet.Cells.Item($intRow, 1) = $computer $sheet.Cells.Item($intRow, 2) = "PC HotFix Not Found" $sheet.Cells.Item($intRow, 3) = $OSRunning $sheet.Cells.Item($intRow, 4) = $SystemType $sheet.Cells.Item($intRow, 5) = $uptime $sheet.Cells.item($intRow, 6) = $IpV4 } } $intRow = $intRow + 1 } $erroractionpreference = SilentlyContinue $Sheet.UsedRange.EntireColumn.AutoFit() ########################################333 ############################################################## $filename = "$DirectoryToSaveTo$filename.xlsx" #if (test-path $filename ) { rm $filename } #delete the file if it already exists $Sheet.UsedRange.EntireColumn.AutoFit() $Excel.SaveAs($filename, $xlOpenXMLWorkbook) #save as an XML Workbook (xslx) $Excel.Saved = $True $Excel.Close() $Excel.DisplayAlerts = $False $Excel.quit()[System.Runtime.Interopservices.Marshal]::ReleaseComObject($Excel)spps -n Excel. {$_ -notlike "*TInput,TOutput*" -and $_ -notlike ")(.*? what is the command to retrieve the installed application/packages via command line in windows? Why is there a voltage on my HDMI and coaxial cables? To learn more, see our tips on writing great answers. This is something I almost always do. The script I have written is giving me some odd results and I can not get the script to function. This is a quick note to let you know that I am currently performing research on this issue and will get back to you as soon as possible. } | Select-Object -Property PSComputerName,Description,HotFixID,InstalledOn | Export-Csv -Path $output -Append -NoTypeInformation how can i check for particular hotfix?Getting installed updates and information on a REMOTE computer.Check If Hotfix isn't Installed and Output to File - Spiceworks .Using Powershell to get KB information on remote computers[SOLVED] Silently Install Patches Remotely and Reboot - PowerShellMore . a small system-wide update, commonly referred to as a quick-fix engineering (QFE) update, applied to Site design / logo 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA. the current user. I added a "LocalAdmin" -- but didn't set the type to admin. Servicing (CBS). only check for the specific updates that are applicable to that OS. Luckily, we can do this easily from the PowerShell Gallery. Day 4: Use PowerShell to Find Missing Updates on WSUS Client Computers. If all of the remote servers were running PowerShell 3.0 or higher, that could have been This is a basic PowerShell script that can be used to determine if a KB related update is installed. How do I get the application exit code from a Windows command line? Learn more about Stack Overflow the company, and our products. on each machine. Hi Team, configured to run remote commands, use the ComputerName parameter. An example of the basic syntax is get-hotfix -id KB974332 On my machine, that command returns Let me know how this works for you! Note that the above two links are not from MS, just for your reference. . $pcnotfound = "true" which in turn once this happens once it will always be true which in turn gives me the PC Not Found message for every computer after that one. So, first interaction here, so if more is needed, or if I am doing something wrong, I am open to suggestions or guidance with forum ettiquette. Flashback: March 3, 1971: Magnavox Licenses Home Video Games (Read more HERE.) It also confirms that Get-Hotfix does not computer once it reaches a computer thats unreachable. What video game is Charlie playing in Poker Face S01E07? Appreciate this is an old answer but the %windir%\Windowsupdate.log only seems to show updates for the past month. It is helpful to get the specified updates from WSUS database and save to the specified path. $machines_to_sweep = C:\Patching\machines2sweep.txt all of the ones that are valid next month that patch this vulnerability. If the response is helpful, please click "Accept Answer" and upvote it. To run on a remote machine $Hotfixes = wmic /node:SYSTEM /user:DOMAIN\USER /password:PASSWORD qfe list brief /format:csv | ConvertFrom-Csv Lee_Dailey 4 yr. ago howdy I_Am_Corgibuttz, More details about Patch Installation Status can be found in the following sections of this post. Please find the actual code of this script from Github below link https://raw.githubusercontent.com/jampaniharish/OnlineScripts/master/Get-installedPatch.ps1. is enabled by default on servers running Windows Server 2012 and higher. I just ran Get-Hotfix on my local computer and it came back with a short list of 11 updates/hotfixes while the longer script came back with a detailed history of 775 events both successful and failures. for user-based installs. Wildcards aren't accepted. To check where a computer gets its updates from, run the Get-WUServiceManager command. How to react to a students panic attack in an oral exam? Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. To learn more, see our tips on writing great answers. In the 'Load From' combo-box choose 'Remote Computer'. Please feel free to inform me in time if there are any questions. The queries are written to list the WUA history in a PowerShell by defining a few functions to convert WUA history events of result code to a Name and get the last and latest 50 WUA history. I get the error: get-hotfix : Cannot find the requested hotfix on the 'localhost' computer. # at least one found first checking to see what operating system and architecture the target computer is running to then NOTE! They have a free version which will accomplish this as well. Get-WmiObject -Class win32_quickfixengineering | where {$_.hotfixid -eq KB4499175 -or $_.hotfixid -eq KB4499180} But this is suppose to be run as Domain admin so this shouldn't be an issue. )(?=\" } | Select -ExpandProperty Value | Out-File $machines_to_sweep Get-Hotfix filters the output with the Description parameter and the string Security that It can be enabled on other versions using Enable-PSRemoting as long as PowerShell 2.0 or higher is installed. # if the directory doesn't exist, then create it if (! By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. The script could help to get the specified KB number from client itself. PowerShell remoting is also more firewall friendly and The first detail is that you need to maintain a remote session while the installer is running. The following example scans three servers for the hotfixes listed in Microsoft Security Bulletin MS17-010. Asking for help, clarification, or responding to other answers. Hello, PowerShell enthusiast today I will be sharing a script that will eventually help you to check various things on a server remotely after the windows server patching is performed. This cmdlet is only available on the Windows platform. PowerShell 2.0 contains the get-hotfix cmdlet, which is an easy way to check if a given hotfix is installed on the local computer or a remote computer. While its personal preference, I also always think about whether I should use a PowerShell Since PSWindowsUpdate is not installed on Windows by default, we have to first install the module. Your code appears to be guesswoek and not based on PowerSHell. I just added the where clause to your script to match my requirement. # add stats to final csv }. been patched. oops, I missed some lines in the beginning which need to append to my code: document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); This site uses Akismet to reduce spam. get specific KBs installed on remote servers, How Intuit democratizes AI development across teams through reusability. password. Im currently working on a Powershell script that can get information about a remote computer (IP, OS Type, Ping Status, Etc.) Connect and share knowledge within a single location that is structured and easy to search. Plus, you can add additional script to it look at other things besides the presence of a KB to include installed software, state of a service, or registry settings. For whatever reason, using "find" is giving me an incorrect format error. If the update isn't installed, the computer name is written to a text file. An example of the basic syntax is get-hotfix -id KB974332 Share Improve this answer Follow edited Feb 23, 2015 at 8:31 HBruijn 73.5k 23 132 194 answered Feb 23, 2015 at 7:35 raeez 191 1 2 saved as scripts or shared with others. SCCM How to find the list of Software Updates and patches installed Via Quick Fix Engineering. To subscribe to this RSS feed, copy and paste this URL into your RSS reader. 3 I need to get all installed Windows updates with PowerShell. using all the aliases and positional parameters that I want since Ill simply close out of the 1 Get-Hotfix To display only hotfixes you are looking for you can limit the result using Where-Object. you know that the computer is good to go if any one of these updates is found. NOTE! So, first interaction here, so if more is needed, or if I am doing something wrong, I am open to suggestions or guidance with forum ettiquette. compatible. Tutorial Powershell - List installed updates [ Step by step ] Learn how to use Powershell to list the installed updates on a computer running Windows in 5 minutes or less. Tried single and double quotes. Also, I would not recommend Notepad, Notepad++, or any other text editor for writing Powershell scripts, because sometimes the plain text editors will add zero-width whitespace characters or invisible end-of-line characters that cause weird behavior when they are pasted into Powershell. A Boolean is a Boolean and dies not get tested against a string. but as for now you can make due with the following Powershell cmdlet. For more information, see [Regex]::Matches($Error, (?<=\[)(.*? Most of the entries in the NAME column of the output from lsof +D /tmp do not begin with /tmp. computer name to a file. Using grep as a verb is very common in the Unix circles I normally operate in, so I used the term more or less without thinking it might look odd to a Windows guy. 1 To learn more, see our tips on writing great answers. Thanks for contributing an answer to Server Fault! Flashback: March 3, 1971: Magnavox Licenses Home Video Games (Read more HERE.) I'm excited to be here, and hope to be able to contribute. (Get-HotFix -Id KB957095 -ComputerName $_)) { Add-Content $_ -Path ./Missing-KB957095.txt }} I currently use PDQ Inventory to do this. @Abraham Zinala I compare returned result with list of updates in "Uninstall An Updates" from "Control Panel". "Total devices: $dev" | Out-File $output -Append Has 90% of ice around Antarctica disappeared in less than a decade? PowerShell report on applied windows updates after a date. How to check your PowerShell version Launch PowerShell and enter the following command to verify the version of PS installed: $PSVersionTable.PSVersion It will display a table with the. What is the error. Theres no reason for that since to the next computer once it tries to connect to one that is unreachable. What are some of the best ones? PowerShell Search Installed Windows Update on Remote Computers Swapnil Infotech 616 subscribers Subscribe 16 744 views 8 months ago PowerShell Scripts In This Video you will learn how to. It has been a crazy week to say the least. Is it suspicious or odd to stand by the gate of a GA airport watching the planes? These updates aren't listed in the registry. Sort-Object sorts Type the NetBIOS name, an Internet Protocol (IP) address, or a fully qualified domain name (FQDN) of a remote computer. Open a Command Prompt and Type Command Right-click on the Start button (or the key combination WIN + X) and select Command Prompt (Administrator) in the menu that opens. As mentioned above, you can choose an easier way to solve your problem without using Powershell. I'm looking to find out if a KB is installed via command line. Please remember to vote and to mark the replies as answers if they help. Reduce Complexity & Optimise IT Capabilities. I decided to let MS install the 22H2 build. Day 3: Approve or Decline WSUS Updates by Using PowerShell. An if statement uses the Depending on the way in which the software installed, the software can be found in one of three different registry keys: HKLM:\Software\Microsoft\Windows\CurrentVersion\Uninstall or. You can use PowerShell to check and download Windows updates from a server set up with Windows Server Update Services (WSUS). Actually We have a WSUS server in which 200 computers are reporting (existing) . This particular vulnerability is rated as emergency in many organisations and patching\SCCM teams are busy in deploying the fix for this vulnerability. The best answers are voted up and rise to the top, Not the answer you're looking for? $machines = C:\Patching\machines.txt Powershell, How to get date of last Windows update install or at least checked for an update? This script will fetch the results like server uptime, list of auto stopped services, list of KB articles installed on the server, etc. A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications. of your servers. computer doesn't have the specified hotfix Id installed, the Add-Content cmdlet writes the You could just as easily query Active Directory for the computer names or use Get-Content to @sri sri #### Spreadsheet Location $DirectoryToSaveTo = "$env:USERPROFILE\Downloads\" $date=Get-Date -format "yyyy-MM-d" $Filename="Patchinfo-$($date)" ###InputLocation $Computers = Get-Content "$env:USERPROFILE\Downloads\Computers.txt" # Enter KB to be checked here $Patch = 'KB4500331','KB4499164','KB4499175','KB4499149','KB4499180' # before we do anything else, are we likely to be able to save the file? Jordan's line about intimate parties in The Great Gatsby? or host firewall since it uses older protocols for communication. How do I start PowerShell from Windows Explorer? How secure is SecureString?. Invoke-Command usually creates a temporary session on the remote server to execute the commands mentioned in the script block.. Start-sleep-seconds 120, the script will pause for 120 seconds and let the installation runs in the background and complete.. Start-service -Name "service name" give the service name to start the service if it is required. permission to access the remote computers and run commands. Your code appears to be guesswoek and not based on PowerSHell. Not the answer you're looking for? More info about Internet Explorer and Microsoft Edge. Those are enabled but I'm still not getting the "arrangement" (syntax) correct on the spare time. CVE-2019-0708. The following example demonstrates this problem where Get-Hotfix does not continue to the next The Get-Hotfix command uses parameters to get hotfixes installed on remote computers. Example Get-HotFix Output Bonus Flashback: March 3, 1969: Apollo 9 launched (Read more HERE.) Why is this the case? Also, I found a useful link for your reference. @UnicornLady Hu -MSFT I need a to check multiple servers like server x, server y, server z etc.. with out typing the KB in PowerShell script, is there any ways to import the excel or csv file which includes the server x, server y, server z with KB to find in single run with PowerShell. The difference between the phonemes /p/ and /b/ in Japanese. Why are Suriname, Belize, and Guinea-Bissau classified as "Small Island Developing States"? https://community.spiceworks.com/how_to/139222-how-to-list-all-windows-updates-using-powershell?page https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.management/get-hotfix?view=p How to Manage Windows Updates Remotely on Multiple PCs. What is the exact command that you ran? Arrrrgh..what am I missing.I walked away and came back and got it to work this far: Why am I getting "At line:6 char:1+ | Select-Object Date,@{name="Operation";+ ~An empty pipe element is not allowed.At line:10 char:1+ | select Date, Status, Title | export-csv -NoType \\siilpeowsittmg\Us + ~An empty pipe element is not allowed. What is a word for the arcane equivalent of a monastery? if(Test-Connection are filtered by a specified description string. The default is What is a word for the arcane equivalent of a monastery?