Lookup FreePBX Users from the Command Line
-
Sometimes you need to get a list of users on your FreePBX system from the command line. You can do this pretty easily via MySQL using this command:
# mysql -D asterisk -e "SELECT * FROM ampusers"
Here is a sample output:
# mysql -D asterisk -e "SELECT * FROM ampusers" +----------+------------------------------------------+---------------+----------------+----------+----------+ | username | password_sha1 | extension_low | extension_high | deptname | sections | +----------+------------------------------------------+---------------+----------------+----------+----------+ | admin | e1edd0771b6345f00b5557b98b2bde8fd66744c5 | | | | * | +----------+------------------------------------------+---------------+----------------+----------+----------+