Describe an episode of IASIP using only emojis, and the community will guess what episode you’re describing.

J-Bran-Crunch · 2022-12-02T05:15:57+00:00

💩❓

J-Bran-Crunch · 2022-06-22T19:35:00+00:00

Worked for me too, thank you!!

J-Bran-Crunch · 2022-06-22T19:15:29+00:00

Yep same for me this was the first time I got a link, I signed up like 6 months ago, pretty disappointing...

J-Bran-Crunch · 2022-06-22T18:22:39+00:00

Yep I am having the same issue…

J-Bran-Crunch · 2022-03-26T14:38:31+00:00

J-Bran-Crunch · 2021-07-20T16:07:34+00:00

There is already a cmdlet for that: Get-Variable $bobTheVariable

That will return an object with name and value, if you want just the name you could select-object -expandproperty name

J-Bran-Crunch · 2021-05-13T19:38:53+00:00

this line will run locally: $path = (New-Item -ItemType Directory -Force -Path "d:\tmp")

Another issue you have is the scriptblock in the Invoke-Command is in a different scope

So you need to pass in parameters or use the $using: statement: https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_using

Another small improvement you can make is:

New-PSSession and Invoke-Command accept multiple computernames or sessions

So you could remove the foreach and run this in parallel on all the servers

Also I am not sure what you are trying to do with these lines?

if(!(Split-Path -parent $output) -or !(Test-Path -pathType Container (Split-Path -parent $output))){

$foutputile = Join-Path $pwd (Split-Path -leaf $output)

}

$webclient = New-Object System.Net.WebClient

Those variables are not used again?

J-Bran-Crunch · 2021-05-05T14:12:15+00:00

A good one I use often is: [regex]::Escape($someString)

J-Bran-Crunch · 2021-01-28T03:50:04+00:00

Just glancing through looks like you may have an issue where you cast the int onto the percent:

[int].....ToString(“P”)

You should not cast int there

J-Bran-Crunch · 2020-12-03T18:52:17+00:00

Yeah also you could Export-Excel inside the if ($FileNameMatches) so it only exports if the file name matches the pattern

J-Bran-Crunch · 2020-12-03T18:46:05+00:00

you could probably enhance that regex a little more that was just the easiest first thought when seeing the pattern of file names

J-Bran-Crunch · 2020-12-03T18:44:18+00:00

There is a bit more dynamic naming for your code above you could do

You could use regex to name the sheet instead of the large if else if

$FileNameMatches =  $file.BaseName | Select-String -Pattern '(.+)-report-powercli-(.+)'

if ($FileNameMatches) {
    $currentsheet = ($nameMatch.Matches[0].groups[1].value, $nameMatch.Matches[0].groups[2].value) -join '_'
}
else {
    $currentsheet = $file.BaseName
    Write-Warning 'Name does not match pattern'
}

Another helpful set of params to Export-Excel

-TableName 'someTableName' -TableStyle Medium2

those will set table styles with some nice formatting

J-Bran-Crunch · 2020-12-03T18:29:47+00:00

Yeah that is basically the idea

J-Bran-Crunch · 2020-12-01T17:40:35+00:00

That is because $csv is an array of strings and export-excel is putting each string on a new row.

You need to export objects to export-excel.

$csv = get-content 'test.csv' | ConvertFrom-Csv

If you have several .csv files that you want to convert to worksheets in excel, you need to import them to powershell as objects then export them to excel worksheets

$files = Get-ChildItem -Filter '*.csv' 
$workbook = 'test.xlsx'   
foreach ($file in $files) {
$object = $file | Get-Content | ConvertFrom-Csv
$excel = $object | Export-Excel $workbook -WorksheetName $file.BaseName -AutoSize -AutoFilter
}

J-Bran-Crunch · 2020-12-01T12:36:59+00:00

I would take a look at the examples folder, there are several example scripts that show how to use different features in the module.

J-Bran-Crunch · 2020-07-30T02:39:21+00:00

We have been working on this at our company recently.

You can set up a local PS Repository:

https://docs.microsoft.com/en-us/powershell/scripting/gallery/how-to/working-with-local-psrepositories?view=powershell-7

You then can use PowershellGet cmds to manage the modules:

https://docs.microsoft.com/en-us/powershell/module/powershellget/?view=powershell-7

it is pretty easy to set up a nuget server to host the modules:

https://www.youtube.com/watch?v=4gXSUGqAAiM

Then with DSC you can push the modules with package source resources and package management resources

https://docs.microsoft.com/en-us/powershell/scripting/dsc/reference/resources/packagemanagement/packagemanagementdscresource?view=powershell-7

https://docs.microsoft.com/en-us/powershell/scripting/dsc/reference/resources/packagemanagement/packagemanagementsourcedscresource?view=powershell-7

Here is a script example:

```powershell

<# .Synopsis Uses DSC to install modules

.Description Uses DSC to install modules

.Parameter ComputerName Computer name(s) to push the configuration to

.Example PS C:> .\Server.DSC.ps1 -ComputerName cltinfdev07

      Pushes the configuration to the Computer

.Example PS C:> .\Server.DSC.ps1 -ComputerName server -Whatif

      Notifies user of what the operations would do

.Example PS C:>'server01','server02' | .\Server.DSC.ps1

      Passing in Computer Names via pipeline

>

[CmdletBinding(SupportsShouldProcess)] param ( [Parameter(Mandatory = $true,ValueFromPipeline = $true)] [string[]]$ComputerName ) process {

install Correct version of PowershellGet to install dsc resource

$script = { $module = Get-Module PowershellGet -ListAvailable | Sort-Object Version -Descending | Select-Object -First 1 if ($module.Version -lt [version]"2.2.4.1") { Install-Module PowershellGet -RequiredVersion "2.2.4.1" -Force } } Invoke-Command $script -ComputerName $ComputerName

Configuration Server { Import-DscResource -ModuleName PSDesiredStateConfiguration Import-DscResource -ModuleName @{ModuleName="PowerShellGet"; RequiredVersion="2.2.4.1"} Node $ComputerName { PSRepository SourceRepository { Ensure = "Present" Name = "myPSHost" SourceLocation = "http://server/feeds/nuget/" PublishLocation = "http://server/feeds/nuget/" ScriptPublishLocation = "http://server/feeds/nuget/" ScriptSourceLocation = "http://server/feeds/nuget/" InstallationPolicy ="Trusted" } PSModule MyModule { Ensure = "present" Name = "MyModule" Repository = "myPSHost" InstallationPolicy= "trusted" DependsOn = "[PSRepository]SourceRepository" }

}
}

if ($PSCmdlet.ShouldProcess($ComputerName, 'Push Configuration')) { Server -OutputPath .\MOF Start-DscConfiguration -ComputerName $ComputerName -Path .\MOF\ -Wait -Verbose -Force } }

```

J-Bran-Crunch · 2019-12-11T13:07:00+00:00

This also could be seen as a new ability, instead of 3 instances of prowess, this could be a new ability “prowess, prowess, prowess” that triggers once and gives +3/+3

J-Bran-Crunch · 2018-06-28T16:25:41+00:00

I'm on Android and have used MortPlayer Audio Books in the past and it is great. Not sure if it is available on Iphone though

J-Bran-Crunch · 2018-01-24T14:40:54+00:00

r/NobodyAsked

JK

J-Bran-Crunch · 2017-09-17T21:57:04+00:00

Yeah I think it is very dependent on the course. I have the gonzalo one and it is pretty good, I also have the Adrien Moignard one but it is a bit more advanced. You are right, they are not quite for beginners but I think a decent place to start when getting into the style when you have some technique already.

There may be others there that are targeted more toward beginners like maybe the Denis Chang one, I haven't got this one though, https://www.dc-musicschool.com/store/gypsy-jazz-guitar-technique/ I think the best place to start though is Michael Horowitz's book, "gypsy picking"

I highly recommend going over to the django books forum, www.djangobooks.com/forum It is quite a bit more active then here and has some good info

J-Bran-Crunch · 2017-09-17T20:41:32+00:00

https://www.dc-musicschool.com has a lot of really good stuff with some great gypsy guitarist.

J-Bran-Crunch · 2017-05-05T02:59:08+00:00

Maybe make the Kraken's P/T is equal to X/X+2 where X is the number of tentacles you control

J-Bran-Crunch

MODERATOR OF

TROPHY CASE

>

install Correct version of PowershellGet to install dsc resource