#!/bin/sh

if [ x"$1" = x"-i" ]
then
	echo "check for administratorless projects"
	exit 0
fi

echo "--- administratorless projects"

echo

psql -At << EOF
SELECT unix_group_name 
  FROM groups 
 WHERE group_id NOT IN (SELECT DISTINCT group_id 
                          FROM user_group 
                          WHERE admin_flags = 'A') 
   AND status = 'A' 
   AND unix_group_name NOT IN ('news', 'stats') 
 ORDER BY unix_group_name
EOF

echo

exit 0

# eof
