Learn Powershell | Achieve More
910 FOLLOWERS
Learn Powershell blog is authored by Boe Prox. He is a Senior Windows System Administrator and has been using PowerShell since 2008. He is also a recipient of the Microsoft MVP award in Windows PowerShell.
Learn Powershell | Achieve More
3y ago
Something that I had noticed a while back that I would receive some output values in my objects that shouldn’t have been there. Properties that should have been Null had values in them, and not just random values, but values that matched some of the other outputted objects. This was somewhat worrisome because I didn’t want my project, PoshRSJob, to have this same problem (which it did have). Duplicating the issue was simple, and actually fixing ended up being simple but it wasn’t something that immediately stood out to me, mostly because I had thought that I tested out the solution already and ..read more
Learn Powershell | Achieve More
3y ago
This As I did last year, and the years before that, I wanted to review my last PowerShell resolutions and see how well I did and then take a look at the coming year and pick a few things that I’d like to strive for either in learning new things with PowerShell or as part of the community. With so much happening in the world of PowerShell, it should be pretty fun to figure out things that I would like to learn and talk about in the coming new year. Also, with a new position as a SQL DBA, I am looking forward to doing some amazing things with PowerShell and SQL.
Without further ado, let’s see wh ..read more
Learn Powershell | Achieve More
3y ago
I’ve had a few emails and questions about the best way to get the hostname of the local computer that you are currently logged into and felt that a quick (and I mean quick ) post here would be worthwhile.
Using WMI or the CIM cmdlets, you can pull the information from just about any class as there is the __Server property which gives you the name, or you can make of the PSComputername property (which is just an alias to __Server thanks to a type file). Here is one such example:
Get-WMIObject –Class Win32_Bios | Select PSComputername, __Server
A more simple approach is making use of a legacy c ..read more
Learn Powershell | Achieve More
3y ago
I’ve been busy working on some articles for MCPMag.com and wanted to share a couple of stubs to my most recent articles.
Gathering Installed Software Using PowerShell
If there is one thing an administrator finds themselves doing, it is probably determining what software is installed on their system. It could be simply for just knowing what they have installed, or determining if some software installed may have vulnerabilities which are fixed via a security update or performing an audit for software (which may not have been approved to be installed). Either way, having a means to locate this so ..read more
Learn Powershell | Achieve More
3y ago
Recently, I had the need to pull out all of the hyperlinks from an excel worksheet that was given to me. While I could have gone the manual approach by looking through all of the cells in the worksheet and copying all of the hyperlinks out manually, that would have been a long grueling thing to do.
PowerShell fortunately gives me all of the ammo I need by allowing the use of COM object creation to hook into the Excel.Application COM object and then open up an existing Excel document and locate all of the hyperlinks which are in the spreadsheet. Automation will always be better than manual if g ..read more