dsolodow

Function Start-Elevated {
       [CmdletBinding()]
    Param (
        [parameter(Mandatory = $true,ValueFromPipeline=$true,Position=0)] [String]$FilePath,
        [parameter(Mandatory = $false,ValueFromRemainingArguments=$true,Position=1)] [String[]]$ArgumentList
    )
       Start-Process -verb RunAs @PSBoundParameters
}
New-Alias -Name 'sudo' -Value 'Start-Elevated'

dsolodow

use CM_PRI
SELECT LP.DisplayName,
CP.CI_ID,
CPS.PkgID,
CPS.ContentSubFolder
FROM dbo.CI_ContentPackages CPS
INNER JOIN dbo.CIContentPackage CP
ON CPS.PkgID = CP.PkgID
LEFT OUTER JOIN dbo.CI_LocalizedProperties LP
ON CP.CI_ID = LP.CI_ID

dsolodow

Get-InstalledModule | 
    ForEach-Object {
    $CurrentVersion = $PSItem.Version
    Get-InstalledModule -Name $PSItem.Name -AllVersions | 
        Where-Object -Property Version -LT $CurrentVersion
} | Uninstall-Module -Verbose

dsolodow

# blank prompt
set fish_greeting

# Colors:
set fish_color_normal F8F8F2 # the default color
set fish_color_command F92672 # the color for commands
set fish_color_quote E6DB74 # the color for quoted blocks of text
set fish_color_redirection AE81FF # the color for IO redirections
set fish_color_end F8F8F2 # the color for process separators like ';' and '&'
set fish_color_error F8F8F2 --background=F92672 # the color used to highlight potential errors

dsolodow

Function Get-WheelAnswer
{
    [string[]]$wheel = (
        "No.",
        "Are you sure it's plugged in?",
        "Move... I'll do it",
        "Yes, just click OK",
        "No, it's a scam, just delete it",
        "The problem is on your end.",
        "Yes, it's gone forever, that's what empty trash does.",

dsolodow

<#
Creates a scheduled task to run a daily Update-Help on the local machine
#>
$trigger = New-JobTrigger -Weekly -At "7:30 AM" -DaysOfWeek "Monday"
$option = New-ScheduledJobOption -StartIfOnBattery -RequireNetwork -RunElevated
Register-ScheduledJob -Name UpdateHelp -ScriptBlock {Update-Help -Module * -Force} -Trigger $trigger -ScheduledJobOption $option

dsolodow

$dplog = Get-ItemPropertyValue -Path 'HKLM:\SOFTWARE\Microsoft\SMS\DP\Logging\@GLOBAL' -name LogDirectory
New-SmbShare -Path $dplog -Name DP_LOG
icacls $dplog /grant "domain users:(oi)rx"

dsolodow

<#
.SYNOPSIS
   Creates firewall rules for Teams.
.DESCRIPTION
   (c) Microsoft Corporation 2018. All rights reserved. Script provided as-is without any warranty of any kind. Use it freely at your own risks.
   Must be run with elevated permissions. Can be run as a GPO Computer Startup script, or as a Scheduled Task with elevated permissions.
   The script will create a new inbound firewall rule for each user folder found in c:\users.
   Requires PowerShell 3.0.
#>

dsolodow

Register-EditorCommand -Name SignCurrentScript -DisplayName 'Sign Current Script' -ScriptBlock {
    $cert = (Get-ChildItem Cert:\CurrentUser\My -CodeSigningCert)[0]
    $currentFile = $psEditor.GetEditorContext().CurrentFile.Path
    Set-AuthenticodeSignature -Certificate $cert -FilePath $currentFile
}

dsolodow

SELECT gcs.manufacturer0 AS Make
	,IIF(gcs.manufacturer0 = 'Lenovo', gcsp.Version0, gcs.model0) AS Model
	,COUNT(*) AS Count
FROM [CM_XXX].[dbo].[v_GS_COMPUTER_SYSTEM] gcs
INNER JOIN [CM_XXX].[dbo].[v_GS_COMPUTER_SYSTEM_PRODUCT] gcsp ON gcsp.ResourceID = gcs.ResourceID
GROUP BY Manufacturer0
	,CASE 
		WHEN gcs.Manufacturer0 = 'Lenovo'
			THEN gcsp.Version0
		ELSE gcs.Model0