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

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 an “install-module” command with a few parameters to ensure a smooth install.

find-module importexcel | install-module -Scope CurrentUser -SkipPublisherCheck

this should install the module and you import Excel workbooks as easily as you can excel and text files.

Import-Excel, Export-Excel with a few extra parameters like -worksheet so you can target data sets and even write reports with details on different pages!

I use this to write share permission reports with different shares on different worksheets. So other things you can do is a security audit on servers and write a server to each worksheet and then write a pivot table for a summary report.

I how you download and support this module because it is nothing short of amazing, you dont have to have the excel application installed to import or export to Excel!

Powershell

Mobile PowerShell Needed?

I have always wanted to get my mittens on a mobile iteration of the prized management tool.

Pocket PowerShell

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 to truly take your scripting on the road with you?!

I believe this is possible now with todays mboile phones and tablets.

Ready to script.

What are your thoughts and your ideal access to management and automation tools?

Uncategorized

AWS/GoogleCloud and harnessing PowerShell (One Shell to rule them all)

Heads up….. The cloud is ready.

There is alot of fun to be had with different Platforms and PowerShell grew up on the mean streets of scrutiny, much like myslef and we are much alike in our flexibility to adapt and automate anything, although I am sure PowerShell probably doesn’t need me as much as I rely on it’s abilities to be context sensitive to my tab key.

Looking at the featured image i used for the article it is clear to see a lot of platforms have embraced PowerShell with a favorable amount of cmdlets. JUST THINK OF THE AUTOMATION POSSIBILITIES!

Okay, so to warn you ahead of time, I maybe diving into all the cloud crowds shortly to give myself an expanse of elbow room when scripting solutions.

Stay informed and do not forget to Get-Help!

This is for amazon webservices:

Install-Module -Name AWSPowerShell

This is for GoogleCloud:

find-module -Name googlecloud | install-moduleĀ 

This may may only possible after you enable and trust the repositories.

Take Care Citizen!