Category: Powershell

• PowerShell Importing Data from Excel

  If you want to import Excel data I recommend giving the people who toke the time to develop this module Import-Excel. It can be Read about on the PSGallery here: https://www.powershellgallery.com/packages/ImportExcel/ After reading we will try to find the module using built im module package for powershell : “find-module importexcel” we can pipe this into…

  September 13, 2020

  · Functions, Learning your way around., Powershell, Scripting Technique

• Convert from OATime

  One of my favorite reasons I love PowerShell is because can tap into its programming roots for added power. I will demonstrate later in my post. Here is why: An OLE Automation date is implemented as a floating-point number whose integral component is the number of days before or after midnight, 30 December 1899, and…

  September 11, 2020

  · Powershell

• Formatting dates from text or objects

  Ever imported data just to have a non readable date stamp? Get-date can take your text that is a date and turn it into something more readable. Take “15-FEB-20” for example. It’s not really a wildly used format. Pipe that to get-date like so: Then you can format your date to remove time and what…

  September 3, 2020

  · Learning your way around., Powershell

• Planning stops the issues from Spanning.

  Planning is vital to any infrastructure environment and when scripting or using PowerShell is by no means any different. when you add a high level plan/structure and use it as a map of to-dos and things you want to add later and things you would like to change. Failure to plan can mean data loss…

  August 19, 2020

  · Powershell

• PowerShell: Convert .ps1 Files to .exe Files

  Have you ever dreamed of creating exe files out of your PowerShell scripts? If yes, read on. In this post I will show you how you can create exe … PowerShell: Convert .ps1 Files to .exe Files

  August 12, 2020

  · Powershell

• Does anyone object?

  Writing scripts and functions we sometimes just want something to do or be one way with one purpose. I have mulled over things and re-coded tools to work with different things. The one thing I find to be the best in every situation is always script or code with objects in mind so that the…

  July 5, 2020

  · Powershell

• Google cloud and the absence of PowerShell.

  I was looking into google cloud to explore some options for a client to leverage some automation elements and was very interested until I learned of the lack of PowerShell support. For the life of me I cannot understand Google’s purpose to neglect populations of individual platforms and still want professionals to take their platform…

  May 27, 2020

  · Powershell

• Mobile PowerShell Needed?

  I have always wanted to get my mittens on a mobile iteration of the prized management tool. I made sure I got a mobile sized tablet that would allow for me to use this on the go. Remote Desktop, Team viewer, Screen connect, VNC just dont respond like a native client. Wouldn’t it be something…

  May 24, 2020

  · Powershell

• VS code ready to replace PowerShell ISE?

  There is a push to go to Visual Studio Code, which is a plug-in rather than the PowerShell.exe having its own dedicated ISE application. It can be seen as smart, others see this as allowing for distractions. I do not like the syntax in the responses of commands, I don’t like the lack of the…

  May 21, 2020

  · Powershell

• Tab-complete Therapy

  There is a special place in my heart for tab-completion. Just invoking it brings peace of mind. There are a lot of people that feel like they are retired school spelling-bee champs. I tend to like the command line validation. It sounds crazy but even when I spell it out all the way it feel…

  May 13, 2020

  · Powershell