Skip to main content
commvault.com commvault.com
Question

Custom Alert

  • May 28, 2024
  • 1 reply
  • 46 views
S
Novice
Forum|alt.badge.img

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
    Community All Star
    Forum|alt.badge.img+16

    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.

    J
    Terms & ConditionsCookie settingsAccessibility statement