Frequently Asked Questions
Database
- Size Comparison of SwSQL with MS SQL
- Increasing the Maximum Size of the Analyst E-Mail Address Field | (Forum thread)
- Adding Extra Filter Columns to the Call-Index Table
- How to Run a Batch Update of All Customer Records for Web Access | (Forum thread)
- Changing the SwSQL Account Password | (Forum thread)
- How to Identify the Database that Holds a Specific Table
- How to repair all system tables (sw_systemdb)| wiki
- The Root Causes of Database Table Corruption
- Database Migration using the Database Migration Wizard
- Minimum Number of Characters search
- How to add a column to the database using the Database Schema Editor
- Moving SwSQL Databases to another drive
- Unable to connect to target database: Call to SQLError Failed
- Causes of Database table corruption
- Repairing a Corrupt Index File in ESP 7.x
- Repairing a Corrupt Table in ESP 8.x
- ODBC connection to sql server
- Historical data extract from Old version of supportworks
- How to remove ticket data from the database
- MSSQL Sorting or binary data would be truncated
- Deletion of Calls, Emails and Attachments before a certain date
- Special characters cause SQL insert/update statements to fail in Mariadb
Security
- Security audits reporting potential vulnerabilities in Core Services 3.X
- Apache Web Server Hardening
- Setting Up Single Sign-On for the Web Client
- Setting Up Single Sign-On for SelfService
- Configuring SSL and Using Your Own Certificate/Key on the Web Server
- Creating a Self-Signed Certificate
- IE-11 Not able to connect via Core Services 3.1.4 Apache Server using TLS v1.2
The Apache Web Server
- Unable to start SwHTTPServer due to port conflict
- Unable to start SwHTTPServer following an upgrade to Supportworks 7.6.2
- Rotate Apache Logs