Been so long since my last update! Why haven’t I posted more? Well, for one I’m usually so tired from coming home from work I just don’t have any extra energy for PowerShelling. Another factor has been there are so many people doing so many interesting things I just couldn’t find anything that someone else wasn’t already doing much better than I am. The last bit is having an interesting project to talk about. I’ve been doing a lot of things at work, but it had to do with Windows cluster node moves, SQL Availability Group moves and so on. But ultimately the scripts become pretty specific to athena so it’s difficult to translate for general use.
I think I finally have something interesting, though, with Get-SAUser so read on!
Awhile back I wrote the Invoke-SQLQuery script, it’s a light-weight easy way to query a SQL database and get data back. It’s primary appeal over just using Invoke-SQLCMD was there is no need to install anything, just run the script, get your data and go. Easy, peesy. Now it’s time for a big update in capability.
I love using ConvertTo-HTML. There, I’ve said it. The vast number of scripts I write are doing some kind of reporting function and the ability to create simple, fast, yet good looking reports with HTML has been a huge plus for PowerShell. That said though, there’s definitely room for improvement. ConvertTo-AdvHTML is an advanced function that addresses some of the current limitations with current cmdlet. But this blog post isn’t going to a long explanation of how to use the new cmdlet, instead I wanted to write a script that actually used it.