Powershell Script to Export recently created AD Accounts of Particular Attributes in CSV Format to Sending Mail to Specific Mail account

Question

Hello All

I want perfect PowerShell script When (Newly) with in 24 Hours created of AD Accounts Trigger with event id to Export particular Attributes in CSV Format -After that Sending Mail to Specific Mail account

Please advise

Answer 1

Hello @Sathishkumar Singh , here's how to get the information. You'll then have to decide on the method to send the email, depending on what's available in your organization.

$Last24h = (Get-Date).AddHours(-24)
$Users = Get-ADUser -Filter { whencreated -ge $Last24h } -Properties mail, Name, GivenName, Surname, Office, telephoneNumber, manager, Department

$output = foreach ($user in $users) {
    $manager = $null
    if ($null -ne $user.manager) {
        $manager = Get-ADUser $user.Manager -Properties Name, mail
    }
    [PSCustomObject] @{
        Email           = $user.mail
        Name            = $user.Name
        'First Name'    = $user.GivenName
        'Last Name'     = $user.Surname
        Location        = $user.Office
        'Phone Number'  = $user.telephoneNumber
        'Manager Name'  = $manager.Name
        'Manager Email' = $manager.mail
        Department      = $user.Department  
    }
}

$output | Export-Csv -Path 'C:\scripts\Data.csv'

---

If this or any other reply helped solve your question, please remember to upvote and/or "Accept Answer". It helps others facing similar issues find the solution.

Answer 2

I suggest that Power Automate may be better suited for this. Head over to their community forum, FL_Comm_Forums, I'm sure someone will be able to help you out.

---

Please accept as an answer if this was helpful.