It's all about the answers!

Ask a question

Count artifacts per server


Georg Kellner (840378109) | 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
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


permanent link
Krzysztof Kaźmierczyk (7.4k374103) | 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.

Your answer


Register or 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.