Configuration
ServiceNow Integration
Automate ServiceNow incident creation from SQL Planner alerts, configure ticket rules and sync ticket status in one dashboard.
Updated
Integrating SQL Planner with ServiceNow streamlines database monitoring by automating the incident management lifecycle. DBAs can review real-time alerts from SQL Planner and convert critical issues into ServiceNow incidents directly from a unified dashboard.
Centralizing ticket creation eliminates manual data entry and helps ensure that performance bottlenecks or backup failures do not go unnoticed. Users can track the complete history of an alert and its corresponding incident ID for compliance and troubleshooting. Bidirectional synchronization keeps ticket statuses updated across both platforms so IT teams and DBAs stay aligned. This workflow reduces mean time to resolution (MTTR) and supports proactive, organized service management.
ServiceNow ticket management dashboard
To view all ServiceNow ticket details in SQL Planner, navigate to Menu → Service Now Ticket Management. From there you can view ticket history, apply filters and get the latest ticket status.
Ticket creation rule setting
The Configuring Ticket Creation Rules screen lets administrators control which SQL Planner alerts trigger a ServiceNow incident. Use the Is Required toggle to enable or disable specific alert categories — such as CPU spikes, backup failures or connectivity errors — so you filter noise and focus on high-priority issues. Each rule is mapped to a clear description so automation logic aligns with your ITSM requirements.
This flexible configuration ensures that only relevant database health metrics are escalated into the official ticketing system for resolution.
ServiceNow configuration setting
To establish the connection, administrators must provide valid ServiceNow credentials and the specific Web URL for their instance.
A critical configuration step is selecting the Ticket Creation Mode, which determines whether incidents are generated manually upon approval or automatically by the SQL Planner application.
Once these settings are saved, the system uses them to authenticate and bridge the two platforms for seamless ITSM ticketing — with the permissions and pathing needed to trigger and manage ServiceNow tickets according to your organization’s workflow preferences.
