Information updated October 2021
In partnership with Jama's Consulting team, we'd like to offer some custom reports, including usage reports, for our customers. These reports were written with BIRT or Velocity, so if you are an on-premises customer and have experience with the appropriate platform, you can manipulate them to suit your needs. Please note that these reports come as-is. Customer Care limits the support of these reports to uploading to Jamacloud.
Self-hosted customers of Jama: There will be no harm done if you would like to install a report and try it out. If you have root or admin access to your instance, you can install the report. Make sure to configure the parameters as displayed in the image found in the report's folder. Some reports have multiple versions which cater to different databases, so pay close attention that you download the correct one.
Cloud customers of Jama: You will need to submit a request we upload one of these offered reports as-is for you. Just send an email to firstname.lastname@example.org indicating which report you would like to use and the URL of your instance. This will create a ticket with Customer Care, who will confirm when the report is uploaded. If you would like to have us customize one of these templates, it would be considered a Services engagement.
If you are interested in having a consultant tailor a report for you, build one from scratch or train you on how to write your own, please reach out to your Jama Account Manager to scope out a project. Cloud customers can upload any Word templates shared there to jamacloud, while self-hosted customers can use any file they see fit on their instance. Cloud customers can request we upload a Velocity or BIRT report you have built yourself as long as it was created on a self-hosted sandbox.
Available Reports can be downloaded from our GitHub repository.
Note that context-sensitive reports will be appear in Export > Office Templates, whereas non-context sensitive reports will appear in the Reports link at the top of Jama Connect.
Velocity Reports (compatible with Jama versions running on Java 7 or 8; should work with most Jama versions)
The Test Results Report (Test Cycle) gives test results grouped by test cycle.
The Test Results Report (Test Case) gives test results grouped by test case.
The Test Plan Report provides Test plan coverage complete with description, creation dates, creator name and steps.
The Review Center Stats Report provides general stats of what is happening in the Review center within an organization.
The Review Stats - Reviewers Per Item Report presents a more detailed view on the individual items in review as well as identifying which Reviewers/Approvers responded, approved, reviewed etc.
The Upstream Traceability Report provides for the export of upstream traceability coverage as an alternative to Trace View. Note that there are two versions of this report:
The original Upstream Trace shows six upstream levels of relationships, but is only compatible with versions of Jama Connect released prior to 2020 (due to changes to the Velocity engine).
Upstream Trace Two Levels version shows only two levels. We recommend the use of this report if you have a large number of items and find the original report takes too long to render.
The Sync Status Report shows all items in any project that are synced with the selected items, along with their Sync Status. It can be run in HTML or Excel. One thing to note: this report displays all items that share the same Global ID with each selected item. If items are reused often, the report may take a long time to run. If this is the case, users may want to select smaller sets of items from which to run this report.
Excel Export was created to help mitigate the effects of a bug, SOS-BUG-854. This bug caused Excel Reports with multiple or large picklists to take an exceptionally long time to generate. This report is intended as a replacement for the stock exporting options when pick lists are needed. Note that this exports plain text only—formatting will be stripped. This bug was fixed in 2015.2.
BIRT Reports supported in 2015.1+; Java 8 required
There is a version unique to each supported database type, so make sure you download the correct version.
*Why is Java 8 required? The BIRT engine upgrade in Jama 2015.1 is backwards compatible with Java 7, but the reports updated for, or created with, the BIRT update are not backwards compatible with Java 7.
Review Center Comments will export current revision comments on open reviews. In order to run the report in a given project, the user must be assigned to one or more reviews in that project as either a reviewer, moderator, or approver. What this means is that when we load the list of reviews for the report parameter list, we load them based on the project you're in, and the user you're logged in as (so public reviews won't show unless a user is a reviewer, moderator or approver, even though they can look at the review itself).
Utilization by Project displays the number of specific Jama objects (users, comments, reviews, etc.) used by a project over a selected date range.
Visual Utilization Report visually displays Jama Utilization data over a specified amount of time.
Login Data Report
This is a non-context sensitive report that builds a single sheet excel file of user login data over the past 90 days. The report gathers information such as the login attempt status, the login attempts username, the license type of said user, the login and logoff time in UTC time and the logged in session duration. The time duration of how far the report will check can be modified by adjusting the hours values on line 421.
Login Report (8.x)
This report is a graphical report that shows how many people login during a given hour. It also contains a table below the graph with every login (this way the report user can export the data to Excel and manipulate it). Note that you can see how many people logged in during a particular hour, but you don't know how many have logged out*. So to find how many you have in Jama at a given time, you will have to assume that you could have as many as the previous hour's logins plus the current hour's logins for a total. But you might have as few as the current hour's logins. It's really just an estimate.
*This is because the database can track only when users use the Log Out link; if their session time outs, this isn't tracked.
Usage Report (8.x)
This report shows a list of all users for any given date range and shows how many days they logged in (a day would be at least one login on that date – if they logged in more than once that day, the day would still be counted once). And it also shows the date of their last login. Note that each user is listed once for each group they are in. So if you are in Org Admin group and the Project Managers groups, you will be listed twice.
Usage Over Time/Utilization Over Time (2015.1) displays license usage information.
*This report does not work in Jama 8.36+ (will work up until that version.)
If you're using 2015.1+ with Java 8, make sure you update your reports to run on the new BIRT engine.
If you are unable to download a needed report because your IT policies block GitHub, please submit a support ticket and we will provide you with the report. Indicate a) which report you would like b) Jama version you are running and c) the database you're utilizing.