PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/25/2016 3:13 PM by  Josh B
Automatically unsuspending jobs
 2 Replies
AddThis - Bookmarking and Sharing Button
Sort:
You are not authorized to post a reply.
Author Messages
Josh B
Helpdesker
Helpdesker
Posts:14
Points:18


--
10/24/2016 2:04 PM

    Today I implemented some Priority Manager profiles to automate the unsuspending of jobs once a target date is reached.  Thought I'd share...

    Where to store the date

    On the Timeline tab of a Job, there are 3 date fields, one of which is labelled 'Work commencement date'.  This seems appropriate and we have no other business automation rules using that field.  Alternatively a dedicated date field on the Custom tab of a Job could also work.

    Business logic

    When a Job has a Job Status of 'Suspended' and the 'Work Commencement Date' has passed we want to:

    • Change the job status to 'In Progress'
    • Write a short description to the Action Details, eg. This job was unsuspended because the Work Commencement Date date has lapsed.
    • Email the current assignee notifying them that the job has become unsuspended

    Templates

    • Create an email template for assignee notification
    • Create an action template for the priority manager to use.  This is what changes the job status, adds the note and uses the above email template.

    Setting up a new Priority Manager Profile

    1. Profile Definition: Start by pressing the Launch Job finder button from within the Profile Definition step of a new Priority manager Profile.
    2. In the Job finder, select a Job Status of 'Suspended' then press 'Return search criteria to Priority Manager'.
    3. Click on the 'Use custom SQL search criteria' radio button.  This shows the SQL generated by the Job Finder and makes it easy to build on the WHERE clause as required.
    4. The Work Commencement Date is stored in tblHelpdeskJobs, so all you need to do is add "AND
      WorkcommencementDate < GetUTCDate()" to the end of the query.  (You might like to test this query out with SQL Server Management Studio on a dev system with some test jobs.)
    5. Actions To Perform: Check 'Complete this action template' and select your new action template.
    6. Frequency: I chose to run this profile every 5 minutes during business hours.  Perform all actions EVERY TIME...
    7. Save and Enable the rule.

    I took this a step further and created two other Profiles:

    • Immediately unsuspend jobs that have a null value for the Work Commencement Date.
    • Immediately unsuspend jobs that have a Work Completion Date far off in the distant future.  We agreed an upper limit of 2 months is a reasonable interval to revisit jobs.  For the handful of jobs that are legitimately suspended longer that that, this was, for us, an acceptable trade-off.

    Edited: Changed to GetUTCDate()
    Rod Weir
    HelpMaster development team
    Helpdesk expert
    Helpdesk expert
    Posts:516
    Points:910


    --
    10/25/2016 9:19 AM
    Hi Josh,

    Nice post! I like the way you structured the post into Business Logic, Templates, and Implementation - makes it easy to follow.

    Regarding step 4 - the SQL should be using the GetUTCDate(), rather than GetDate(). The reason for this is that ALL dates in the HelpMaster database are stored in Coordinated Universal Time (UTC).
    HelpMaster development team
    Check out the HelpMaster roadmap
    Josh B
    Helpdesker
    Helpdesker
    Posts:14
    Points:18


    --
    10/25/2016 3:13 PM
    Thanks Rod!  I should have remembered HMP uses UTC dates...
    You are not authorized to post a reply.


    Configuration Management by Guy in Anything goes with 0 replies I looking people using Helpmaster for Configuration Management (CM) down to the Configuration Item (CI) level. How have you have built your CM tr...

    HelpMaster website update by Rod Weir in Announcements with 0 replies In preparation of the v17 release, the HelpMaster website has had a make-over. The new-look site provide additional information about the capabilit...

    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...

    Configuration Management by Guy in Anything goes I looking people using Helpmaster for Configuration Management (CM) down to the Configuration Item (CI) level. How have you have built your CM tr...

    HelpMaster website update by Rod Weir in Announcements In preparation of the v17 release, the HelpMaster website has had a make-over. The new-look site provide additional information about the capabilit...

    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...