Kaseya Community

"Enable alarm generation" and "Enable auto close of alarms and tickets" in system configure

  • Hi,

    is it possible to change the below mentioned setting by means of a script  ps1, lua... ?

    "Enable alarm generation" and  "Enable auto close of alarms and tickets" in system configure

    example : Enable auto close of alarms and tickets for the weekend ( no 24H - 7/7 support )

    rgds

  • It should be possible, using powershell/lua you would need to authenticate correctly as what you are asking for requires changes to the database.

    However, it can be done with Agent Procedures - using the SQLRead/SQLWrite.

    You should use the following queries to change the status of this:

    Alarm Generation:

    select * from tempdata where tempname = 'alarmdisable'
    delete from tempdata where tempname = 'alarmdisable'

    Auto Close:

    select * from tempdata where tempname = 'reversenotify'
    delete from tempdata where tempname = 'reversenotify'

    Here is a snippet of a procedure I built for this;

    Below are two samples from the SQLWrite/SQLRead .XMLs you will need to drop on the Kaseya Server:

    https://dl.dropboxusercontent.com/u/58075471/Consulting/EnableAlarms.xml

    https://dl.dropboxusercontent.com/u/58075471/Consulting/AlarmsDisabled.xml

    Since this data is stored in tempdata table, it does not have a persistent column to store this data.

    **As with any SQL changes - please ensure and verify within your own environment that it functions to your expectations.**



    sql note
    [edited by: Nicolas Ponce at 7:42 AM (GMT -7) on Mar 14, 2016]