Search results
Jump to navigation
Jump to search
Page title matches
- |title=How to add a column to the database using the Database Schema Editor|type=FAQ == How to add a column to the database using the Database Schema Editor ==3 KB (582 words) - 11:28, 23 August 2016
- |title=Migrating Supportworks Data from One Database Server to Another|type=FAQ == Migrating Supportworks Data from One Database Server to Another ==5 KB (874 words) - 14:41, 20 August 2015
- * [[How to Set Supportworks Database Table Permissions]] * [[Database Searches]]150 bytes (18 words) - 16:34, 2 February 2018
- ===Question: What is Database Searches used for?=== ...ase Searches is another way of searching information that is stored in the database end, for example,2 KB (315 words) - 17:21, 8 November 2017
- {{DISPLAYTITLE:Database}} * [[How to Identify the Database that Holds a Specific Table]]1 KB (173 words) - 11:58, 26 January 2018
- | title=Creating New Database Entity Views Database Entity Views on the Supportworks client provide another means of searching3 KB (559 words) - 11:14, 12 February 2018
- The SwSQL database is based on MySQL and uses the MyISAM engine. MySQL uses three files (*.frm The types of application that will lock the database files are typically either Anti Virus, Backup or the Windows Shadow Copy Se1 KB (181 words) - 11:48, 16 June 2015
- *[[Causes of Database table corruption]]76 bytes (10 words) - 12:38, 10 July 2015
- | title=Database Entity Views Database entity views on the Supportworks client provide another means of searching2 KB (335 words) - 15:46, 22 January 2018
- | title=Creating New Database Entity Views Database Entity Views on the Supportworks client provide another means of searching3 KB (559 words) - 11:14, 12 February 2018
- |title=The Root Causes of Database Table Corruption The SwSQL database is based on MySQL and uses the MyISAM engine. MySQL uses three files (*.frm1 KB (227 words) - 15:42, 19 January 2018
- |title=Migrating Supportworks Data from One Database Server to Another == Migrating Supportworks Data from One Database Server to Another ==6 KB (945 words) - 08:56, 10 April 2015
- == FAQ: How to Set Supportworks Database Table Permissions == ...he analyst has the necessary rights to view the data on the form. If a new database table has been created, either through an upgrade or customisation, it will1 KB (221 words) - 09:21, 10 April 2015
- |title=How to remove ticket data from the database ...a data dictionary and associating this call to that data dictionary in the database and ensuring that no one else has access to that call or you could delete o3 KB (439 words) - 12:57, 16 February 2018
- |title=How to Modify a Database Column in Supportworks|type=FAQ == How to Modify a Database Column in Supportworks ==699 bytes (100 words) - 14:20, 19 May 2015
- |title=How to Identify the Database that Holds a Specific Table == How to Identify the Database that Holds a Specific Table ==2 KB (418 words) - 09:19, 10 April 2015
- |title=Unable to connect to target database: Call to SQLError Failed ...set a username and password for their database connection. When using the Database Schema Editor without specifying the DSN connection details you might get t1 KB (169 words) - 12:58, 26 January 2018
- |title=Migrating Supportworks Data from One Database Server to Another|type=FAQ == Migrating Supportworks Data from One Database Server to Another ==5 KB (842 words) - 16:57, 5 May 2015
Page text matches
- |title=How to Modify a Database Column in Supportworks|type=FAQ == How to Modify a Database Column in Supportworks ==699 bytes (100 words) - 14:20, 19 May 2015
- * [[How to Set Supportworks Database Table Permissions]] * [[Database Searches]]150 bytes (18 words) - 16:34, 2 February 2018
- {{DISPLAYTITLE:Database}} * [[How to Identify the Database that Holds a Specific Table]]1 KB (173 words) - 11:58, 26 January 2018
- ===Question: What is Database Searches used for?=== ...ase Searches is another way of searching information that is stored in the database end, for example,2 KB (315 words) - 17:21, 8 November 2017
- |title=Unable to connect to target database: Call to SQLError Failed ...set a username and password for their database connection. When using the Database Schema Editor without specifying the DSN connection details you might get t1 KB (169 words) - 12:58, 26 January 2018
- ...the first thing you will need is an ODBC connection to the new application database. 1...Set up a blank database inside Microsoft SQL Server.2 KB (325 words) - 13:54, 26 January 2018
- ...ur DBA and request that they perform the below instructions on your chosen database.414 bytes (61 words) - 11:23, 16 June 2015
- |title=How to add a column to the database using the Database Schema Editor|type=FAQ == How to add a column to the database using the Database Schema Editor ==3 KB (582 words) - 11:28, 23 August 2016
- ===Database=== * [[How to Identify the Database that Holds a Specific Table]]2 KB (320 words) - 07:34, 31 May 2023
- |title=How to Identify the Database that Holds a Specific Table == How to Identify the Database that Holds a Specific Table ==2 KB (418 words) - 09:19, 10 April 2015
- *[[Causes of Database table corruption]]76 bytes (10 words) - 12:38, 10 July 2015
- ...h Data Dictionary is being used by which Analysts you can check either the Database or you can run the System Diagnostics and they will tell you which analysts '''1. DATABASE SEARCH'''1 KB (223 words) - 10:46, 21 June 2018
- In accordance with good working practice, it is advisable to backup your database files before commencing any operation that will change live data. Start ... Programs Hornbill Core Services.... Database Schema Editor3 KB (456 words) - 15:59, 28 June 2018
- *[[The My SQL Database]]89 bytes (11 words) - 15:39, 5 August 2015
- *[[The My SQL Database]]47 bytes (7 words) - 12:38, 10 July 2015
- == FAQ: How to Set Supportworks Database Table Permissions == ...he analyst has the necessary rights to view the data on the form. If a new database table has been created, either through an upgrade or customisation, it will1 KB (221 words) - 09:21, 10 April 2015
- ...s. The first of these provides all (or at least some) of the essential SQL-database facilities that Supportworks use. The second provides the HTTP (Web) facili ...l utility programs that between them allow you to change and replicate the database schema initially built during the Supportworks installation.2 KB (302 words) - 16:23, 17 July 2015
- ...ue the following steps should be completed on the Supportworks Application database:<br\> # Enter the following via your preferred database query tool:791 bytes (118 words) - 16:13, 20 July 2015
- | title=Database Entity Views Database entity views on the Supportworks client provide another means of searching2 KB (335 words) - 15:46, 22 January 2018
- * [[Database | Database]]420 bytes (40 words) - 12:58, 10 July 2015
- By default the SwSQL database server configures the drive where all databases are stored to be on the sam ...h the steps required to change the path where the SwSQL server will locate database and how to move the databases to configured location2 KB (316 words) - 13:09, 12 December 2016
- # Ensure that your database files are backed up, and that all Supportworks clients are logged off for ...> Programs > Hornbill Core Services > Database Schema Editor to launch the Database Schema Editor.3 KB (469 words) - 08:52, 10 April 2015
- |title=Migrating Supportworks Data from One Database Server to Another == Migrating Supportworks Data from One Database Server to Another ==6 KB (945 words) - 08:56, 10 April 2015
- |title=Migrating Supportworks Data from One Database Server to Another|type=FAQ == Migrating Supportworks Data from One Database Server to Another ==5 KB (842 words) - 16:57, 5 May 2015
- ...control the dashboards will be on the security profiles under manage cache database, there you may select which rights your analysts should have . ...e security profile> scroll to the bottom on the rights list > expand cache database management rights > expand the h_dashboard tables and amend the rights as d849 bytes (127 words) - 15:11, 21 June 2018
- ...to go into your MsSQL database and run the below query on the Supportworks database:825 bytes (127 words) - 13:43, 21 September 2021
- |title=Migrating Supportworks Data from One Database Server to Another|type=FAQ == Migrating Supportworks Data from One Database Server to Another ==5 KB (874 words) - 14:41, 20 August 2015
- 4...Make a copy of the Corrupt Database files. 7...Enter the following replacing DATABASE and TABLENAME with the appropriate values.1 KB (205 words) - 09:48, 31 August 2018
- 4...Make a copy of the Corrupt Database files. 7...Enter the following replacing DATABASE and TABLENAME with the appropriate values.1 KB (205 words) - 09:49, 31 August 2018
- 2. Now take a backup of the table found in \Hornbill\Mariadb\swdata database called citype_genhdw_stage. ...your Database administrator if you are not using the standard Supportworks database.2 KB (253 words) - 15:48, 16 February 2018
- 4...Make a copy of the Corrupt Database files, ie. .MYI, .MYD and .frm files belonging to that table. 7...Enter the following replacing DATABASE and TABLENAME with the appropriate values.1 KB (210 words) - 09:34, 31 August 2018
- |title=The Root Causes of Database Table Corruption The SwSQL database is based on MySQL and uses the MyISAM engine. MySQL uses three files (*.frm1 KB (227 words) - 15:42, 19 January 2018
- | title=Creating New Database Entity Views Database Entity Views on the Supportworks client provide another means of searching3 KB (559 words) - 11:14, 12 February 2018
- | title=Creating New Database Entity Views Database Entity Views on the Supportworks client provide another means of searching3 KB (559 words) - 11:14, 12 February 2018
- ...elow compares the amount of space various quantities of specific types of database content stored by Supportworks will occupy in SwSQL and MS SQL, respectiv | width="50%" scope="col" | '''Database Content'''2 KB (300 words) - 08:58, 16 July 2015
- * 1. Go to "Database Searches" ...es, then this will just show you the first 100. To show everything, on the database search, if you scroll down, you have a limit search results to:, you will s954 bytes (173 words) - 14:32, 20 June 2018
- The SwSQL database is based on MySQL and uses the MyISAM engine. MySQL uses three files (*.frm The types of application that will lock the database files are typically either Anti Virus, Backup or the Windows Shadow Copy Se1 KB (181 words) - 11:48, 16 June 2015
- ...e Core Services that come with Supportworks ESP and is used as an embedded database. We pre-configure Supportworks ESP to use this embedded database for the application data3 KB (507 words) - 12:40, 6 April 2018
- ...e Core Services that come with Supportworks ESP and is used as an embedded database. We pre-configure Supportworks ESP to use this embedded database for the application data4 KB (523 words) - 14:25, 21 March 2019
- ...or scripts (if any), as well as by some Custom HTML reports, for their own database connections. For the purposes of this document, it is assumed that both the application database and the system databases are accessed using the one account (whether direct6 KB (884 words) - 13:13, 11 August 2015
- ...ervices > Interactive SQL''') (Or a Query tool of choice if you're using a database other than that provided by Supportworks) #: '''Application Database'''4 KB (614 words) - 11:40, 26 September 2018
- Firstly, make sure the DSN details in the BPM utility and the Database tab of the server configuration utility match.510 bytes (81 words) - 12:49, 21 June 2018
- * [[Migrating Supportworks Data from One Database Server to Another]] | ([http://forums.hornbill.com/index.php?showtopic=15 F626 bytes (76 words) - 13:47, 18 September 2015
- ...need 20TB+ of disk space. To obtain an idea of typical disk usage by the database, see the FAQ entitled ''Size Comparison of SwSQL with MS SQL''. ...what you are doing with the system - particularly in relation to how much database searching and reporting is done simultaneously.3 KB (556 words) - 15:48, 16 February 2018
- Please follow the relevant section based on the database type for SwData. The instructions will remove calls which were closed over ...f your choice; the second set should be run against the Supportworks cache database using Interactive SQL:5 KB (782 words) - 13:19, 21 June 2018
- ...hen obtain the underlying numerical value of this set of options from the database (via SQL) and finally apply this value to all customer records (again via ...that your database is SwSQL. For other databases, you should contact your Database Administrator to see what query tools are available.3 KB (417 words) - 13:52, 20 August 2015
- ...of which involves basic preparatory actions on the Supportworks server and database. ...Web server to the cache database, ''sw_systemdb'', and to the application database if that is also on SwSQL. To grant such access (and to create the account8 KB (1,123 words) - 08:46, 10 April 2015
- You will probably need to modify these directly at the database level. The following SQL statement should disassociate any issues from the ...n at the end of each statement. If you are running MS SQL as your primary database however the first update statement2 KB (300 words) - 13:40, 19 June 2018
- You will probably need to modify these directly at the database level. The following SQL statement should disassociate any issues from the ...n at the end of each statement. If you are running MS SQL as your primary database, the first update statement2 KB (310 words) - 14:51, 3 July 2018
- ...ministration > Manage Security Profiles > System Priviledges > Application Database Management Rights. From there you can restrict the permissions by unticking635 bytes (90 words) - 13:58, 22 January 2018
- ...SwSQLServer and Related Services and take a backup of the sw_messagestore database. Thereafter restart the Swsql server service.723 bytes (106 words) - 10:30, 30 January 2018
- ...tworks. By default, the server is pre-configured to use the Core Services database for application data storage. Different releases of Supportworks ESP will ...following versions are supported. It is recommended that the application database server is installed on a separate server from the Supportworks installation3 KB (483 words) - 15:33, 3 March 2021
- ...nce that server restarts will not be absolutely necessary. However, if the database is remote (for example, an MS SQL cluster), then a restart of the Supportwo2 KB (321 words) - 08:57, 10 April 2015
- 4) Using Interactive SQL create a new database called sw_archive where the emails will be moved. ...d mailbox and how many days worth of email you want to move to the archive database. In this case we will archive anything older than 90 days from the shared__2 KB (332 words) - 10:24, 2 August 2018
- |title=How to remove ticket data from the database ...a data dictionary and associating this call to that data dictionary in the database and ensuring that no one else has access to that call or you could delete o3 KB (439 words) - 12:57, 16 February 2018
- This information is stored in the sw_messagestore database in the table system_gal. It's possible to use Interactive SQL to extract th674 bytes (121 words) - 16:18, 3 July 2018
- ...y back up as and when required (if you ignore the data in any third-party database system such as Microsoft SQL Server). They are as follows: * The data in the SwSQL server database - whether or not a third-party database is used16 KB (2,465 words) - 08:54, 10 April 2015
- === Database === * [[How to Set Supportworks Database Table Permissions]]6 KB (788 words) - 15:36, 7 September 2018
- ...t is the index table ''updatedb_call_index'' (found in the ''sw_systemdb'' database) that is queried instead of the actual Open/Closed Call table (''opencall'' <li>Back up the entire Supportworks database.</li>3 KB (447 words) - 16:19, 10 August 2015
- ...cts and a generic monitoring system. The parts of this document that cover database backup specifically are valid only for the databases that relate to the sup ...h replication would normally be the responsibility of your organisation's database administrators.14 KB (2,098 words) - 08:55, 10 April 2015
- ...specified in the PHP script govern the timing of data acquisition from the database to the server. frequent than the database query submissions that collect the changing data in the first place. So, if4 KB (733 words) - 14:46, 23 August 2016
- # Core Services: this includes web services and database functions ...the alterations have been made by changing a setting, such as a value in a database table. We refer to this as '''configuration''', and in most cases, these se3 KB (497 words) - 13:16, 16 July 2015
- ...ting call-profile records of the target type deleted from the Supportworks database before importation proceeds, ensure that the Clean Tables option is enabled993 bytes (159 words) - 16:05, 3 July 2018
- Is it advisable to have a backup of the Supportworks System Database before making the alterations below.1,020 bytes (157 words) - 13:49, 20 August 2015
- This data is then stored in a system database on the server, which can be accessed via Interactive SQL.1 KB (166 words) - 15:48, 5 February 2016
- Set the database to "swdata"1 KB (200 words) - 15:35, 28 June 2018
- ...on-default installation, run the Server Configuration utility, select the Database tab and look in the Data Folder field. ...d other pertinent information about each call's attachments is held in the database as part of the call record.8 KB (1,220 words) - 16:48, 29 December 2015
- ...splay names are held in the Active Directory - as opposed to the Exchange database, which was the repository used in older versions of Microsoft Exchange (ve ...ver Configuration > Messaging tab and selecting the "Import from Customer Database" option (as well as the "Build GAL" option, of course).6 KB (1,035 words) - 15:48, 16 February 2018
- ...tion in which the server provides the central system functionality and its database holds all the support-related data, while the client provides the operation1 KB (223 words) - 16:40, 17 July 2015
- ...phone call to an analyst's CTI handset would be able to trigger a Customer-database look-up resulting in the caller's details being displayed in the on-screen1 KB (234 words) - 16:21, 19 June 2018
- ...rvices use the "root" account on SwSqlServer for all communication to the database. The root account can only be used locally and not remotely, which means t ==== Access to Other Database Servers ====14 KB (2,189 words) - 14:21, 12 December 2019
- ...s original pre-replication state, to its previous nightly state, or to the database's state at any point in time. It is assumed that the database server you are using to hold all your Supportworks application data is the17 KB (2,626 words) - 16:16, 15 July 2015
- #:Database Name = '''sw_messagestore'''2 KB (251 words) - 09:50, 14 August 2015
- Alternatively, you can use the database to export the information.2 KB (322 words) - 09:30, 29 January 2018
- ...Services > Interactive SQL. Alternatively, if you are using a third-party database, run the query tool of choice.2 KB (333 words) - 18:10, 9 April 2015
- 2. Take a backup of the swdata database in \C:\Program Files (x86)\Hornbill\Core Services\MariaDB\data\swdata if yo2 KB (304 words) - 15:19, 29 January 2018
- ...e port previously required to be open to connect to the Supportworks MySQL database – can be closed. (For MySQL replication, port 5002 only needs to be open2 KB (308 words) - 15:54, 18 January 2018
- ...ated active page will be displayed for the selected record, just as in a database entity view. You will find that this type of link on an active page, where the database-entity view search was against the Customer table, is useful for analysts11 KB (1,770 words) - 08:51, 10 April 2015
- ...the client(s) and the database server. ODBC/SQL connectivity to the SQL database is handled only by the Supportworks server and the clients connect only t ...to this, the Supportworks server keeps track of all changes made to the database and the data item(s) each client is displaying. In the event of a data it9 KB (1,371 words) - 18:35, 9 April 2015
- Use these links to understand and administrate the Web and Database Services3 KB (459 words) - 11:22, 30 May 2022
- If you upgrade to Core Services 3.1.2 and have SwSQL database replication set up, you will find that the replication process no longer wo3 KB (386 words) - 08:57, 10 April 2015
- ...SM x.x | ([https://community.hornbill.com/topic/11832-effect-of-removal-of-database-entity-views/ Forum thread]) - ITSM x.x3 KB (412 words) - 15:31, 30 January 2018
- ...ID mismatch when you start the main server. If you are using SwSQL as the database, you can drop the table by typing the following command line, using the In4 KB (670 words) - 08:56, 10 April 2015
- '''Configuration Management Database (CMDB)''' This is the series of database tables used for storing information on the supported Configuration Items, t12 KB (1,767 words) - 08:51, 15 June 2015
- ...SM x.x | ([https://community.hornbill.com/topic/11832-effect-of-removal-of-database-entity-views/ Forum thread]) - ITSM x.x5 KB (703 words) - 13:10, 31 August 2018
- ...rated when the special page is loaded rather than being stored in the wiki database.<br />7 KB (1,125 words) - 15:11, 17 July 2015
- Supportworks Core Services provides a Web server, a database server and a Web-scripting engine, and is a pre-requisite core for any Horn19 KB (2,982 words) - 08:52, 10 April 2015