Various PowerShell scripts

This page just gives me a place to keep a most-recent-copy of my various PowerShell scripts, mostly related to TFS.  This makes it easier for people that want to use them than having to copy-paste from lots of different blog posts.  Note that since some of the scripts call other scripts in this collection, you'll want whatever dir you put them in to be in your path so those calls will resolve correctly.


  • 2007-02-14: initial posting
  • 2007-02-20: remove backup files, add JManningSnapIn dir with 2 cmdlets
  • 2007-02-27: add AUTH property to get-tfs for easier access to IAuthorizationService
  • 2007-04-04:
    • remove cmdlets since they'll likely become power tools
    • update check-wss to use OM
    • add various scripts posted on the blog
      • change-websiteid
      • connect-webservice (slightly modifed version of Lee's)
      • convertto-readabledisplayname
      • get-db
      • get-hash
      • get-hashes
      • get-iprestrictions
      • get-memberships
      • get-sqlrsinfo
      • get-teamprojectacls
      • get-tfsserverstatus (actually a rename and edit of get-tfsstatus)
      • wmiexplorer (MoW's version)
    • update translate-changeset to use connect-webservice
    • beef up run-query to handle both scalar and sets of data
    • fix trap construction when normalize-tfserverurl calls get-workspace
    • change normalize-tfserverurl param to optional by figuring out server based on if the current dir is mapped
    • refactor out new-sqlconnectionfromconnectionstring so places with a connection string can get a connection from that