FAQ: Learning PowerShell tips to automate tasks and free up your time

As admins get comfortable with learning PowerShell, questions come up about what tasks it automates to free up time. We answer some of those here.

With 2,300 cmdlets and counting, PowerShell can automate a lot of tasks and free up valuable time for admins. But as admins begin to tackle learning PowerShell, lots of questions come up about specific tasks and actions PowerShell can take care of.

Don Jones, PowerShell expert, answers some of the questions he's heard from administrators learning to harness the features of PowerShell. This short FAQ highlights some of the questions he's answered about specific PowerShell capabilities.

Keep up with the latest tips, news and more on our Windows PowerShell topic page, or follow us on Twitter @SearchWinServer

How can I use PowerShell to read XML files?

PowerShell can load XML contents because XML is essentially just text, but admins will have to create a command that not only loads content, but also forces PowerShell to parse it if you want the XML contents read. The command may look something like this:

[xml]$xml = Get-Content MyXML.xml

Admins will most likely have to experiment in PowerShell to get exactly what they want, but there are many options to add and remove attributes and nodes to eventually create a text file. Admins may also want to consider learning XPath, a XML query language that can search and process specific attributes and nodes within an XML file.

How do I know if I should use PowerShell workflow?

PowerShell workflows are one of the most talked about features, but they're also one of the most confusing features. Similar to a PowerShell function, they can support features not necessarily found in PowerShell itself.

The reason why workflows can be confusing? Workflows lack features found in PowerShell because they are processed through Windows Workflow Foundation (WinWF), which means they follow WinWF rules even though you're using PowerShell syntax.

It has a steep learning curve, but the benefits can make it worth your while. There are many built-in parameters that are useful, plus it has the distinct ability to interrupt and resume, which can accommodate temporary failures like outages.

What are some ways I can make my PowerShell format look better?

Unfortunately, there isn't a simple answer to this question, but there are a few options admins can look into to make it happen.

One approach involves creating a command to convert PowerShell output into HTML that includes links and a title, but the results are pretty simplistic unless you include JavaScript code.

If admins are willing to do a little extra reading, there are a few free e-books available that specifically address this question. Admins can learn how to create HTML-based reports with visual formatting, as well as learn how to use SQL Server Reporting Services to create a heavily formatted report.

This was first published in August 2013

Dig deeper on Windows PowerShell Scripting

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchServerVirtualization

SearchCloudComputing

SearchExchange

SearchSQLServer

SearchWinIT

SearchEnterpriseDesktop

SearchVirtualDesktop

Close