Skip to main content
Question

Custom Alert

  • 28 May 2024
  • 1 reply
  • 26 views

Forum|alt.badge.img+1

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

1 reply

Erase4ndReuseMedia
Byte
Forum|alt.badge.img+13

Are you set on having an Alert? Given that removing subclients from schedules is part of your standard workflow, I would be concerned about the amount of noise generated by such an alert. 

I would instead recommend tuning the Subclient Schedule Information report to show only SQL Subclients that have no Schedules, and then scheduling that report to send at an appropriate time.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings