I dabble a bit in Merch by Amazon and have grown to hate the monthly sales reports they give you. For whatever reason, Amazon dumps a bunch of useless information in the first column of the CSV file. Why they do that, I have no idea, but it makes...
File Management
Convert text files to PDF then merge PDFs in bulk with PowerShell and iTextSharp
To demonstrate this process, I will show you how I export all the PowerShell help and convert it to PDF files that I use instead of looking at the help files in the PowerShell Console. I realize you can view the PowerShell help files in the console and online....
Search file structure for a specific file type w/ PowerShell
This script will search a file structure for a specific file type and export the results to a CSV file. This can be used to search a user accessible file share for file types that you may have policies against storing on a file share. If you don’t have...
Remotely Install Adobe Reader with PowerShell
This scripts is quick, dirty and could be made more efficient. That said, it works.Reads a As constructed it reads a txt file containing computer names and attempts to ping each machine. If the ping is successful, it copies the contents of c:\Install from the source computer to c:\install on the...
Scan for Pii with Powershell
I use this script to search our fileshare for Social Security Numbers… or something that has the same format as a SSN. Get-ChildItem -Path "z:\share" -Recurse -Force -Include *.doc, *.docx, *.xls, *.xlsx, *.txt, *.pdf, *.ppt, *.pptx | Select-String "{3}{2}{4}" | Select-Object Path, Line, LineNumber | Export-Csv "c:\scripts\pii.csv"...
Delete multiple files or folders input from a CSV file (Powershell)
*** THIS SCRIPT IS PROVIDED WITHOUT WARRANTY, USE AT YOUR OWN RISK *** This script will delete one or more files or folders based on input of a list from a CSV file. I wrote this to work in conjunction with this script: https://www.signalwarrant.com/2013/04/20/search-file-structure-for-a-file-or-file-type-and-put-the-results-in-a-csv-file-powershell/. Pretty simple but very effective....
Search file structure for a file or file type and put the results in a CSV file (Powershell)
*** THIS SCRIPT IS PROVIDED WITHOUT WARRANTY, USE AT YOUR OWN RISK *** I put this script together to search my SAN for some files we didn’t want taking up space on our device. It’s essentially a re-work of this script (https://www.signalwarrant.com/2012/07/31/search-for-specific-file-extension-powershell/) from a few months ago. It’s pretty...
Copy a folder and files to multiple computers (Powershell)
** THIS SCRIPT IS PROVIDED WITHOUT WARRANTY, USE AT YOUR OWN RISK ** I used this script to copy a new desktop background image to about 100 computers recently. Usage: 1. You will need to create a folder on your computer (eg c:\script). 2. Copy the script to the...