Tonight, I published Invoke-Locate.ps1 to ScriptCenter because I was tired of mounting my Windows drive to my Linux servers to quickly and reliably find files. Originally, it was going to be a small script, but then I decided to trick it out, add an installer and automatic Task Scheduling to run updatedb. The installer …

I'm currently working on a PowerShell/SQL set of scripts to ease SQL Server Migrations. A few of the scripts have been posted to Microsoft's ScriptCenter. Recently, one of the ScriptCenter visitors asked: Can this script be used to backup all server configuration and restore at a later date. The use case I have is that …

About 8 years ago, I wrote a blog post that provided a VBScript to create easy-to-read shortcuts to IIS Log directories. W3SVC56 just wasn't helpful enough to identify which website logs to which directory. Today, I ported that same script to PowerShell. I'm too lazy to explain, so this is what it does: Easy peasy. …

A buddy of mine was running into issues importing a 1 GB CSV of Longitudes and Latitudes available from geonames.org. The CSV contains over 9 million rows, and no matter what he did, DTS/SSIS would not import the data because of conversion issues. That's actually been happening to me a lot lately, too, so I find myself …

I'm not super familiar with ThinApping, but converted portions of this VMware login script at the request of a consultant. I tried to automate the script a bit more than the one from VMware's blog. Their script required that you put in the path to each EXE. This script will find all exes within a directory and register …

Recently, while trying to use New-WebServiceProxy to automate some SharePoint form entries, I ran into a lookup issue. First, I got this rather generic error: Exception calling "GetListItems" with "7" argument(s): "Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was …

Need your External IP address? Just use the following in Windows PowerShell 3+ or PowerShell 7+: 1$ip = (Invoke-WebRequest https://ipinfo.io/ip).Content.Trim() As a bonus, you can also get additional IP information using ipinfo.io's JSON web service. 1# Simple, object-based approach 2$ipinfo = Invoke-RestMethod …

Unfortunately, there are no native PowerShell Failover Cluster cmdlets which will give you the volume information for disks in a cluster. I've seen some bloggers use Get-ClusterSharedVolume but a Cluster Shared Volume or CSV is different from volumes used within a SQL cluster. The script below, which was written with …

Recently, I was asked to help automate a friend's super boring daily duty of logging repetitive activities to a SharePoint Task list. Even though I'm no longer regularly working with SharePoint (yay!), I accepted the challenge. Below is the script I created, which can be scheduled (and mixed up, even using $a = …

In my previous post, I outlined how to use PowerShell v2 to keep a CookieJar and POST to a Web Form that Prohibits XSS. The code was 35 lines long. Upon seeing my post, Lee Holmes suggested using PowerShell v3's Invoke-WebRequest instead to get my code down to 1/5th of its original size. I'm astounded at how easy …