sys_notification - what is this table?

[Suggy]

sys_notification - what is this table? what is the use of this?

We have this table sysevent_email_action already which is to send email notifications.

[Suggy]

Hello,

You are talking about sysevent_email_action

I am asking about sys_notification.

[Mohan Mallapu]

@Suggy 
The sys_notification table in ServiceNow is a core table that manages notifications within the platform. Notifications in ServiceNow are used to alert users about important events or updates within the system via different communication channels such as email, SMS, or push notifications.

Purpose of sys_notification Table:
The sys_notification table stores the configuration and content of these notifications. Each record in this table represents a notification rule that specifies when the notification should be sent, to whom it should be sent, and what content should be included in the notification.

Key Uses of sys_notification Table
Defining Notifications:

Create and manage notifications that are triggered by specific events or conditions within ServiceNow.
Specifying Recipients:

Define who should receive the notifications. Recipients can be specific users, groups, or roles, or they can be determined dynamically based on record data.
Setting Conditions:

Specify the conditions under which a notification should be sent. This can include changes to records, specific field values, or other criteria.
Customizing Content:

Define the content of the notification, including the subject and message body. You can use variables to insert dynamic content from records into the notification.
Choosing Delivery Methods:

Specify the delivery methods for the notification, such as email, SMS, or push notifications.

Key Fields in sys_notification Table
Name: The name of the notification.
Table: The table to which the notification applies (e.g., incident, change_request).
When to Send: Conditions that determine when the notification should be sent (e.g., record inserted, updated, or deleted).
Recipients: The recipients of the notification (e.g., users, groups, roles).
Subject: The subject line of the notification message.
Message HTML: The HTML content of the notification message.
Message Text: The plain text content of the notification message.
Condition: Additional conditions that refine when the notification should be sent.
Notification Type: The type of notification (e.g., email, SMS).

Mark my answer as Helpful & Accepted if I have answered your question. 

Regards
Mohan M

[Jitendra Diwak1]

Hi @Suggy,

Certainly! Here are more details about the "sys_notification" table in ServiceNow:

1. **Table Name**: sys_notification
2. **Purpose**: This table is used to manage notifications within the ServiceNow platform. Notifications are messages sent to users or groups to inform them about specific events or actions within the system.
3. **Fields**:
- **Type**: Indicates the type of notification (e.g., email, SMS, push notification).
- **Recipient**: Specifies the user or group that will receive the notification.
- **Message**: Contains the content of the notification.
- **State**: Represents the status of the notification (e.g., new, sent, failed).
- **Created**: Records the date and time when the notification was created.
- **Source**: Identifies the event or condition that triggered the notification.
4. **Usage**:
- Administrators can configure notifications to be sent when specific events occur, such as record updates, task assignments, or system errors.
- Notifications can be customized to include relevant information and directed to appropriate recipients.
- Users can manage their notification preferences to control which types of notifications they receive and how they are delivered (e.g., email, SMS).
- The sys_notification table can be queried and analyzed to monitor notification activity, identify trends, and troubleshoot issues related to notification delivery.

Overall, the sys_notification table plays a crucial role in facilitating communication and keeping users informed about important activities and updates within the ServiceNow platform.

Please accept my solution if it resolves your issue and thumps up

Thanks

Jitendra 

[Suggy]

Anyone?