In over my head – GetADUser to CSV to Send-MailMessage

Bottom Line Up Fron: I want to email Active Directory users asking them to confirm that the phone number we have for them is accurate.

Hey there Reddit! I run a bunch of small powershell and cmd scripts when trying to do things like install software and a few other basic things. Now, however, I’m looking to do something much more advanced than I have before. I’m willing to do the research and figure out how to make the specific pieces work but I thought I would ask about the series of steps to go about what I’m trying to accomplish.

What I think I need to do is, run Get-ADUser to export a CSV with GivenName, Surname, EmailAddress, and OfficePhone. That should be all the data I need. Then I think I need to import the CSV, somehow create variables based on the rows of the CSV, then use Send-MailMessage to push emails to our SMTP server. Am I on the right track here or is there an easier way to do this?

submitted by /u/Boodadar
[link] [comments]

Leave a Reply