Jump to content

Data Clear Down Utility


ljbrown
 Share

Recommended Posts

We’re looking to possibly go live with the change management process within our Service Manager system but need to complete testing/configuration of the other elements before a complete switchover for all of our incident management etc.

If we’re to do this however, we’d still need to run the data clear down utility after our testing is complete, would it be possible for a custom reset script to be provided so that it clears everything from the system with the exception of anything relating to Change Requests and its corresponding calendar? 

We’re just exploring options at the moment so if you could please let me know what may be possible it would be greatly appreciated.

Link to comment
Share on other sites

As you mention this would currently need to be a custom script from Hornbill, as the current Request Cleaner is all or nothing. Having ability to do selective clear down using a SQL query, much like Request Loader, is something we have raised before, as we too are looking at phased deployments, all be it with different departments coming on board rather than different request types.

Cheers

Martyn

 

Link to comment
Share on other sites

Hi @ljbrown,

I've just released version 1.0.3 of the Hornbill Cleaner Utility to Github. This version allows you to specify the class of requests that you wish to delete. For further information please see the Hornbill Wiki page: 

https://wiki.hornbill.com/index.php/Hornbill_Clean_Utility

And the Github Repository:

https://github.com/hornbill/goHornbillCleaner/

Kind Regards,

Steve

  • Like 1
Link to comment
Share on other sites

Steve 

Is there any plans to extend this to allow more precise selection criteria for clearing down records, as in our case it is not class specific, it is department/service specific, where we are migrating in other desks into the live system where we already use the request classes.

Cheers

Martyn

Link to comment
Share on other sites

Fantastic thanks Steve, that's just what we need.

If we reset the auto values after removing all incident and service request records, will it still retain the existing Change Request call id's and any new change requests continue on from the last sequential number or would they restart from 001 as well, potentially resulting in duplicate id's?

Regards,

Lucy

Link to comment
Share on other sites

  • 1 month later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...