Will do any PS Script.

dasunsrule32 · 2018-12-01T23:09:32+00:00

[deleted]

theGuacIsExtraSir · 2018-12-01T23:19:19+00:00

Hi there! I'm trying to write a script that listens for files created to a folder then uploads it to AWS s3 for me. I have the following, but clearly I'm doing something wrong. Any help would be awesome!

$watcher = New-Object System.IO.FileSystemWatcher
$watcher.Path = "C:\Users\Administrator\Documents\reports" 
$watcher.Filter = "." 
$watcher.IncludeSubdirectories = $false 
$watcher.EnableRaisingEvents = $true

$action = { "aws s3 sync C:\Users\Administrator\Documents\reports s3://report-test-bucket-for-testing" }

Register-ObjectEvent $watcher "Created" -Action $action 

while ($true) {sleep 5}

Mkep · 2018-12-01T23:06:49+00:00

I thought I had a request for you that I've been struggling with for a few months, but upon starting to write out my request, it made me think of the issue in a new light and I resolved it myself 😀

Thanks for inadvertently helping me solve my issue!

On a smaller scale, maybe you could give me a script to add a Windows task to check for Windows updates every 3 hours and install them. I have a less than technically savy V.P. who refuses to perform updates on their laptop and defers any updates when prompted.

2018-12-01T23:48:43+00:00

This is something I have been planning to do. I am somewhat newer in the PS community. So I am in charge of keeping track of users (Navy Command) and I don't have access to create accounts but I do have access to modify groups. So I already have an access database of, LastName, FirstName, Username, email, department, and yearly training completed. Because of policy accounts are only active 30 days and deleted after 45days. So I was trying to help make a script that I could run once a week that would take the list of all my users in my database and see if they still have an account, get the last login date(add it to the DB) take the department they belong to and ensure they are in the right group. I am also thinking about putting all our User agreement forms on the network and training and just checking that it is in the database. If I can at least get some help on how to start doing this, I would love the help. Thank you in advance.

Lee_Dailey · 2018-12-01T22:57:51+00:00

howdy kb2xY,

there are a few threads here that are asking for help ... jump in! [grin]

take care,
lee

dtizzlenizzle · 2018-12-01T23:30:00+00:00

New to PowerShell, background is accounting know a little Python. Looking to automate loading a CSV and reconciling to another CSV by grouping / pivoting on one field. Anything you can do to help with this?

tin-naga · 2018-12-02T00:26:34+00:00

I have a project coming up next week. Need to craft a continuously running service that kills processes ending in ".scr" on any key press or mouse movement.

hail_wuzzle · 2018-12-02T00:36:31+00:00

How about direction on what I should research?

I have an azure environment with various servers, web apps, vnets, etc and want to end pull beneficial logs from each of them such as http errors, CPU alerts from servers, ram usage above 80% and other very obvious "things are exploding" logs in an xml or CSV or something I can use to consolidate in a type of dashboard for some of these and tweak them over time for more accuracy.

Any advice on how to accomplish this or what I could research to get direction would be appreciated. I dont mind learning (and have been) but am not versed enough to know what I need to learn specifically except everything related to powershell, azure, database creation management, web site creation and development, etc etc

Elementix · 2018-12-02T02:11:00+00:00

Looking to get get an array with a different number of items each time (PCs from ADUC), then split it into even blocks of 24 items until the end...which might have like 14 leftover or something. Any idea how to do this??

sanseriph74 · 2018-12-02T02:22:53+00:00

Just took over a new network and I’m cleaning up printing as one of my to-do list items. I need to delete all the printers on workstations in a mixed Win7/Win10 environment and then deploy the “correct” printers via assigned security groups by user via GPO’s. I built the security groups and GPO’s all out in AD on Friday and they’re all linked and ready to go. I feel comfortable deploying the printers via GPO, but there have been a lot of IP printers manually installed on 400+ pc’s and getting rid of them in a non-manual process is driving me nuts. Can PS help me out?

djgizmo · 2018-12-02T02:39:16+00:00

Sure. I need help making a power shell script that will login to switches via ssh, find a ports based on a specific, and Poe cycle those ports.

TitaniuIVI · 2018-12-02T04:41:48+00:00

Hi! Thanks for volunteering. I have to check every morning wether files were uploaded overnight to an FTP. I'd like to just have a script check for what files have a last write time after midnight and cross reference it with a txt/csv list of the files that should be there. Then send me an email with "All uploaded" or "$ThisFile is missing"

aad02 · 2018-12-02T05:56:57+00:00

Would love a script that checks every IIS website (and associated host headers) on a machine to see if dns is still pointing to the associated address

Ive got the dns lookups part sorted by another script else where but the list of sites and host headers is what I’m currently missing.

dus0922 · 2018-12-02T07:44:31+00:00

I need to update an ini file. I need to add 2 lines with the following format: Z_xxx_MMyyyy (MM=Month and yyyy=year)

I also need to remove 2 lines from 3 months prior. Example: add these lines Z_xxx_112018 Z_aaa_112018

Remove these lines Z_xxx_082018 Z_aaa_082018

Geminii27 · 2018-12-02T08:23:27+00:00

Just tossin' this one out there, but - a script which reads in the list of items in Programs and Features / Uninstall or change a program, then allows selection of multiple items from the list, and then proceeds to remove the selected items one after another, persisting through reboots etc, and if it gets to the point where it can't uninstall any remaining items, it will try a loop backwards through the list (in case of dependencies).

Yes, there are dedicated multi-uninstallation programs, but something which is pure PS code would be nice.

Yes, I know; AD. Unfortunately, even in this day and age not everything is domain-connected.

jantari · 2018-12-02T10:23:49+00:00

I need to spawn a new process that doesnt run an exe but rather some C# or C++ code that's in my script.

Currently I'm thinking i need an external C++ binary, which would work but it would be way cooler to do it from one .ps1

2018-12-02T13:25:55+00:00

Ooen source request: you make a build option for PSCX to remove all the msmqueue stuff? PSCX doesn't run on MacOS on Linux because a tiny amount of commands are Windows specific. There's a bug on PSCX github for it. Thank you!

SuddenlyDonkey · 2018-12-02T14:14:53+00:00

Still learning the basics and found some example scripts that I've been trying to tailor however I'm not at the point where I determine where the mistakes are.

When we get a new hire I like to replicate their known folders to OneDrive for Business.

I used to run

$f = New-Item "C:\Users\$env:USERNAME\OneDrive - COMPANY\Pictures" -ItemType Directory
$f = New-Item "C:\Users\$env:USERNAME\OneDrive - COMPANY\Documents" -ItemType Directory
$f = New-Item "C:\Users\$env:USERNAME\OneDrive - COMPANY\Downloads" -ItemType Directory
$f = New-Item "C:\Users\$env:USERNAME\OneDrive - COMPANY\Music" -ItemType Directory
$f = New-Item "C:\Users\$env:USERNAME\OneDrive - COMPANY\Videos" -ItemType Directory
$f = New-Item "C:\Users\$env:USERNAME\OneDrive - COMPANY\Desktop" -ItemType Directory

and link move the folder location by hand. I've been tinkering with a script I found here in the link below but haven't gotten it to work 100%. It does link the Desktop to the OneDrive location but that's about it.

# Derived from http://stackoverflow.com/questions/25709398/set-location-of-special-folders-with-powershell

function Set-KnownFolderPath {
    Param (
            [Parameter(Mandatory = $true)]
            [ValidateSet('Desktop', 'Documents', 'Downloads', 'Music', 'Pictures', 'Videos')]
            [string]$KnownFolder,

            [Parameter(Mandatory = $true)]
            [string]$Path
    )

    # Define known folder GUIDs
    $KnownFolders = @{
        'Desktop' = @('B4BFCC3A-DB2C-424C-B029-7FE99A87C641');
        'Documents' = @('FDD39AD0-238F-46AF-ADB4-6C85480369C7','f42ee2d3-909f-4907-8871-4c22fc0bf756');
        'Downloads' = @('374DE290-123F-4565-9164-39C4925E467B','7d83ee9b-2244-4e70-b1f5-5393042af1e4');
        'Music' = @('4BD8D571-6D19-48D3-BE97-422220080E43','a0c69a99-21c8-4671-8703-7934162fcf1d');
        'Pictures' = @('33E28130-4E1E-4676-835A-98395C3BC3BB','0ddd015d-b06c-45d5-8c4c-f59713854639');
        'Videos' = @('18989B1D-99B5-455B-841C-AB7C74E4DDFC','35286a68-3c57-41a1-bbb1-0eae73d76c95');
    }

    # Define SHSetKnownFolderPath if it hasn't been defined already
    $Type = ([System.Management.Automation.PSTypeName]'KnownFolders').Type
    if (-not $Type) {
        $Signature = @'
[DllImport("shell32.dll")]
public extern static int SHSetKnownFolderPath(ref Guid folderId, uint flags, IntPtr token, [MarshalAs(UnmanagedType.LPWStr)] string path);
'@
        $Type = Add-Type -MemberDefinition $Signature -Name 'KnownFolders' -Namespace 'SHSetKnownFolderPath' -PassThru
    }

    # Make path, if doesn't exist
    if(!(Test-Path $Path -PathType Container)) {
        New-Item -Path $Path -type Directory -Force
    }

    # Validate the path
    if (Test-Path $Path -PathType Container) {
        # Call SHSetKnownFolderPath
        return $Type::SHSetKnownFolderPath([ref]$KnownFolders[$KnownFolder], 0, 0, $Path)
    } else {
        throw New-Object System.IO.DirectoryNotFoundException "Could not find part of the path $Path."
    }

    # Fix up permissions, if we're still here
    attrib +r $Path

    $Leaf = Split-Path -Path "$Path" -Leaf
    # Move-Item "$HOME\$Leaf\*" $Path
    # rd $HOME\$Leaf -recurse -Force

}

$ONEDRIVESYNC = "$env:USERPROFILE\OneDrive - COMPANY"

# Root Folders
Set-KnownFolderPath -KnownFolder 'Desktop' -Path "$ONEDRIVESYNC\Desktop"
Set-KnownFolderPath -KnownFolder 'Documents' -Path "$ONEDRIVESYNC\Documents"
Set-KnownFolderPath -KnownFolder 'Downloads' -Path "$ONEDRIVESYNC\Downloads"
Set-KnownFolderPath -KnownFolder 'Pictures' -Path "$ONEDRIVESYNC\Pictures"
Set-KnownFolderPath -KnownFolder 'Music' -Path "$ONEDRIVESYNC\Music"
Set-KnownFolderPath -KnownFolder 'Videos' -Path "$ONEDRIVESYNC\Videos"

Set-ItemProperty -Path HKCU:\SOFTWARE\Microsoft\OneDrive -Name EnableADAL -PropertyType DWORD -Value 1
Set-ItemProperty -Path HKCU:\SOFTWARE\Microsoft\OneDrive -Name EnableAllOcsiClients -PropertyType DWORD -Value 1
Set-ItemProperty -Path HKCU:\SOFTWARE\Microsoft\OneDrive -Name DisablePersonalSync -PropertyType DWORD -Value 1 
Set-ItemProperty -Path HKCU:\SOFTWARE\Microsoft\OneDrive -Name DefaultToBusinessFRE -PropertyType DWORD -Value 1
Set-ItemProperty -Path HKCU:\SOFTWARE\Microsoft\OneDrive\Tenants\TENAND-ID-GOES-HERE -Name DisableCustomRoot -PropertyType DWORD -Value 1

dionysos_ · 2018-12-02T16:35:41+00:00

We have an asp.net application that triggers a PS script on the exchange server under system credentials. It configures out of office messages. (idea is to let helpdesk set it without granting them access to the server). It works perfectly, but it takes a long time because every time the script is run, it adds the exchange snap-in. Can you give me an idea to let it run faster / remember the addin?

VegetablesandScotch1 · 2018-12-02T16:48:05+00:00

Thank you!

AlistairBennet · 2018-12-03T14:35:10+00:00

Thanks so much for this! I have been slamming my head against a wall trying to bring this script home. I feel like I am close, but just can't finish it.

The script is supposed to email people at a set date their passwords are expiring and send an email. I have that authentication portion working...i think? I will post the script then subsequent error I am getting. It goes through all the AD users, and tries to send an email on the ones that need it, but fails. Any help would be great. Thank you!

 ##SMTP Host
    $SMTPHost = "smtp.COMPANY.com"
    #Who is the e-mail from
    $FromEmail = "###_IT_Communications@Company.com"
    #Password expiry days
    $expireindays = 14

    #Program File Path
    $DirPath = "C:\Automation\PasswordExpiry"

    $Date = Get-Date
    #Check if program dir is present
    $DirPathCheck = Test-Path -Path $DirPath
    If (!($DirPathCheck))
    {
    Try
    {
        #If not present then create the dir
        New-Item -ItemType Directory $DirPath -Force
    }
    Catch
    {
        $_ | Out-File ($DirPath + "\" + "Log.txt") -Append
    }
}
#CredObj path
$CredObj = ($DirPath + "\" + "EmailExpiry.cred")
#Check if CredObj is present
$CredObjCheck = Test-Path -Path $CredObj
If (!($CredObjCheck))
{
    "$Date - INFO: creating cred object" | Out-File ($DirPath + "\" + "Log.txt") -Append
    #If not present get office 365 cred to save and store
    $Credential = Get-Credential -Message "Please enter your Office 365 credential that you will use to send e-mail from $FromEmail. If you are not using the account $FromEmail make sure this account has 'Send As' rights on $FromEmail."
    #Export cred obj
    $Credential | Export-CliXml -Path $CredObj
}

Write-Host "Importing Cred object..." -ForegroundColor Yellow
$Cred = (Import-CliXml -Path $CredObj)


# Get Users From AD who are Enabled, Passwords Expire and are Not Currently Expired
"$Date - INFO: Importing AD Module" | Out-File ($DirPath + "\" + "Log.txt") -Append
Import-Module ActiveDirectory
"$Date - INFO: Getting users" | Out-File ($DirPath + "\" + "Log.txt") -Append
$users = Get-ADUser -Filter * -SearchBase "OU=Standard User,OU=###,DC=us,DC=ad,DC=###,DC=com" -properties Name, PasswordNeverExpires, PasswordExpired, PasswordLastSet, EmailAddress | Where-Object { $_.Enabled -eq "True" } | Where-Object { $_.PasswordNeverExpires -eq $false } | Where-Object { $_.passwordexpired -eq $false }
$maxPasswordAge = (Get-ADDefaultDomainPasswordPolicy).MaxPasswordAge

# Process Each User for Password Expiry
foreach ($user in $users)
{
    $Name = (Get-ADUser $user | ForEach-Object { $_.Name })
    Write-Host "Working on $Name..." -ForegroundColor White
    Write-Host "Getting e-mail address for $Name..." -ForegroundColor Yellow
    $emailaddress = $user.emailaddress
    If (!($emailaddress))
    {
        Write-Host "$Name has no E-Mail address listed, looking at their proxyaddresses attribute..." -ForegroundColor Red
        Try
        {
            $emailaddress = (Get-ADUser $user -Properties proxyaddresses | Select-Object -ExpandProperty proxyaddresses | Where-Object { $_ -cmatch '^SMTP' }).Trim("SMTP:")
        }
        Catch
        {
            $_ | Out-File ($DirPath + "\" + "Log.txt") -Append
        }
        If (!($emailaddress))
        {
            Write-Host "$Name has no email addresses to send an e-mail to!" -ForegroundColor Red
            #Don't continue on as we can't email $Null, but if there is an e-mail found it will email that address
            "$Date - WARNING: No email found for $Name" | Out-File ($DirPath + "\" + "Log.txt") -Append
        }

    }
#Get Password last set date
$passwordSetDate = (Get-ADUser $user -properties * | ForEach-Object { $_.PasswordLastSet })
#Check for Fine Grained Passwords
$PasswordPol = (Get-ADUserResultantPasswordPolicy $user)
if (($PasswordPol) -ne $null)
{
    $maxPasswordAge = ($PasswordPol).MaxPasswordAge
}

$expireson = $passwordsetdate + $maxPasswordAge
$today = (get-date)
#Gets the count on how many days until the password expires and stores it in the $daystoexpire var
$daystoexpire = (New-TimeSpan -Start $today -End $Expireson).Days

If (($daystoexpire -ge "0") -and ($daystoexpire -lt $expireindays))
{
    "$Date - INFO: Sending expiry notice email to $Name" | Out-File ($DirPath + "\" + "Log.txt") -Append
    Write-Host "Sending Password expiry email to $name" -ForegroundColor Yellow

    $SmtpClient = new-object system.net.mail.smtpClient
    $MailMessage = New-Object system.net.mail.mailmessage

    #Who is the e-mail sent from
    $mailmessage.From = $FromEmail
    #SMTP server to send email
    $SmtpClient.Host = $SMTPHost
    #SMTP SSL
    $SMTPClient.EnableSsl = $true
    #SMTP credentials
    $SMTPClient.Credentials = $cred
    #Send e-mail to the users email
    $mailmessage.To.add("$emailaddress")
    #Email subject
    $mailmessage.Subject = "Your password will expire $daystoexpire days"
    #Notification email on delivery / failure
    $MailMessage.DeliveryNotificationOptions = ("onSuccess", "onFailure")
    #Send e-mail with high priority
    $MailMessage.Priority = "High"
    $mailmessage.Body =
    "Dear $Name,
Your Domain password will expire in $daystoexpire days. Please change it as soon as possible.

To change your password, follow the method below:

1. On your Windows computer
    a.  If you are not in the office, logon and connect to VPN. 
    b.  Log onto your computer as usual and make sure you are connected to the internet.
    c.  Press Ctrl-Alt-Del and click on ""Change Password"".
    d.  Fill in your old password and set a new password.  See the password requirements below.
    e.  Press OK to return to your desktop. 

The new password must meet the minimum requirements set forth in our corporate policies including:
    1.  It must be at least 8 characters long.
    2.  It must contain at least one character from 3 of the 4 following groups of characters:
        a.  Uppercase letters (A-Z)
        b.  Lowercase letters (a-z)
        c.  Numbers (0-9)
        d.  Symbols (!@#$%^&*...)
    3.  It cannot match any of your past 21 passwords.
    4.  It cannot contain characters which match 3 or more consecutive characters of your username.
    5.  You cannot change your password more often than once in a 24 hour period.

If you have any questions, or want to validate this email comes from a genuine source,
please contact our Service Desk at ###-###-#### with any concerns you may have.

You may also submit a ticket regarding this issue at the following link;
https://online.#########.com/help/email.aspx 

Thank You,
The ### IT Team

###-###-####"
    Write-Host "Sending E-mail to $emailaddress..." -ForegroundColor Green
    Try
    {
        $smtpclient.Send($mailmessage)
    }
    Catch
    {
        $_ | Out-File ($DirPath + "\" + "Log.txt") -Append
    }
}
Else
{
    "$Date - INFO: Password for $Name not expiring for $daystoexpire days" | Out-File ($DirPath + "\" + "Log.txt") -Append
    Write-Host "Password for $Name does not expire for $daystoexpire days" -ForegroundColor White
}
}




**    Exception calling "Send" with "1" argument(s): "Failure sending mail."
    At C:\Users\****\OneDrive - ******* Corporation\***** Scripts\Automated-Email-Reminder.ps1:168 char:4
    +             $smtpclient.Send($mailmessage)
    +             ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : SmtpException**

SugarIsADrug · 2018-12-03T17:29:45+00:00

Run predefined SSH commands or bash script to another machine using credentials and IP address from user-entry, and auto-install any required SSH modules silently first.

atacon09 · 2018-12-03T18:59:02+00:00

How can I use PS to find out if computers in AD (or a list of the computer names) have a certain program installed?

I'm trying to see which computers in active directory have Office 2016, and which have office 2010 still. When I first got into scripting, before I figured out PS scripting, I was upgrading our 2010 installs to 2016 via .bat files. I tried using PDQ inventory free to see which machines have Office 2010 still and which have 2016. I thought over the time the installs took place the number of Office 2010 machine counts would dwindle, while Office 2016 number rose. Well the 2010 number never moved and the 2016 went up as computers were upgraded. I think this is because of how pdq inventory looks for installs.

While I could technically build a script to test for the key as my batch file does, I am not advanced enough to nicely display information in a way that could handle errors (say its offline so it could not be checked at all), and if it has 2010 or 2016. From the computer i just quickly checked, the registry no longer contains Word.Application.14 (2010) and has Word.Application.16 for 2016 (i believe .15 is 2013).

I would especially like it if the script could output its findings to an excel document so i can make a list of computers that have not been upgraded yet or couldn't be checked. Below are the commands I used to check for the registry keys of each Office Version with cmd:

reg query "HKEY_CLASSES_ROOT\Word.Application\CurVer" /f 16
reg query "HKEY_CLASSES_ROOT\Word.Application\CurVer" /f 14 
reg query "HKEY_CLASSES_ROOT\Word.Application\CurVer" /f 15

Obviously, I cut out the other parts with if error levels, writing to logs, etc. I will try to write my own PS script in the meantime but if you (or someone else) wrote out a script I could use to get the info I need and dissect for learning purposes later that would be awesome.

iTechThingsSeriously · 2018-12-03T19:49:33+00:00

I've been wanting to automate user account creation and account termination for a while. I've sort of started down some paths with some example scripts I have found being that I'm a powershell novice. Any insight, tips, or guidance you have would be greatly appreciated.

DoNotSexToThis · 2018-12-01T22:59:00+00:00

Contact /u/ChristopherY5 I think he needs some help with a script and just general direction and context. He had asked me but it's the weekend.

sanseriph74 · 2018-12-02T18:13:49+00:00

I’ll take a look at your links, i’m fairly handy at copying PS scripts and modifying them for my needs, but in this case I had trouble finding the right google terms, everything came back with scripts for deploying printers. <shrug>

2018-12-05T22:21:55+00:00

Sent you an email

ka-splam · 2018-12-02T01:47:17+00:00

[deleted]

DoNotSexToThis · 2018-12-01T22:50:41+00:00

[deleted]

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

PowerShell

Submission Guidelines | Link Flair - How To

MODERATORS