Showing archive results for 2018

May 9, 2018
Post comments count3
Post likes count0

Get certificate info into a CSV by using PowerShell

Doctor Scripto

Summary: Certificate management is always challenging. Let’s explore how to use PowerShell to export local certificate information to a comma-separated values (CSV) file on Windows 7 (or later) computers. Q: Hey, Scripting Guy! How can I get all my certificate info into a CSV on my Windows computers? —SH A: Hello SH, Patrick Mercier here, with...

Scripting Guy!Windows PowerShellguest blogger
May 8, 2018
Post comments count0
Post likes count1

Grabbing Excel (XLSX) values with PowerShell

Kory Thacher

The Goal: Import data from XLSX files conveniently like import-csv lets you do with simpler data. The preamble: Excel is a mainstay of the business world at this point, which means a lot of the data you might have to work with will come at you as an XLSX file or need to be one. This can be a bit annoying when scripting. If we're just workin...

Microsoft ExcelPowerShellkoryt
Apr 24, 2018
Post comments count0
Post likes count0

Doing More With Functions: Comment-Based Help

Kory Thacher

I just wanted to throw together a post highlighting how cool and easy it is to add help data to your own Functions and scripts. The help data gets added via comments. For functions the help data can go in three places: For scripts we just put it at the top of your script before you type the param() statement, or at the bottom, b...

korytKory Thacher
Apr 10, 2018
Post comments count0
Post likes count0

Inserting new elements into XML files

Kory Thacher

The Goal: Insert nodes into a specific place in XML config files The Motivation: I had a coworker a while back working with App Fabric. He needed to insert a particular chunk of XML into a specific spot inside of the config file. This had to be done on a bunch of different machines, but the kicker was that the config files might look different ...

korytKory Thacher