Created On:  07 February 2012

Problem:

How do you obtain CaliberRM database statistics such as the number of requirements per type and baseline?

Resolution:

The crmdiag tool when ran with the –s switch will provide some database statistics, for example when ran against the sample database you will get the statistics below:

-------------------------------------------------------------------------

 

C:\>crmdiag -s SQMDB

crmdiag build version 10.0.345.150

crmdiag build date    Jan 12 2011

crmdiag build time    08:03:07

one option:-s

dbname:SQMDB

Start Wed Feb 01 10:09:40 2012

Command Line: crmdiag  -s SQMDB

crmdiag build version 10.0.345.150

 

Stopping SQM Monitor...

Note: Database will be modified and the nobackup flag is set. Database will not be backed up!

Database Version 10.0.0

 

CaliberRM DB (SQMDB) statistics:

USERS (12)

GROUPS (7)

DEPARTMENTS (0)

PROJECTS (5)

REQUIREMENT TYPES (11)

UDAs (41)

SECURITY PROFILES (3)

REQUIREMENTS (288)

REQUIREMENT ATTRIBUTES (483)

TRACES (865)

DISCUSSIONS (294)

 

-------------------------------------------------------------------------

 

With the attached sample code you can also report on the following:

-          Every baseline for a specified project with a breakdown of:

o   Number of requirements per type

o   Number of requirements per baseline

-          Number of baselines per project

-          Number of ‘Traces From’ per baseline

-          Number of ‘Traces To’ per baseline

 

Example output below for a sample project (Automated Teller Machine):

 

-------------------------------------------------------------------------

 

Project: Automated Teller Machine

Baseline: Current Baseline

Requirement Type Name: 1. Business Requirements

Number of Requirements in Type: 19

Requirement Type Name: 3. Functional Requirements

Number of Requirements in Type: 26

Requirement Type Name: 2. User Requirements

Number of Requirements in Type: 2

 

Total Requirements in Baseline: 47

 

Traces To in Baseline: 85

Traces From in Baseline: 85

 

Project: Automated Teller Machine

Baseline: Version 1.0

Requirement Type Name: 1. Business Requirements

Number of Requirements in Type: 18

 

Total Requirements in Baseline: 18

 

Traces To in Baseline: 57

Traces From in Baseline: 8

 

Total Baselines in Automated Teller Machine: 2

 

-------------------------------------------------------------------------

 

To run the code:

1. unzip the attached ‘CaliberRMStatistics.zip’

2. navigate to ‘CaliberRMStatistics\dist’

3. run the ‘CaliberRMStatistics.jar’

4. enter CaliberRM host, username and password then click on Login

5. if you leave Project as * it will iterate through all projects. To run against a specific project enter the project name replacing any spaces with an *(for example, if your project was called Address Book, you would enter it as Address*Book)

6. click on ‘Run’

7. a message will be displayed beside the run button (Report Complete) once it has finished. A ‘Output.txt’ will also be saved to your C:\ drive with the results

Incident #2552345