Background About a year ago I started writing things to Excel with PowerShell, based on the information I found on an MSDN blog - Create Excel file with PowerShell I wasn’t quite satisfied, though. I wanted some more formatting (specifically: change the top row behavior). It was somewhat frustrating to not be able to get … Continue reading Writing to Excel
Just to let you know: I just got myself a domain name for my blog. From now on, this blog can be found on http://powershelladministrator.com.
The Get-Date cmdlet is pretty nifty and gives you a lot of date/time formats you'd want to use in your script. Like if you were to save files with a unique stamp, you'd want a date/time format like <year><month><day><hour><minute><second> Here are some examples to achieve this goal, with outputs Get-Date -Format s 2015-11-19T20:22:35 (Get-Date -Format s).Replace("-","").Replace(":","").Replace("T","") … Continue reading Get-Date
Create Windows scheduled task (for the NppUpdater script) The previous NppUpdater script doesn't do anything without it being scheduled in the task scheduler. So I thought I also release a script to you, which does just that. If you add the code in this script to the NppUpdater script, it'll also create the scheduled task … Continue reading Create Windows scheduled task (for the NppUpdater script)
I love to use Notepad++ (npp), but I also have npp installed on servers on which users can log on, but don't have administrative privileges. They also love to use npp, but with the updater enabled, they get popup messages for the updates, but cannot install them. I don't want to have to check all servers that I … Continue reading Notepad++ downloader and updater
Background: A while ago, I stumbled upon two blogs about speed and PowerShell. First Guillaume Bordier’s blog about PowerShell and writing files. And second there was IT Idea’s Blog on PowerShell Foreach vs ForEach-Object. While researching the matter, I also came across an article on PowerShell.com about speeding up loops (which wasn't of use in … Continue reading Speed of loops and different ways of writing to files – Which is the quickest?
I've got a nice solar panel setup on my roof, which uploads its data to the SolarEdge monitoring portal (this is the brand of inverter that I got). It appeared that this monitoring portal also has an API to automate getting the energy data. With me working in a company that works on energy savings, … Continue reading Download SolarEdge solar production data and save to csv
It has been an while since I posted an update. It's been pretty busy at work (mostly powershell related, thus a lot of fun to do) and have been busy working on several scripts to automate my work. Some of them I will also share here, like this nice little script to validate an e-mail … Continue reading E-mail address checker