GET_DATA_COLLECTOR_NOTIFY_POLICY
Lists any notification policies set on a Data Collector component.
Syntax
GET_DATA_COLLECTOR_NOTIFY_POLICY('component')
component |
Name of the Data Collector component to check for notification policies. Query system table DATA_COLLECTOR for component names. For example: => SELECT DISTINCT component, description FROM data_collector WHERE component ilike '%Depot%' ORDER BY component; component | description ----------------+------------------------------- DepotEvictions | Files evicted from the Depot DepotFetches | Files fetched to the Depot DepotUploads | Files Uploaded from the Depot (3 rows) |
Example
=> SELECT GET_DATA_COLLECTOR_NOTIFY_POLICY('LoginFailures'); GET_DATA_COLLECTOR_NOTIFY_POLICY ---------------------------------------------------------------------- Notifiable; Notifier: vertica_stats; Channel: vertica_notifications (1 row)
The following example shows the output from the function when there is no notification policy for the component:
=> SELECT GET_DATA_COLLECTOR_NOTIFY_POLICY('LoginFailures'); GET_DATA_COLLECTOR_NOTIFY_POLICY ---------------------------------- Not notifiable; (1 row)