HelpMaster helpdesk discussion forum

Forums Discuss HelpMaster
HelpMaster SQL Server database
Search this forum:
Search
You are not authorized to create a new topic
Topics
 Replies
 Views
 Last Post
0 Replies and 3034 Views Database changes for v12 - UTC date conversion - VERY IMPORTANT!    3034  0 Started by  Rod Weir Background HelpMaster v12 and above supports multiple timezones when entering, updating or viewing any date/time data.  This is very useful if you use HelpMaster across different timezones. In order to support this functionality, HelpMaster needs to store all date data in the database as UTC (Universal coordinated time).  When the date data is displayed to the end user, it is converted and displayed in local time.  If the timezone for the date is different to the local time, Hel...
0 3034
04/25/2012 10:08 PM
3 Replies and 6436 Views How to improve SQL Server performance and thus HelpMaster's too.  6436  3 Started by  Dennis Odri I recently helped one of our many valued clients with an issue where his HelpMaster services were just stopping periodically due to SQL Server timeouts and Exchange mailbox access timeouts. I discovered that they had only allocated 2GB RAM and a single CPU to their HelpMaster server which is a Virtual Machine which also hosts their HelpMaster database under SQL Server 2012 Express. It seems that SQL Server 2012 requires a minimum of 4GB of RAM on the host. I also recommended that he enables a...
3 6436
by  Josh BJump to last post
11/23/2016 3:53 PM
0 Replies and 1382 Views End of life notice for SQL Server 2005  1382  0 Started by  Rod Weir Support for SQL Server 2005 is coming to an end in 2016. https://support.microsoft.com/en-us/lifecyclep1=2855&wa=wsignin1.0  If you're still using SQL Server 2005 for HelpMaster (or any other system), please consider upgrading to a more recent version of SQL Server soon. If you need any help with this please contact PRD Software and we can help you.
0 1382
09/18/2015 12:08 PM
1 Replies and 2627 Views Database and Report Wizard Error  2627  1 Started by  Robert Bean HelpMaster 13.6.4 Database Patch Log File ============================================ Please report any errors to PRD Software at supportprdsoftware.com.au ---------------------------------------- Connection string: Integrated Security=SSPI;Initial Catalog=HelpMaster;Data Source=DMBAPP;Connect Timeout=300; 6/26/2013 6:37:16 PM   Patch started. 6/26/2013 6:37:16 PM   Applying patch version &39;1&39;... 6/26/2013 6:37:16 PM   Updating Database Compatibil...
1 2627
by  Rod WeirJump to last post
07/04/2013 9:24 PM
0 Replies and 3390 Views SQL script to capitalize the First and Last name of each client  3390  0 Started by  Rod Weir We recently had a request to ensure that the frist letter of a client&39;s First name and Last name was always captalized.  HelpMaster currently does not have this functionality built-in, but running the following SQL script will update your database to make the first letter of each name a capital letter. This script can be run at any time - even scheduled to run at regular intervals if required. Update tblPerson Set Firstname = Upper(Left(FirstName,1)) Substring(FirstName,2,254),...
0 3390
04/22/2013 6:26 PM
2 Replies and 2662 Views Moving the database to a new server  2662  2 Started by  Kate Herd Hi Everyone   We are about to migrate from one SQL server to another.  Is there anything specific we should be careful about with helpmaster Thanks!   Kate
2 2662
by  Kate HerdJump to last post
04/04/2012 10:33 PM
0 Replies and 2366 Views How to create secure SQL Server service accounts  2366  0 Started by  Rod Weir HelpMaster uses SQL&160;Server extensively for general access, automation services and reporting. Here's an informative article from MSSQL Tips team about securing SQL&160;Server service accounts. http://www.mssqltips.com/sqlservertip/2503/how-to-create-secure-sql-server-service-accounts/ Some good information here.
0 2366
09/28/2011 6:34 PM
0 Replies and 10609 Views Manually re-indexing and updating stats on SQL Express.  10609  0 Started by  Dennis Odri The SQL Server 2008 R2 Express edition that comes with HelpMaster doesn't have the capabitilty to perform maintenance tasks such as automated Database backups, re-indexing, and updating statistics to keep your database lean and performing well. There are however built-in Stored Procedures and functions that can be run manually on a regular basis to perform these tasks. Run each of the following SQL sections in order from SQL&160;Server Management Studio Express, if installed. Alternately you ca...
0 10609
09/05/2011 6:33 PM
0 Replies and 2101 Views Transferring job custom text data into the new job summary field. v10 Only  2101  0 Started by  Rod Weir Hi HelpMasters, As you know, HelpMaster v10 has a new one-line summary text field on the job screen.&160; See http://www.helpmasterpro.com/Products/What-is-new-for-HelpMaster-v10.aspx if you didn't already know this. Before this field was available, some users have configured a custom text field to store such data.&160; If you have upgraded to v10, or are planning to and want to transfer this custom data into the new summary field, you can do this easily via the attached SQL&160;script. He...
0 2101
09/28/2010 1:43 AM
4 Replies and 3382 Views Upgrade the SQL Database form 2000 to 2005  3382  4 Started by  Chris Duncan Well finally, I am getting round to upgrading our&160;HMP to the&160;latest version..We are on 7.5.177,&160;But have realised that my database is on Sql2000 and the newer versions need Sql2005/2008... So before I can do anything I need to upgrade the database...I have a Sql2005 server already that I can move to.. Can anyone give me some advice on how Or do I need to send in a copy Regards Chris
4 3382
by  Chris DuncanJump to last post
06/13/2010 4:47 AM
0 Replies and 2382 Views How to upgrade a HelpMaster Pro database  2382  0 Started by  Rod Weir Upgrading a HelpMaster database is easy. Once you've installed the latest version of the Databse and Reports Wizard, run it and select the 'Upgrade Database' option. Here's the video of this process http://www.youtube.com/watchv=djlOv67Rogs &160; &160;
0 2382
02/04/2010 5:40 PM
0 Replies and 2134 Views Why upgrade to SQL Server 2008?  2134  0 Started by  Rod Weir Here's what Microsoft has to say about the matter. http://www.microsoft.com/sqlserver/...grade.aspx &160; &160;
0 2134
11/02/2009 10:41 PM
0 Replies and 3013 Views Minimum database permissions for HelpMaster Pro  3013  0 Started by  Rod Weir Hello helpdeskers, &160; Recently we've been getting a few questions regarding the minimum database permissions that are required for using HelpMaster Pro.&160; Below is an updated page taken from the helpfile that explains the best way to achieve this.&160; Hope this helps Rod Security Settings for the HelpMaster Pro database Overview The following information will help to configure the minimum SQL Server security settings required for your HelpMaster Pro database. Please note ...
0 3013
07/24/2008 6:01 PM
2 Replies and 3159 Views SQL 2005 and V8  3159  2 Started by  Anne Savoie Hello, I need help with SQL.&160; I made the mistake of having my v7.5 database in the master.mdf database.&160; When attempting to load sql 2005 service pack 2 I lost the original master.mdf.&160; I have&160;a backup master.bak (my whole helpdesk database!) but to no avail can I get it to restore, import or create a new database&160; I've tried updating the master while is single-user mode but it will not go.&160; Creating a new database gives me an error about the sysnsobjs.&160; I h...
2 3159
by  Rod WeirJump to last post
07/22/2008 12:08 AM
0 Replies and 2567 Views Database dictionary  2567  0 Started by  Rod Weir For those who wish to gain a deeper insight into the database structure of HelpMaster Pro v8, the database dictionary is now available for registered users via the 'Downloads and Updates' page of this website. The database dictionary is a compiled helpfile that describes each SQL Server 2005 database object within the HelpMaster Pro database. This is very useful information for those who wish to perform custom reporting. If you have any questions about the changes to the database ...
0 2567
10/23/2007 8:09 PM
You are not authorized to create a new topic
Forums Discuss HelpMaster HelpMaster SQL Server database


RSS Feed Available

Latest posts

Email tags not working. by David C in Email Manager with 1 replies Hi, I recently got the email service working and was poking around other areas (new to the software) and for some reason email template tags are not ...

 Knowledge Base improvements by Rod Weir in Wishlist with 0 replies We've recently received some requests to improve the knowledge base feature in HelpMaster via our support channel.  I'm re-posting some of the id...

 Triggered Events on Assets by Josh B in Priority Manager and Triggered Events with 2 replies I want to set up some automation for Assets but I need some help.  Rather than sending a support email through, I thought I'd share the developme...

 Automatically unsuspending jobs by Josh B in Priority Manager and Triggered Events with 2 replies Today I implemented some Priority Manager profiles to automate the unsuspending of jobs once a target date is reached.  Thought I'd share... ...

 Use PowerBI for HelpMaster dashboards by Rod Weir in Reports and reporting with 0 replies Microsoft PowerBI is a powerful dashboard tool that allows you to quickly create dashboards based on your helpdesk / service-desk data.  With an...

 Template catalogs by Rod Weir in HelpMaster development with 0 replies Another great new feature of v17 is "Template Catalogs".  Template catalogs are groupings of Job Templates and Knowledge Base articles.  E...

 Spotlight on workflow object - Log new job by Rod Weir in HelpMaster development with 4 replies The next version of HelpMaster has a radically improved workflow system with lots of new workflow objects.  One of the most powerful and useful i...

 Clients can now link to multiple sites by Rod Weir in HelpMaster development with 0 replies Another handy feature of HelpMaster v17 is the ability to link clients to multiple sites.  Previously clients could only be linked to 1 site only...

 Control Sets - think custom fields, but much, much better... by Rod Weir in HelpMaster development with 0 replies One of the major new features of the next version of HelpMaster is the control sets. Think of control sets like mini-forms that you can design, and t...

 Workflow improvements by Rod Weir in HelpMaster development with 0 replies The workflow feature of HelpMaster is a very powerful tool to design, build and execute business processes.  It has proven to be a popular part o...

Latest posts including replies

RE: Spotlight on workflow object - Log new job by Rod Weir in HelpMaster development Hi Josh, Thanks again for the feedback and ideas. The new workflow designing has some of these things already.  Keyboard support has been i...

 RE: Spotlight on workflow object - Log new job by Josh B in HelpMaster development Couple more ideas for workflows. First, I want to point out that the pattern I have adopted is to have an message box present instructions then an act...

 RE: Email tags not working. by Rod Weir in Email Manager Hi David, Thanks for the information. Can you tell us what version of HelpMaster you're using, as well as what module is sending the email (Deskto...

 Email tags not working. by David C in Email Manager Hi, I recently got the email service working and was poking around other areas (new to the software) and for some reason email template tags are not ...

 RE: Spotlight on workflow object - Log new job by Rod Weir in HelpMaster development Hi Josh, Thanks for you post – some good ideas and feedback here as usual. Your idea of having a pre-job workflow is something we’ve alr...

 RE: Spotlight on workflow object - Log new job by Josh B in HelpMaster development Over the past couple of days I have been looking at workflows in v16.10.17.4 (without the changes mentioned above). We are attempting to map one of o...

 RE: How to improve SQL Server performance and thus HelpMaster's too. by Josh B in HelpMaster SQL Server database Thanks for the tip about business time. Makes total sense. Can you elaborate on anything we can do in terms of database maintenance, indexing or o...

 RE: How to improve SQL Server performance and thus HelpMaster's too. by Rod Weir in HelpMaster SQL Server database You're right - the Field Chooser plays a big part in the speed of HelpMaster. The more fields = the bigger the database query = the bigger the ne...

 RE: How to improve SQL Server performance and thus HelpMaster's too. by Josh B in HelpMaster SQL Server database One of the things that can really impact perceived performance is any screen that lists jobs or similar entities (Data grid views) in concert with Use...

 Knowledge Base improvements by Rod Weir in Wishlist We've recently received some requests to improve the knowledge base feature in HelpMaster via our support channel.  I'm re-posting some of the id...