Expulist

A php script to notify upcoming Account Expiry for Users by email or on screen.

This script evaluates user accounts that have or shortly will expire. Output is by individual emails to each user (or admin account if the user email isn't set) and/or a table on the screen. This enables the Support staff to extend the expiry date if an account will continue to be used. Whilst in theory it will work with other directories they will only produce useful results if the directory uses the attributes loginTime and logonExpiryTime with the date format yyyymmddhhmm??? - unless of course you customise the script appropriately.

The login/control screen lists three main conditions:-
List accounts due to expire during next: n Day(s).
List Accounts expired during previous: n Day(s).
Do not list accounts unused for more than: n Day(s).
For an account to be listed on the results page all three conditions must be met.

To install this you need to have a web server which supports php and LDAP. The tool is tested and installed on Netware 6.5 with Apache, but should be capable of running on other combinations of web server and operating system provided that php is installed and configured with LDAP support. I recommend you create a new folder for the application files in the web server root folder. On an "out of the box" NW65 install this will be sys:Apache2\htdocs, so create sys:Apache\htdocs\expusers. Extract the file from the zip archive into this folder. No other configuration is necessary.

To run the installed scripts start a web browser on an appropriate device and point it at the expusers.php script. In the example above the url would be http://[servername]/expusers/expusers.php. From there on it should be self explanatory. The script should run on any reasonably recent web browser and client operating system.

Change History

  1. 17 May 2009 - Initial Open Source release.
  2. 21 May 2009 - Performance enhancement.
  3. 12 Feb 2010 - Significant update adding the email capability.

Download

Download zip archive


These snippets and utilities are licensed under the University of Illinois/NCSA Open Source License. Here is the text of the license as it applies to this code.

To contact the writer please use this form, or if you prefer use Linked In or even Facebook.

HTML check . CSS check

© Jim Champ, last edit