Created On:  06 September 2012

Problem:

There is no SCTM prewritten report that will return all Requirements that do not have any Tests assigned to them.

Resolution:

This information can be returned by creating a custom report in SCTM.  This report will use the following 2 views:

- RTM_V_Requirements - This view returns all columns of the standard properties for requirements
- RTM_V_ReqTests - This view gives you all the test definitions that are linked to requirements

Please see SQL with exclusion join below that will return this all Requirements for a specified Project that are not assigned to a Test:

SELECT * from RTM_V_Requirements req
where NOT EXISTS
(Select * from RTM_V_ReqTests t
where req.ReqID = t.ReqID)
AND ProjectID = ''

Incident #2562464