jdhitsolutions

PowerShell Podcast ScriptingChallenge

This is the PowerShell scripting challenge from my appearance on the PowerShell Podcast

Base Challenge

Using whatever tools and techniques you want, write a PowerShell function that will query the Issues section of a GitHub repository and create output showing the number of open issues by label and the percentage of all open issues. Remember that multiple labels may be used with an issue.

For example, if there are 54 open issues and the bug label is used 23 times,your output would show a count of 23 and a total percentage of 42.59 for the bug

jdhitsolutions

PowerShell Lab Detailed Setup Instructions

For my Pluralsight PowerShell courses, you are welcome to use any lab environment you wish. It should include an Active Directory domain with at least a domain controller, a Windows 10 client, and a Windows Server 2016 or 2019 member server. You will need to modify the course files to fit your environment. At this point in time, Windows Server 2022 remains untested for my labs.

However, I am going to recommend that you use a free PowerShell module called PSAutoLab. I encourag you to look at the README document on the project's Github repository before proceeding. If you need help with the module or its commands, you will use the repository's Issue section.

PSAutolab

Please refer to this document to assist in installing and setting up the PSAutolab module on your computer. Run all commands from an elevated Windows PowerShell

jdhitsolutions

# requires -versoin 5.1
# requires -module ActiveDirectory
Function Show-DomainTree {
[cmdletbinding()]
[OutputType("String")]
[alias("dt")]
Param(
    [Parameter(Position = 0, HelpMessage = "Specify the domain name. The default is the user domain.")]
    [ValidateNotNullOrEmpty()]
    [string]$Name = $env:USERDOMAIN,

jdhitsolutions

#requires -version 5.1
#requires -module GroupPolicy,ActiveDirectory

Function Get-GPLink {
<#
.Synopsis
Get Group Policy Object links
.Description
This command will display the links to existing Group Policy objects. You can filter for enabled or disabled links. The default user domain is queried although you can specify an alternate domain and/or a specific domain controller. There is no provision for alternate credentials.

jdhitsolutions

#requires -version 4.0

Function Get-CimNamespace {
[cmdletbinding(DefaultParameterSetName = 'computer')]
Param(
    [Parameter(Position=0)]
    [ValidateNotNullorEmpty()]
    [string]$Namespace = "Root",
    [Parameter(ParameterSetName = 'computer')]
    [ValidateNotNullorEmpty()]

jdhitsolutions

#requires -version 5.0

<#
.SYNOPSIS
    Invoke any T-SQL query against any SQL supported database.
.DESCRIPTION
    This command uses the .NET SqlClient classes to connect to a SQL database and execute any type of query. The default behavior is to use integrated Windows authentication, but you can pass a credential object for a username and password. This works well when run on Linux.

    When you run a SELECT query the command will write a custom object for each row to the pipeline.
.PARAMETER Query

jdhitsolutions

Function Get-PSWho {
  <#
  .SYNOPSIS
  Get PowerShell user summary information
  
  .DESCRIPTION
  This command will provide a summary of relevant information for the current 
  user in a PowerShell session. You might use this to troubleshoot an end-user
  problem running a script or command. The default behavior is to write an 
  object to the pipeline, but you can use the -AsString parameter to force the

jdhitsolutions

#requires -version 5.0
#requires -module nettcpip,cimcmdlets

<#
This script will generate a WPF form to display network adapter
information. It will automatically refresh every 30 seconds.
You can change the interval then click the Update button.
I don't recommend refreshing any faster than 10 seconds. It can take almost
5 seconds to get all the network adapter information.

jdhitsolutions

#requires -version 4.0

#search WMI for a class
Function Find-CimClass {
    [CmdletBinding()]
    [OutputType([Microsoft.Management.Infrastructure.CimClass])]

    Param(
        [Parameter(Position = 0, Mandatory, HelpMessage = "Enter the name of a CIM/WMI class. Wildcards are permitted.")]
        [ValidateNotNullOrEmpty()]

jdhitsolutions

#the folder size includes hidden files

Function Get-FSOFolderSize {
[cmdletbinding()]
[OutputType("PSCustomObject")]

param(
[Parameter(Position = 0, Mandatory, HelpMessage = "Enter a filesystem path like C:\Scripts. Do not specify a directory root.")]
[ValidateNotNullOrEmpty()]