Regresar
-
Título
Is it possible to view all currently enabled Alerts, including bot Public and Private? -
Descripción
In Change Auditor 6.0, viewing Private searches which are enabled for Alerts is not easy. There is not GUI interface to view this, unlike 6.5+. In some cases, upgrading to 6.5+ may not be possible.
-
Resolución
The following query can be used to identify all searches currently enabled for alerts:
SELECT * FROM ChangeAuditor.Query.Def WHERE CAST((ChangeAuditor.Query.Def.QueryXML) AS NVARCHAR(MAX)) LIKE '%alert-enabled="true"%'
Note that the name of the database may be different, and would need to be substituded as necessary. In the example above, "ChangeAuditor" is used at the database name. -
Información adicional
This query will not work on a 5.x database or earlier. Only Change Auditor 6.x will work. In 6.x private alert / reports can be found under Administration | Configuration | Private Alerts and Reports. Public alerts / reports can be filtered in the grid view of the Searches pane.