It's all about the answers!

Ask a question

Count artifacts per server

Georg Kellner (840377108) | 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.4k372103) | 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?

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 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 (

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


Your answer

Register or to post your answer.