How to list CMS users
Following a discussion on Avaya Users forum, here’s how to use standard Informix utility dbaccess to query CMS database and get the list of users defined in CMS, with their logins, names and locations:
. /opt/informix/bin/setenv dbaccess cms@cms_ol - <<! select l_name, f_name, room, telephone from users !
You need to run this as root since only root account has read permissions on users table by default. Also note that there is no typo in the first line, there should be a space between dot and path name.