Request for a new analytics report to generate a list of user extensions

( 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.

  • Guest
  • Mar 27 2025
  • Attach files
      Drop here to upload