Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Query to fetch Active Modules, Test plans & streams on ALM - DNG,ETM & EWM

Questions
Tags
Users
Badges
Imayavarman N J
(11●1) edited
May 24 '24, 7:27 a.m.
Hello,
I was trying to get the queries which has to do the below activity.

We require:
1.need count of only active modules in DNG
2.list of test plans excluding the empty test plans in RQM
3.number of streams excluding inactive streams in CCM

We got some basic queries from IBM, with included dummy or empty test plans, deleted Modules & inactive streams as result.

ETM - SELECT COUNT (DISTINCT ID) FROM PLANNING.TEST_PLAN;
For the Oracle, replace PLANNING_TEST_PLAN;

DNG - Select distinct item_id,id,title from RMUSER.DNGARTIFACTS_DB_ARTIFACT where item_id in (select module_item_id FROM rmuser.dngartifacts_db_binding_contnr TBL_2A)

EWM - select count(*) as COUNT from scm.workspace where stream=1
 
So is there any query which fetch only active modules in DNG, list of Test plan with test case in RQM and active streams in CCM on the server level or project area level.

Kindly help with these
Thanks & Regards
Imay


0 votes

Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER May 24 '24, 10:35 a.m.
This is a forum and not free consulting. I would not expect this to be answered as you want. There is also missing pretty much all information with request to versions. There is no reference to the reporting capabilities available. I am not a reporting Guru, but in general: If this SQL, then my answer would be: you usually do not access the database directly. The database tables are generated and the storage is not trivially to understand. You would use the JRS or report APIs. If this is SPARQL, you would have to figure out the information needed to enhance your query. The request also does not make a lot of sense, you probably want to limit your queries to a project area. A general approach would be to get the items, then go through all items and check for properties and to collect the ones that qualify.

0 answers
2,243 views
0 votes

Be the first one to answer this question!

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,622
× 1,452
× 223
× 125
× 73

Question asked: May 22 '24, 4:52 a.m.

Question was seen: 2,243 times

Last updated: May 24 '24, 10:35 a.m.

Confirmation Cancel Confirm