Listing 4: Sample Queries for the ADUsers Database

--Example 1: Query that generates a list of all disabled user accounts
SELECT ADUsers.DisplayName, ADUsers.UserID, ADUsers.UserDisabled
FROM ADUsers
WHERE (((ADUsers.UserDisabled)=True));

--Example 2: Query that generates a list of disabled user accounts that have email addresses
SELECT ADUsers.DisplayName, ADUsers.UserID, ADUsers.EMailAddress, ADUsers.UserDisabled
FROM ADUsers
WHERE (((ADUsers.EMailAddress) Is Not Null) AND ((ADUsers.UserDisabled)=True));

--Example 3: Query that generates a list of home directories that are no longer in use
SELECT HomeDir.HomeDir
FROM HomeDir LEFT JOIN ADUsers ON HomeDir.HomeDir = ADUsers.UserID
WHERE (((ADUsers.UserID) Is Null));