( The Christ Hospital ) The user requires a weekly scheduled report listing users and their assigned extensions.
I generated the report using the following SQL query from the Org Services database table:
SELECT ua.login_name AS caregiver_name, se.extension AS sip_extension, se.external_number
FROM sipextension se
JOIN useraccount ua ON ua.caregiver_id = se.contact_id
JOIN caregiver_affiliation ca ON ca.caregiver_id = ua.caregiver_id;
Since there is no option to schedule this report weekly, I am requesting the creation of a report to view users along with their assigned extensions and extension numbers.