#!/bin/bash
cd /opt/pbxware
for T in $(find pw/etc/asterisk/ -maxdepth 1 -name '[0-9]*' -type d | sort -n); do
T=$(basename $T)
Q="
SELECT $T AS '#tenant', p.ext, p.name, a.email, a.firstpassword
FROM admin_site.pbxware_servers AS s,
admin_site.${T}_pbxware AS p,
admin_site.pbxware_users_auth AS a WHERE
s.tenantcode = "${T}" AND s.id = a.server AND p.id = a.extid AND
a.firstpassword != '' ORDER BY p.ext"
sh/mysql -B -e "$Q" | sed "s/\t/,/g"
done
------------------------
3.8.5
#!/bin/bash
cd /opt/pbxware
for T in $(find pw/etc/asterisk/ -maxdepth 1 -name '[0-9]*' -type d | sort -n); do
T=$(basename $T)
Q="
SELECT $T AS '#tenant', p.ext, p.name, p.email
FROM admin_site.${T}_pbxware AS p
WHERE p.email!=NULL
ORDER BY p.ext"
sh/mysql -B -e "$Q" | sed "s/\t/,/g"
done