Hello all,
I search to create a SQL alert in order to notify me if an agent have no schedule policy associated.
I found an sql query…. but not sure of it. Can you help me ? Thank you !
use commserv
select distinct CommCellSubClientConfig.clientname, CommCellBkScheduleForSubclients.scheduePolicy, CommCellBkScheduleForSubclients.scheduleName, CommCellBkScheduleForSubclients.schedbackuptype
from CommCellSubClientConfig
join CommCellBkScheduleForSubclients
on CommCellSubClientConfig.appid = CommCellBkScheduleForSubclients.appid