Topic: A script that sends emails via the OUTLOOK SMTP server

This topic has 1 reply, 2 voices, and was last updated 10 months, 3 weeks ago by

random commandline

Participant
.

Viewing 1 reply thread

Author

Posts

March 5, 2020 at 4:50 pm #208500

nadav-sh36

Participant

Topics: 2

Replies: 0

Points: 24

Rank: Member

I got a task to do a script in PowerShell where I need to get out of AD a list of names that begin with the letter “A” with full name, username and creation date criteria. Then export the list with custom headers and export it to a CSV file Then import the CSV file again and output anyone who works over two years (full name) So far I have done the script correctly in my opinion because it works. Now I’m pretty stuck I need to make every user on the list who went out first to make a folder (no matter where) and give full permissions to the folder – I did something but it seems to be incorrect. Then I need to send an email with a table that states the full name and folder path and that the sender will be [email protected].

The code I wrote:

[crayon-600e3a96a9639528026055 inline="true" ] <span class="typ">Get</span><span class="pun">-</span><span class="typ">ADUser</span> <span class="pun">-</span><span class="pln">filter </span><span class="pun">*</span> <span class="pun">-</span><span class="typ">SearchBase</span> <span class="str">"OU=meitavdash,OU=Users,DC=meitav,DC=co,DC=il"</span>

    <span class="typ">Get</span><span class="pun">-</span><span class="typ">ADUser</span> <span class="pun">-</span><span class="typ">Properties</span><span class="pln"> whenCreated </span><span class="pun">-</span><span class="typ">Filter</span> <span class="pun">{</span><span class="pln">samaccountname </span><span class="pun">-</span><span class="pln">like </span><span class="str">'A*'</span><span class="pun">}</span> <span class="pun">|</span><span class="typ">Format</span><span class="pun">-</span><span class="typ">Table</span><span class="pln"> name</span><span class="pun">,</span><span class="typ">SamAccountName</span><span class="pun">,</span><span class="pln">whenCreated

    </span><span class="typ">Get</span><span class="pun">-</span><span class="typ">ADUser</span> <span class="pun">-</span><span class="typ">Properties</span><span class="pln"> whenCreated </span><span class="pun">-</span><span class="typ">Filter</span> <span class="pun">{</span><span class="pln">samaccountname </span><span class="pun">-</span><span class="pln">like </span><span class="str">'A*'</span><span class="pun">}</span> <span class="pun">|</span> <span class="typ">Select</span><span class="pun">-</span><span class="typ">Object</span> <span class="pun">@{</span><span class="pln">n</span><span class="pun">=</span><span class="str">'FullName'</span><span class="pun">;</span><span class="pln">e</span><span class="pun">={</span><span class="pln">$_</span><span class="pun">.</span><span class="typ">Name</span><span class="pun">}},@{</span><span class="pln">n</span><span class="pun">=</span><span class="str">'UserName'</span><span class="pun">;</span><span class="pln">e</span><span class="pun">={</span><span class="pln">$_</span><span class="pun">.</span><span class="typ">SamaccountName</span><span class="pun">}},@{</span><span class="pln">n</span><span class="pun">=</span><span class="str">'CreateDate'</span><span class="pun">;</span><span class="pln">e</span><span class="pun">={</span><span class="pln">$_</span><span class="pun">.</span><span class="typ">WhenCreated</span><span class="pun">}}</span> <span class="pun">|</span><span class="pln">  export</span><span class="pun">-</span><span class="pln">csv </span><span class="pun">-</span><span class="pln">path c</span><span class="pun">:</span><span class="pln">\userexport</span><span class="pun">.</span><span class="pln">csv
    </span><span class="typ">Get</span><span class="pun">-</span><span class="typ">ADUser</span> <span class="pun">-</span><span class="typ">Properties</span><span class="pln"> whenCreated </span><span class="pun">-</span><span class="typ">Filter</span> <span class="pun">{</span><span class="pln">samaccountname </span><span class="pun">-</span><span class="pln">like </span><span class="str">'A*'</span><span class="pun">}</span> <span class="pun">|</span><span class="pln"> where </span><span class="pun">{</span><span class="pln">$_</span><span class="pun">.</span><span class="pln">whencreated </span><span class="pun">-</span><span class="pln">le </span><span class="pun">(</span><span class="typ">Get</span><span class="pun">-</span><span class="typ">Date</span><span class="pun">).</span><span class="typ">AddYears</span><span class="pun">(-</span><span class="lit">2</span><span class="pun">)}|</span><span class="typ">Select</span><span class="pun">-</span><span class="typ">Object</span> <span class="pun">@{</span><span class="pln">n</span><span class="pun">=</span><span class="str">'FullName'</span><span class="pun">;</span><span class="pln">e</span><span class="pun">={</span><span class="pln">$_</span><span class="pun">.</span><span class="typ">Name</span><span class="pun">}}</span><span class="pln"> 

    $sp</span><span class="pun">=</span><span class="pln">$</span><span class="pun">((</span><span class="typ">Get</span><span class="pun">-</span><span class="typ">Date</span><span class="pun">).</span><span class="typ">AddDays</span><span class="pun">(-</span><span class="lit">365</span><span class="pun">*</span><span class="lit">2</span><span class="pun">));</span> <span class="typ">Get</span><span class="pun">-</span><span class="typ">ADUser</span> <span class="pun">-</span><span class="typ">Properties</span><span class="pln"> whenCreated </span><span class="pun">-</span><span class="typ">Filter</span> <span class="pun">{</span><span class="pln">name </span><span class="pun">-</span><span class="pln">like </span><span class="str">"A*"</span> <span class="pun">-</span><span class="pln">and whenCreated </span><span class="pun">-</span><span class="pln">ge $sp</span><span class="pun">}|%{</span><span class="typ">New</span><span class="pun">-</span><span class="typ">Item</span> <span class="pun">-</span><span class="typ">Path</span> <span class="str">"c:\temp"</span> <span class="pun">-</span><span class="typ">ItemType</span> <span class="typ">Directory</span><span class="pun">;</span><span class="pln"> icacls </span><span class="str">"c:\temp"</span> <span class="pun">/</span><span class="pln">T </span><span class="pun">/</span><span class="pln">grant </span><span class="str">"$($_.samaccountname):(OI)(CI)F"</span>

[crayon-600e3a96a9639528026055 inline="true" ] Get-ADUser -filter * -SearchBase "OU=meitavdash,OU=Users,DC=meitav,DC=co,DC=il"

Get-ADUser -Properties whenCreated -Filter {samaccountname -like 'A*'} |Format-Table name,SamAccountName,whenCreated

Get-ADUser -Properties whenCreated -Filter {samaccountname -like 'A*'} | Select-Object @{n='FullName';e={$_.Name}},@{n='UserName';e={$_.SamaccountName}},@{n='CreateDate';e={$_.WhenCreated}} | export-csv -path c:\userexport.csv

Get-ADUser -Properties whenCreated -Filter {samaccountname -like 'A*'} | where {$_.whencreated -le (Get-Date).AddYears(-2)}|Select-Object @{n='FullName';e={$_.Name}}

$sp=$((Get-Date).AddDays(-365*2)); Get-ADUser -Properties whenCreated -Filter {name -like "A*" -and whenCreated -ge $sp}|%{New-Item -Path "c:\temp" -ItemType Directory; icacls "c:\temp" /T /grant "$($_.samaccountname):(OI)(CI)F"

[/crayon]

March 5, 2020 at 6:27 pm #208512

random commandline

Participant

Topics: 5

Replies: 349

Points: 632

Rank: Major Contributor

No need to search Active Directory multiple times. Search AD once then put results into a variable.

# Check AD one time for users
$user = Get-ADUser -Properties whenCreated -Filter {samaccountname -like 'A*'} -SearchBase "OU=meitavdash,OU=Users,DC=meitav,DC=co,DC=il" | 
Select-Object name,samaccountname,whencreated

# Export list with custom headers
$user | ConvertTo-Csv | ConvertFrom-Csv -Header FullName,UserName,CreateDate |
Select-Object -Skip 1 | Export-Csv -NoTypeInformation -Path .\user.csv

# List two year employees
$user2 = Import-Csv .\user.csv | 
Where-Object {$_.CreateDate -ge (get-date).AddYears(-2)}

# Create temp folder for each user
$list = [System.Collections.ArrayList]@()
Import-Csv .\user.csv | ForEach-Object {
    New-Item -Path "C:\Temp\$($_.UserName)" -ItemType Directory
    icacls "C:\Temp\$($_.UserName)" /T /grant "$($_.UserName):(OI)(CI)F"
    $obj=[PSCustomObject]@{Name=$_.FullName ; Path="C:\Temp\$($_.UserName)"}
    $list.Add($obj) | Out-Null
}

# Set email properties
    $prop = @{
        From = 'no@reply.com'
        To = 'sender@mail.com'
        Subject = 'User Path List'
        Body = $list
        SmtpServer = 'your.smtp.server.com'
    }

Send-MailMessage @prop

# Check AD one time for users

$user = Get-ADUser -Properties whenCreated -Filter {samaccountname -like 'A*'} -SearchBase "OU=meitavdash,OU=Users,DC=meitav,DC=co,DC=il" |

Select-Object name,samaccountname,whencreated

# Export list with custom headers

$user | ConvertTo-Csv | ConvertFrom-Csv -Header FullName,UserName,CreateDate |

Select-Object -Skip 1 | Export-Csv -NoTypeInformation -Path .\user.csv

# List two year employees

$user2 = Import-Csv .\user.csv |

Where-Object {$_.CreateDate -ge (get-date).AddYears(-2)}

# Create temp folder for each user

$list = [System.Collections.ArrayList]@()

Import-Csv .\user.csv | ForEach-Object {

New-Item -Path "C:\Temp\$($_.UserName)" -ItemType Directory

icacls "C:\Temp\$($_.UserName)" /T /grant "$($_.UserName):(OI)(CI)F"

$obj=[PSCustomObject]@{Name=$_.FullName ; Path="C:\Temp\$($_.UserName)"}

$list.Add($obj) | Out-Null

}

# Set email properties

$prop = @{

From = '[email protected]'

To = '[email protected]'

Subject = 'User Path List'

Body = $list

SmtpServer = 'your.smtp.server.com'

}

Send-MailMessage @prop

Author

Posts

Viewing 1 reply thread

The topic ‘A script that sends emails via the OUTLOOK SMTP server’ is closed to new replies.

A script that sends emails via the OUTLOOK SMTP server

Sign in to your account