ā04-12-2022 03:52 AM
Solved! Go to Solution.
ā04-12-2022 06:18 AM
Thanks for your reply.
I did not see that but I do now!
I know practically nothing about SQL.
So, do I run that command line as it is shown or do I need to modify that for my particular need?
Is running that on the Unity server service impacting in any way?
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 |
ā04-12-2022 05:51 AM
hi Chuck,
Did you check the thread here cisco-unity-connection-map-active-schedules-to-holiday-schedules
Regards,
ā04-12-2022 06:18 AM
Thanks for your reply.
I did not see that but I do now!
I know practically nothing about SQL.
So, do I run that command line as it is shown or do I need to modify that for my particular need?
Is running that on the Unity server service impacting in any way?
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 |
ā04-14-2022 05:01 AM
Hi There,
This specific query doesn't need to be modified and it should run on CUC directly. I tried on my CUC and it gave me the result.
Regards,
ā04-15-2022 06:39 AM
Do you know how to modify the query to show all of the call handler display names that are built along with the assigned active schedule and holiday schedule?
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide