With the establishment of the EU General Data Protection Regulation (GDPR), you now may need to find old SpiraTeam projects that are not active any more so that you can delete them and reduce unnecessary storage of personal data.

Finding Old Inactive Projects

Inside SpiraTeam you can of course mark projects as inactive, but what happens when you have to find which projects are not been used for a while, but are still marked as Active. Well, luckily the custom reporting module will help.

If you create a new custom report (see our blog on the subject if  you need to know how to do this), you can run the following query to find the date of last activity in each active project:

select max(H.CHANGE_DATE) as LAST_CHANGE_DATE, P.NAME as PROJECT_NAME from SpiraTestEntities.R_HistoryChangeSets as H
inner join SpiraTestEntities.R_Projects as P on H.PROJECT_ID = P.PROJECT_ID
where P.IS_ACTIVE = True
group by P.NAME

For example you might see:

 

You can now make the project formerly inactive, and eventually delete it, when it's time to purge the data permanently:

 

 

Attachments

Selected files will be attached to any email sent on saving ticket.

file selected files selected  () Delete Selected

  • Created:
  • by:

Select files to upload

Or drag and drop files here

Uploading …
Done!
Upload More?
There was an error.
Try again?

Save to upload the selected file(s)

Article Info
  • Last Updated: 5/25/2018
  • Article ID: KB345
  • Views: 4257