PS C:\WINDOWS\system32> invoke-command -ScriptBlock{hostname}
Slim
PS C:\WINDOWS\system32> get-pssession
PS C:\WINDOWS\system32> invoke-command -ComputerName SOTINY -Credential $cred -ScriptBlock{hostname}
SOTINY
PS C:\WINDOWS\system32> get-pssession
PS C:\WINDOWS\system32>

PS C:\WINDOWS\system32> get-pssession
PS C:\WINDOWS\system32> $sess = new-pssession -computername sotiny -credential $cred
PS C:\WINDOWS\system32> get-pssession

 Id Name            ComputerName    ComputerType    State         ConfigurationName     Availability
 -- ----            ------------    ------------    -----         -----------------     ------------
  5 WinRM5          sotiny          RemoteMachine   Opened        Microsoft.PowerShell     Available


PS C:\WINDOWS\system32> invoke-command -Session $sess -ScriptBlock {hostname}
SOTINY
PS C:\WINDOWS\system32> $sess | remove-pssession
PS C:\WINDOWS\system32> get-pssession
PS C:\WINDOWS\system32>

PS C:\WINDOWS\system32> $sess = new-pssession -computername sotiny -credential $cred
PS C:\WINDOWS\system32> enter-pssession $sess
[sotiny]: PS C:\Users\Happiness Commando\Documents> hostname
SOTINY
[sotiny]: PS C:\Users\Happiness Commando\Documents> exit-pssession
PS C:\WINDOWS\system32> get-pssession

 Id Name            ComputerName    ComputerType    State         ConfigurationName     Availability
 -- ----            ------------    ------------    -----         -----------------     ------------
  6 WinRM6          sotiny          RemoteMachine   Opened        Microsoft.PowerShell     Available


PS C:\WINDOWS\system32> get-pssession |remove-pssession
PS C:\WINDOWS\system32>

Happiness Commando fucked around with this message at 19:50 on Nov 25, 2021

Inspector_666 fucked around with this message at 06:53 on Nov 27, 2021

Submarine Sandpaper fucked around with this message at 22:19 on Feb 6, 2022

using namespace System.Collections.Generic
$TypeDef = @"
using System.Collections.Generic;
public class Purchase
{
    public int Order {get; set;}
    public double Shipping {get; set;}
    public double Taxes {get; set;}
    public double Subtotal => Total - Shipping - Taxes;
    public double Total {get; set;}
}
"@
Add-Type -TypeDefinition $TypeDef

$Purchases = [Dictionary[[int],[Purchase]]]::new()

Import-Csv -Path $Path | ForEach-Object {
    $order = $_.order
    if ($null -eq $Purchases[$order])
    {
        $Purchases[$order] = [Purchase]::new()
    }
    $Purchases[$order].Order = $order
    $Purchases[$order].Shipping = $_.Shipping
    $Purchases[$order].Taxes = $_.Taxes
    $Purchases[$order].Total += $_.Transact
}

using namespace System.Collections.Generic
$TypeDef = @"
using System.Collections.Generic;
public class Purchase
{
    public int Order {get; set;}
    public double Shipping {get; set;}
    public double Taxes {get; set;}
    public double Subtotal => Total - Shipping - Taxes;
    public double Total {get; set;}

    public Purchase (int order, double shipping, double taxes)
    {
        Order = order;
        Shipping = shipping;
        Taxes = taxes;
    }
}
"@
Add-Type -TypeDefinition $TypeDef

$Purchases = [Dictionary[[int],[Purchase]]]::new()

Import-Csv -Path $Path | ForEach-Object {
    if ($null -eq $Purchases[$_.Order])
    {
        $Purchases[$_.Order] = [Purchase]::new($_.Order, $_.Shipping, $_.Taxes)
    }
    $Purchases[$_.Order].Total += $_.Transact
}

Toast Museum fucked around with this message at 23:57 on Feb 9, 2022

SELECT * FROM Shareddrives.xlsx INNER JOIN Users.xlsx ON Shareddrives.xlsx.owner1 = Users.xlsx.username

$users = import-csv users.csv
$shareddrives = import-csv shareddrives.csv
$output = @{}

$users | % {
    $username = $_.username
    $shareddrives | % {
        if ($username -eq $_.owner1){
            $owner = $_.owner1
         } 
         if ($username -eq $_.owner2){
            $owner = $_.owner2
         }
         $output.add($_.sharepath, $owner)
    }
     
}
$output | export-csv -path c:\shareddriveowners.csv

Happiness Commando fucked around with this message at 05:31 on Mar 2, 2022

$Users = Import-Csv -Path "Path\To\Users.csv"
$SharedDrives = Import-Csv -Path "Path\To\SharedDrives.csv"

foreach ($Drive in $SharedDrives)
{
    Add-Member -InputObject $Drive -MemberType NoteProperty -TypeName [string[]] -Name "Owners" -Value $Drive.Owner1, $Drive.Owner2, $Drive.Owner3 # etc.
}

foreach ($User in $Users)
{
    $OwnedDrives = $SharedDrives | Where-Object Owners -Contains $User.Username | Select-Object -ExpandProperty DriveName
    Add-Member -InputObject $User -MemberType NoteProperty -TypeName [string[]] -Name "OwnedDrives" -Value $OwnedDrives
}

Export-Csv -InputObject $Users -Path "Path\To\Users.csv"

foreach ($Drive in $SharedDrives)
{
    $Owners = $Drive.PSObject.Properties | Where-Object {$_.Name -match '^Owner[0-9]+$'} | Select-Object -ExpandProperty Value
    Add-Member -InputObject $Drive -MemberType NoteProperty -TypeName [string[]] -Name "Owners" -Value $Owners
}

Toast Museum fucked around with this message at 22:54 on Mar 2, 2022

Happiness Commando fucked around with this message at 19:28 on Mar 11, 2022