ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    Lookup FreePBX Users from the Command Line

    Scheduled Pinned Locked Moved IT Discussion
    freepbxmysql
    1 Posts 1 Posters 819 Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • scottalanmillerS
      scottalanmiller
      last edited by

      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 |               |                |          | *        |
      +----------+------------------------------------------+---------------+----------------+----------+----------+
      1 Reply Last reply Reply Quote 1
      • 1 / 1
      • First post
        Last post