-$sth = $dbh->prepare("SELECT login, first, middle, last FROM users " .
- "WHERE status = 1");
+$sth = $dbh->prepare("SELECT u.login, u.first, u.middle, u.last, " .
+ "u.clearid, u.unix_uid, u.shell, f.type, f.name " .
+ "FROM users u, filesys f " .
+ "WHERE (u.status = 1 OR u.status = 9) " .
+ "AND f.label = u.login");