Soon-To-Expire User Passwords Report

    The Soon-To-Expire User Passwords Report provides the list of users whose passwords are about to expire in a few days. It displays comprehensive information including the Display Name and sAMAccountName of each user, the timestamp of their last password change, the date and time when their current password will expire, and the timestamp of their most recent login. This report also helps you take proactive measures to inform users to change their passwords before expiry, enabling better password management and reducing help desk calls for password resets.

    How it works

    The Soon-To-Expire User Passwords Report is generated by calculating expiration dates from last password change timestamps and filtering users based on the number of days specified until expiry.

    Limitation

    AD-related reports rely on domain connectivity; outages or replication delays in AD may cause incomplete report data.

    Prerequisite

    You must have administrator or technician-level access to the ADSelfService Plus portal to generate and view reports.

    Generating the Soon-To-Expire User Passwords Report

    To generate the Soon-To-Expire User Passwords Report:

    1. Log into the ADSelfService Plus portal with admin or operator privileges.
    2. Navigate to Reports > Active Directory Reports > Soon-to-expire User Passwords Report.
      Soon-To-Expire Password Users Report
    3. Specify the domain using the Select Domain option. Use the Select OUs option to specify OUs if necessary.
    4. Specify the number of days left for password expiry using the User Passwords that will expire in option.
    5. You can choose to exclude users whose accounts have been Disabled and who use Smart cards from the report using the Exclude Users option.
    6. Then, click on Generate to generate the report.

    Customizing the Soon-To-Expire User Passwords Report

    • Adding or removing columns: To add or remove columns, click on the Add/Remove Columns [ ] option at the far right of the report. In the Select the columns to be displayed pop-up that appears, select the required fields under Available Columns and click on the right arrow ( >> ) to move it to the Selected Columns. To remove columns, select the unused fields under Selected Columns and click on the left arrow ( << ) to move it to Available Columns.
    Soon to expire users report in ADSelfService Plus
    • Ordering the columns: The columns' positions can also be altered by selecting a value under Selected Columns and using the Up and Down options to change its position.

    Sorting

    Click on any of the column headers to view the report's entries in ascending or descending order.

    Searching

    • Click on the search icon [ ] in order to search for specific data in the report.
    • Specific users can be searched for using attributes such as their sAMAccountName, or Display Name.
    • Searching happens using the criteria ' contains '. For example, if the username column is searched for the word " jack " , then all usernames containing the sequence " jack " will be displayed as a result.

    Automating the Soon-To-Expire User Passwords Report generation

    The Schedule Reports option at the top-right corner of the page can be used to schedule the generation of reports at specified intervals, and automatically email them to administrators or specific email addresses. Learn to schedule reports here.

    Exporting the Soon-To-Expire User Passwords Report

    The Export As option at the top-right corner of the page helps export the report in CSV, PDF, XLS, XLSX, HTML and CSVDE formats.

    Tips

    • The More option at the right corner of the page lists the Printable View, Send Mail, and Export Settings options.
      • The Printable View option can be used to preview and print the report.
      • The Send Mail option can be used to mail the report to the desired email addresses.
      • Additionally, you can configure custom Export Settings, such as a personalized title for the report and a header logo that you may wish to display on each page.
    • Use the Exclude Users option to filter out disabled accounts and smart card users from the report, keeping your data focused on accounts that actually require password changes.
    • Leverage the Password/Account Expiration Notification feature (accessible via the tooltip link) to automatically send email, SMS, or push notifications to users before their passwords expire. Learn more
    Customizing the soon-to-expire users report in ADSelfService Plus