Code Samples and Examples

Powershell Script(s)

• PSFTPmon A Script for monitoring changes to a web server with static content. Intended to alert on vandalism in order to permit rapid response. Querys the remote web server with FTP and sends an email alert if the most recently edited file or the total number of files changes.

LDAP/PHP utilities for reporting from LDAP directories

- with an emphasis on eDirectory

• dsbedit. Scripts that can be used to make batch changes to an LDAP directory from data in a csv file. Should work with any LDAP directory, but there are some eDirectory specific customisations, notably with handling the Novell format for Home Directories. Also includes utilities for batch creation of groups for both eDirectory and Active Directory.
• dsmobj. Another set of scripts for manipulating LDAP directories. Whereas dsbedit takes a list of CNs for objects with different CNs, dsmobj makes the same change to multiple objects with the same CN in a large directory. It was designed for manipulating ZEN application objects in a largish tree with multiple WAN nodes, each containing app objects with the same name. If you think of other uses please let me know.
• cronulist. Three scripts that just report on LDAP directories. They are intended to be run daily, scheduled by cron. They create, respectively, lists of all users with the most important attributes listed, disabled users, and groups in the directory with group members. With some attributes changed these are just as useful with Active Directory as eDirectory.
• cmexport. A php script to create as CSV file containing users and telephone numbers from the Cisco Call Manager LDAP directory. This is specifically to permit import of Call Manager data with a Novell Identity Manager delimited text driver. The script can readily be adapted for other LDAP directories. Note that the most recent versions of Call Manager don't have the LDAP capability this utility exploits.
• kmiexp. A pair of php scripts to list the expiry dates of SSL certificates within an eDirectory implementation and highlight those that have or are about to expire.
• readopatt. This is not a fully operational script, but demonstration code to show how to read Operational Attributes, such as object creation date using php and Ldap. The technique can be added to any of the scripts above if desired.
• expusers. A pair of php scripts to list the eDirectory user accounts which are about to or have recently expired. Intended for use by helpdesks to help proactively manage account expiry.
• svrmailer. A pair of php scripts to query LDAP for the email addresses of users within a listed context and/or (for Netware OES) users with their home directory located on a listed server. The script will either produce a screen with all email addresses listed or alternatively email the users a message from a form.
• zappassc. A php script to report Zenworks v3 to v7 application associations to users within an organizational unit. It was written to provide an easy way of documenting what is in use in the tree for planning a migration to Zenworks 10, but would be useful for any need to document what applications are in use.

VBA Macro Code

• Jim's WordHTM macros for Microsoft Word for Windows. A handful of VBA macros that convert word documents to a deliberately very minimal html implementation. All they do is to convert word heading styles into h tags, word tables into unformatted html tables and merge footnotes and endnotes into the document. If you find the standard Microsoft HTML output far too complex and formatted for your requirements then maybe you might find this useful.

• Jim's Excel VBA functions for Microsoft Excel for Windows. Two VBA functions, to convert dimensions entered in feet and inch string form (eg 12'3") into numbers in inches and then metres. Very trivial, but it might save someone writing their own.