Use PowerShell to Work with Data from MS OMS

Summary: Ed Wilson, Microsoft Scripting Guy, talks about using Windows PowerShell to parse data obtained from Microsoft Operations Management Suite. Microsoft Scripting Guy, Ed Wilson, is here. One of the things I have been working on a lot the past month is the new Microsoft Operations Management Suite Blog. For one thing, it is on…


PowerTip: Get Row from CSV File Based On Value

Summary: Use Windows PowerShell to get a row from a CSV file based on a specific value.  How can I use Windows PowerShell 4.0 to look up a specific row from a CSV file I imported into a variable?  Use the Where method, and use a match pattern to search on a specific column and value, for example:…


Use PowerShell to Fix Date from CSV File

Summary: Microsoft Scripting Guy, Ed Wilson, talks about using Windows PowerShell to fix the date in a CSV file prior to data export. Microsoft Scripting Guy, Ed Wilson, is here. This morning I am sipping a cup of English Breakfast tea. I added a cinnamon stick and a bit of lemon grass to the pot….


Use PowerShell to Read Munged Data

Summary: Microsoft Scripting Guy, Ed Wilson, talks about using Windows PowerShell with munged data. Microsoft Scripting Guy, Ed Wilson, is here. Last week, the Scripting Wife and I had the opportunity to attend the Charlotte SQL Users Group. This is always a highlight, because that user group is one of the largest SQL User Groups…


PowerShell Mini-Scripting Games 2014: Answer 2

Summary: Here is the answer to Problem 2 in Windows PowerShell Mini-Scripting Games 2014. Microsoft Scripting Guy, Ed Wilson, is here. Problem 2 could be a bear to solve. After all, it involves text manipulation. Last week, I posted the complete Problem 2 description and task outline. Problem 2 synopsis You have a CSV file…


PowerShell Mini-Scripting Games 2014: Answer 1

Summary: Here is the answer to Problem 1 in Windows PowerShell Mini-Scripting Games 2014. Microsoft Scripting Guy, Ed Wilson, is here. Here is an answer to Problem 1 in Windows PowerShell Mini-Scripting Games 2014. Last week, I posted the complete Problem 1 description and task outline. Problem one synopsis You are reading a CSV file…


Use PowerShell to Create CSV File to Open in Excel

Summary: Microsoft Scripting Guy, Ed Wilson, talks about exporting a directory list to a CSV file and opening the file in Microsoft Excel with Windows PowerShell.  Hey, Scripting Guy! I have a lot of music files that reside in nested folders. I would like to be able to look at the file information in Microsoft…


Use PowerShell to Remove Data from CSV File

Summary: Guest blogger, Matt Tisdale, talks about using Windows PowerShell to remove data from a .csv file. Microsoft Scripting Guy, Ed Wilson, is here. Welcome back guest blogger, Matt Tisdale… Last night a geoscientist told me that he has almost 900 .csv files, and he needs to remove two columns of data from them. He…


Write Users and Proxy Addresses to CSV by Using PowerShell

Summary: Microsoft Scripting Guy, Ed Wilson, talks about writing all proxy addresses and user names to a CSV file by using Windows PowerShell.  Hey, Scripting Guy! Yesterday’s blog post, Export User Names and Proxy Addresses to CSV File, showed me an easy way to get a couple of proxy addresses from Active Directory, but all…


Export User Names and Proxy Addresses to CSV File

Summary: Microsoft Scripting Guy Ed Wilson talks about using Windows PowerShell to export user names and proxy addresses to a CSV file from Active Directory.  Hey, Scripting Guy! I am trying to produce a report of our users in Active Directory and their associated proxy addresses. I want it in Excel, so I am using…