It's all about the answers!

Ask a question

Count artifacts per server


Georg Kellner (825375104) | asked Jan 13 '14, 7:22 a.m.
Hi fellows,

is there an easy way to get an overview, how many artifacts (RTC: stories, tasks..., RQM: testplans, testcases...) are stored per server/database.

I can walk through all project areas and count/calculate those artifacts, but a simpler way would be fine.

greetings georg.

2 answers



permanent link
Krzysztof Ka┼║mierczyk (7.4k35398) | answered Jan 13 '14, 8:30 a.m.
Hi Georg,
If you have the server with RRDI/Insight integrated, then you can create simple report displaying the data you want to.

But my question is: what is the reason you want to calculate the data? Do you have any performance issue?

Comments
Georg Kellner commented Jan 13 '14, 10:38 a.m.

Hi Krzysztof,
Insight/RRDI isn't in place yet.

The reason for this question isn't a performance issue.
A marketing rep of IBM asked for some statistics (users, projects ...).
So i run through all project areas, instead of getting those facts from on side.

greetings georg.


permanent link
John Carolan (71616) | answered Jan 13 '14, 8:31 a.m.
Hi Georg,

Would a query for all values of a WI Type do the trick?



and then use that query to populate the 'Work Item Statistics' widget as follows:


John

Comments
John Carolan commented Jan 13 '14, 8:37 a.m.

screen shots


Georg Kellner commented Jan 13 '14, 9:14 a.m.

Hi John,
this will only work in one Project Area afaik.
greetings georg.


John Carolan commented Jan 13 '14, 10:19 a.m.

Hi Georg,

You are correct - it's not yet possible across multiple project areas (https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=84268).

Krzysztof's answer above about using a report is probably the best way forward.

Regards,
John

Your answer


Register or to post your answer.