Merge Action HIstory from old comptuerid to new computerid

(imported topic written by MattPeterson)

We recently had an issue which caused all or our clients to reset and report in with new computer ID’s. We’ve run the duplicate computer remover to remove the old computers from the console. In this we’ve lost all action history. Has anyone attempted to merge action history from an old computer ID to a new one? We have a backup of the database before the issue.

I’m thinking we modify the action _flags, Action_defs and actionresults tables and change the old computer id’s to the new computer id’s. I imagine there is a lot more to it though, so Im looking to see if anyone had pursued this before.

Thanks!

(imported comment written by BrianPGreen)

I’ve never done it before, but I think you only need to change the ACTIONRESULTS table. Sorry for the late reply.