PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/10/2014 9:25 AM by  Itro
Priority manager purge function
 2 Replies
AddThis - Bookmarking and Sharing Button
Sort:
You are not authorized to post a reply.
Author Messages
Itro
Helpdesker
Helpdesker
Posts:21
Points:41


--
12/4/2014 9:10 AM

    Hi Guys,

    We recently implemented some automation in our office that logs cases for daily backup logs using email manager.  We realised when we did this that we would create a fair bit of noise in the database and to a fair extent we've managed to minimize its impact on our users but it made me think that it would be great if we could set Priority manager to purge cases.  I know we have the purge function, but this would require me or another admin to log on and do it manually - the more times I manually purge the more likely I am to one day make a mistake on the purge and have to restore a backup.  Would it be possible to add a Purge Helpdesk Case action to the Priority Manager's abilities?  It would mean we could have some cases 'expire' when we don't need to keep track of them anymore.

     

    Thanks,

     

    Marni

    Rod Weir
    HelpMaster development team
    Helpdesk Hall of Fame
    Helpdesk Hall of Fame
    Posts:555
    Points:1017


    --
    12/4/2014 11:12 AM
    • Accepted Answer
    Hi Marni,

    Thanks for the post.

    This is a good idea (albeit a little dangerous to use automation to purge jobs), and we'll get this functionality into a future release of HelpMaster.

    In the meantime, you an use the "Execute SQL" action to achieve this by using the SQL attached to this post.  When you attempt to validate the SQL, or save the profile, you'll get an invalid SQL warning, but you can safely ignore this - it's just being triggered by the use of a stored procedure.

    Any jobs that the Priority Manager profile finds will be completely purged - as if you did it via the Desktop edition.   Just be very careful that you get the right Priority Manager definition to target the right jobs - this can be a very dangerous automation!

    Finally, you'll notice 2 information/warnings in the Priority Manager event log following a successful purge. This is because the PM log is trying to write the job number to the database, however it no longer exists - causing a referential integrity violation. This can also be ignored.

    Hope this helps.

    HelpMaster development team
    Check out the HelpMaster roadmap
    Attachments
    Itro
    Helpdesker
    Helpdesker
    Posts:21
    Points:41


    --
    12/10/2014 9:25 AM

    Awesome!  Thanks so much for this.  I agree, it's dangerous.  The up side is that it's only dangerous while I configure it.  Once it's working I don't need to worry about keystroke error or blonde moments.  

     

    Appreciate your prompt response guys.

    You are not authorized to post a reply.


    New version - HelpMaster v24 now available! by Rod Weir in Announcements with 0 replies A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpr...-f...

    New version - HelpMaster v23 now available! by Rod Weir in Announcements with 0 replies A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpro.com...

    March 2023 v22.7 maintenance release now available by Rod Weir in Announcements with 0 replies A maintenance release for v22.7 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    July 2022 release now available - New version released! by Rod Weir in Announcements with 0 replies A new feature release of HelpMaster is now available!  v22.7.22 For a list of the major new features of v22, see the new documentation site ht...

    June 2022 v22.2 maintenance release now available by Rod Weir in Announcements with 0 replies A maintenance release for v22.2 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    RE: Use PowerBI for HelpMaster dashboards by Rod Weir in Reports and reporting Hi SR, Thanks for the post. Yes, the PowerBI reports for HelpMaster have been well received. Download the latest version, from here. https://www...

    RE: Use PowerBI for HelpMaster dashboards by Scenic_Rim_IT in Reports and reporting Hi Rod - just wondering how PowerBI reports are going? Any chance you have a beta/pre-release version we can help test for you?...

    New version - HelpMaster v24 now available! by Rod Weir in Announcements A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpr...-f...

    New version - HelpMaster v23 now available! by Rod Weir in Announcements A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpro.com...

    March 2023 v22.7 maintenance release now available by Rod Weir in Announcements A maintenance release for v22.7 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    July 2022 release now available - New version released! by Rod Weir in Announcements A new feature release of HelpMaster is now available!  v22.7.22 For a list of the major new features of v22, see the new documentation site ht...

    June 2022 v22.2 maintenance release now available by Rod Weir in Announcements A maintenance release for v22.2 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    February 2022 release now available - New version released! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v22, see the new documentation site https://docs.helpma...

    November 2021 release now available - New Major Version! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v22, see the new documentation site https://docs.helpma...

    May 2021 release now available - New Major Version! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v21, see the new documentation site https://docs.helpma...