Need to remove user activity from jira history and activity

[Aamir Mulla]

As the question...for a specific user using a Jython script

I have tried using the [UserHistoryManager Class|http://docs.atlassian.com/software/jira/docs/api/4.2/com/atlassian/jira/user/UserHistoryManager.html ], but have been unsucessful.

We are using Jira v4.4.5

[David Chan]

This is something that is definitely not recommended. It may be possible to do this via the database access.

Definitely Backup your database first.

I believe the tables you'll want to take a look at are the:

• changeitem
• changegroup
• userhistoryitem

[Aamir Mulla]

Thanks for your response David. We have a custom field to gather information about about a tree of improvements under a given feature (done via Jython). It makes some time computations in the process via a virtual (not a person) user account. The problem is the flooding of information in the history due to this. Wonder if anyone knows a Jython or Java based solution for this problem, than at database level.

I have already found out the tables affected by the change, but thanks for re-assuring the list.