Unity Database Query Commands

[chuck47172]

Cisco Unity Connection Version 12.5.1.13900-35

Does anyone know a Unity Connection database query command to show all of the call handler display names?

[chuck47172]

I’m trying to compile a list of all Unity Call Handlers along with their Schedule Names and associated Holiday Schedules.

I found two database queries and want to somehow join them together.

Any ideas appreciated.

This query will list all Unity schedules along with their holiday schedules…

run cuc dbquery unitydirdb SELECT b.displayname as ActiveSchedule, a.displayname as HolidaySchedule FROM tbl_schedule a JOIN tbl_schedulesetmembermap c ON a.objectid=c.scheduleobjectid JOIN tbl_scheduleset b ON c.schedulesetobjectid=b.objectid where c.exclude=1

This query will list all call handler names…

run cuc dbquery unitydirdb select displayname, objectid from vw_callhandler

[chuck47172 · Accepted solution]

I figured it out. Thanks anyway.

run cuc dbquery unitydirdb SELECT b.displayname AS ActiveSchedule, a.displayname AS HolidaySchedule, d.displayname AS CallHandlerName FROM tbl_schedule a JOIN tbl_schedulesetmembermap c ON a.objectid = c.scheduleobjectid JOIN tbl_scheduleset b ON c.schedulesetobjectid = b.objectid JOIN vw_callhandler d ON d.schedulesetobjectid = b.objectid WHERE c.exclude = 1;