This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Retrieve Alert schedule details

I am trying to view the schedules that are applied to my alerts without clicking into each alert.

Does anyone know how to retrieve this data via the API or DB query (SQL or SWQL)?

I thought the Orion.AlertSchedules table was the answer, but no data in it.

Parents
  • There are two places where 'schedules' exist in regards to alerts:

    • When the "alert" is active and checked for trigger conditions. (Time of Day)
    • When the "actions" are active and processed.

    They are both stored in the Orion.Frequencies entity (as a crontab-type expression, so not the easiest to parse).

    FrequencyID DisplayName Description CronExpression Duration StartTime EndTime EnabledDuringTimePeriod CronExpressionTimeZoneInfo
    22 Business Hours Only NULL 0 8 * * 1-5 324000000000 2022-07-21 20:21:11.81 NULL True Central Standard Time

    The linkages look like this:

    Action information

    • Orion.Actions --> Orion.ActionSchedules (via ActionID)
    • Orion.ActionSchedules --> Orion.Frequencies (via FrequencyID)

    Alert information

    • Orion.AlertConfiguration --> Orion.AlertSchedules (via AlertConfigurationID)
    • Orion.AlertSchedules --> Orion.Frequencies (via FrequencyID)

    These do not have navigation properties, so you'd have to link them up using traditional JOINs in SWQL.

  • @KMSigma Thanks that is what I needed.

Reply Children
No Data