Clatent

Technology | Fitness | Food

PowerShell

Read-Only Friday February 17, 2023

by Leave a Comment

It’s been a little bit for a Read-Only Friday, and need your input. Do you like the 3 days of smaller posts, or would you rather have one more in depth post a week, possibly every 2 weeks? They would be targeted to real life examples using PowerShell or scenarios in IT and how to best handle them. Would love your feedback and feel free to message me if you rather not put it in here!

Remember, no major unplanned changes today unless mission critical! And might be a good day to review your documentation to make sure it is up date or anyway you can improve it!

One-Liner Wednesday February 15, 2023

by Leave a Comment

I’m just going to cut to the chase on this one..

 copilot "How to filter ID column not being empty and if it isn't empty it starts with a number and the other column named sideindicator having a r in it using powershell and importexcel and both criteria must be true?"
╔═════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════╗
║Q: How to filter ID column not being empty and if it isn't empty it starts with a number and the other column named sideindicator having a r in it using powershell and importexcel and both criteria must be true?  ║
║═════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════║
║1: $data = Import-Excel -Path "C:\Path\To\File.xlsx"                                                                                                                                                                 ║
║2: $data | Where-Object {$_.ID -and $_.ID -match '^\d' -and $_.SideIndicator -eq 'r'}                                                                                                                                ║
╚═════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════╝

How about that? Nice little RegEx in there too! Yes this does work, as I used it this morning for a real life solution.

Download Doug Finke’s PowerShellAI module, get your OpenAI API key, and start having some fun! And if for some reason you still haven’t downloaded his ImportExcel module get that too! And want to hear a little more about Doug, check him out on the PowerShell Podcast and find out how ImportExcel is created.

That’s enough for today, I don’t want to take away your time from playing with this!

PowerShell Gallery:
PowerShellAI

GitHub:
PowerShellAI

Module Monday February 13, 2023

by Leave a Comment

It’s Monday after the Super Bowl so we are going to keep this lite.  Today’s module isn’t business related at all, unless your in the Lego business. It’s a great module that helps you view and maintain your Lego collection. 

With that said, welcome the Brickset Module. I’ve already been playing with it and really like it. I was initially going to make my own, but I rather use his as a base and expand off of it.

If you already have your collection in a csv or xlsx it makes it super easy to add them in, instead of going to the website to add them each. If you already have a brickset account and an excel sheet? I’m working on a script to compare and sync between the two.

Any option on the Brickset website can be done in the module, see how many pieces or mini figs you have, see only certain themed sets, and even pulling instructions for sets you have!

Hope this makes your Lego experience even more fun and you get to learn/practice PowerShell skills while playing with it!

I’ll be working on some dashboards too in the near future. Any certain things you want to see?

GitHub:

https://github.com/jonathanmedd/BricksetModule

One-Liner Wednesday February 8, 2023

by Leave a Comment

This week’s One-Liner is brought to you by no other than Steve Lee. I can’t take credit for it, but want to make sure others see it. The only caveat is that it needs to be run in an elevated session.

Invoke-Expression "& { $(Invoke-RestMethod 'https://aka.ms/install-powershell.ps1') } –useMSI -Quiet"

It does what you think it does… installs PowerShell 7, using the MSI and silently. I’ve used it before many times and works great. There are also many other switches you can which I’ve linked to the GitHub below.

A few are:
Daily
DoNotOverwrite
AddtoPath
Preview

Try it out, and let me know what you think!

GitHub:
One-Liner

Module Monday February 6, 2023

by 2 Comments

Monday, already? Yup, but at least you get a new Module Monday today. This is one is for anyone who does any broadcasting, whether live or pre recorded. I’ve barely even touched the surface of what you can do with it, but with this module you can really get your feet wet. To give you an idea, it has a command for every websocket request!

With that said, OBS-PowerShell is the module you need to download, either from the PowerShell Gallery or from James’ Github and I’ll have links below for each.

This does more than just push start and stop for you, you can see all available inputs, get all of your stats, and you can even set the input audio balance! With this module, I can’t do it justice, but as mentioned before if you do any broadcasting and use PowerShell, definitely check it out! Let me know how you find it useful. I’ll be doing a follow up on this module in the future when I have more hands on time with it and I’ll add your input too!

PowerShell Gallery:
OBS-PowerShell

GitHub:
OBS-PowerShell

Module Monday January 30, 2023

by Leave a Comment

We are back, and hope you had a great weekend! Today’s module is one Jeff Hicks had told me about last week and I started playing with it. It’s a neat module that makes managing your tasks easy. His module is called PSWorkItem.

It allows you to create predefined categories with a description, that you can add your tasks too. You can even set the default category so that you don’t have to keep on typing the category name for each task for your primary category. The categories can highlighted in the color of your choosing if you need that feature. Another great feature is that you can input due dates and view tasks by a numnber of different filters. There is an option to put percentage complete which can be very useful if you have certain milestones for your code, and once you reach it you could have it automatically update PSWorkItem for you.

If you are looking for a simple task list that gets the job done, I highly recommend this, especially since you can easily integrate it into your coding. I know there are other ways, but you could even create a template of tasks that need to be completed for a project, then link that project so that after each task is run successfully, it automatically completes it for you.

I know Jeff has a future task of making it so you can use it with a WPF or TUI, but I’d also love to see it integrated with PowerShell Universal.

GitHub:
PSWorkItem