Solved

need a powershell or quest AD cmdlets script to send out an HTML attachment

Posted on 2014-01-06
8
531 Views
Last Modified: 2014-01-08
can someone provide a powershell or AD Cmdlets script that we can use to check Active Directory daily to find out what passwords will expire in the next 14 days, and send out an email notice using an html file with variables in it?

many thanks

S.
0
Comment
Question by:siber1
  • 3
  • 2
8 Comments
 
LVL 68

Accepted Solution

by:
Qlemo earned 250 total points
ID: 39761472
Don't know what you mean with "variables in it", but that is my approach:
Add-PsSnapIn Quest.ActiveRoles.ADManagement -ErrorAction SilentlyContinue 
$body = `
Get-QADUser -Enabled -SizeLimit 0 | Select-Object samAccountName, mail, PasswordStatus |  
  ? {"Password never expires", "Expired", "User must change password at next logon." -notcontains $_.PasswordStatus} |  
  % { 
    $passwordexpiry = $passwordstatus.Replace("Expires at: ","") 
    $daysremaining  = ((get-date $passwirdexpiry) - (get-date)).Days
    if ($daysremaining -le 14) {
      $_ | Add-Member NoteProperty 'DaysRemaining' $daysremaining -PassThru
  } | convertTo-HTML
Send-MailMessage -SmtpServer mail.yourdomain.com `
                 -From       HelpDesk@yourdomain.com `
                 -To         HelpDesk@yourdomain.com `
                 -Subject    'Daily Pwd Expiry Report' `
                 -Body       $body -bodyAsHtml

Open in new window

0
 
LVL 40

Assisted Solution

by:Subsun
Subsun earned 250 total points
ID: 39761479
0
 

Author Closing Comment

by:siber1
ID: 39765708
thank you Subsun and Qlemo. both solutions will work fine for us.

S.
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
LVL 40

Expert Comment

by:Subsun
ID: 39766001
Qlemo,  let's agree to disagree!!.. :) .. I didn't post just a link to discussion thread from any other forum.. Moreover I don’t think it’s too cumbersome for an AD administrator to understand what is written in the article as it is very direct an instructive..

The thread which you are referring to have only few comments which referring to the specific code which is used to send HTML email for the users who’s password is going to expire. I agree that posting links is not a good thing to do but, I just didn't want to copy paste the code from the article. If OP have further questions then I would have happy assisted him to update the code..

BTB, Get-QADuser won’t work to find the password expiry date in all scenarios, for instance if you have a windows 2008 R2 or later domain and you have some  fine-grained password policies then you need to use the function Get-XADUserPasswordExpirationDate to find the exact password expiry date of the user.

@siber1, If you have used Qlemo's solution to achieve your goal, then you may request to reopen he question so that the points can be awarded to correct solution, I am ok with it..
0
 
LVL 40

Expert Comment

by:Subsun
ID: 39766119
Got it.. will keep it in mind..
0
 

Author Comment

by:siber1
ID: 39766934
Qlemo,
I'm not going to get caught up in the politics of this, but I will say that you are extremely fortunate to have someone the caliber of Subsun posting answers to our questions. He is extremely knowledgeable and his advise and postings are the main reason I subscribe to your service.

Michael aka @siber
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will help you understand what HashTables are and how to use them in PowerShell.
This article explains how to prepare an HTML email signature template file containing dynamic placeholders for users' Azure AD data. Furthermore, it explains how to use this file to remotely set up a department-wide email signature policy in Office …
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now