Reports on projects if commits happened in last 6 months

[Patrick Evans]

Hi,

I have admin rights for fisheye/crucible and I'm looking for a way to get a report of all the projects that have had commits in the last six months or haven't had.

I have seen there is a search option but I don't see in our version FishEye and Crucible 4.5.3.  

So looking for some help in trying to setup a search or report to show the projects that might not being used as much.

Thanks

[Patrick Evans]

I found these questions that had the answers but they were just for jira, we also have a commit field time frame so it is linked to our BitBucket:

https://community.atlassian.com/t5/Jira-questions/How-to-find-which-projects-are-inactive-in-last-6-months-Like-to/qaq-p/893501

https://community.atlassian.com/t5/Jira-questions/Need-a-query-to-find-out-active-and-inactive-Jira-project-over/qaq-p/99250

The issue with the above is they have "FROM jiraissues" but there isn't a equivalent for fisheye/crucible that I have found.

Thanks