It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,884

question asked: Mar 03 '10, 12:23 p.m.
question was seen: 4,084 times
last updated: Mar 03 '10, 12:23 p.m.

Related questions

Export reports from counter page

1
Susan Wu (471●21●16) | asked Mar 03 '10, 12:23 p.m.
Hello,

I have a client asking is there is a way to export tables from the couners page under internal tools from Jazz admin page(with ?internal = true) into a spreadsheet file so they can do some analysis and calculation. I check the Reports - Repository option under RTC eclipse client, but these reports are all generated in graphic format, which are different from tables show in the counters page of the web client. Appreciate any response in advanced.


Susan
Jazz/RTC Support

3 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Rafik Jaouani (5.0k●1●6) | answered Mar 03 '10, 9:45 p.m.
JAZZ DEVELOPER
Susan,

You could use BIRT to design a table based report template that uses the counter data. Then deploy the Report Template to your server and export it to Excel.
0
permanent link
Susan Wu (471●21●16) | answered Mar 04 '10, 11:45 a.m.
Susan,

You could use BIRT to design a table based report template that uses the counter data. Then deploy the Report Template to your server and export it to Excel.


Hi Rafik,

Thanks for your response. Would you happen to know in which table(s) of the data warehouse these floating license data stored? Customer wants to find out so they can fetch the data with their own script to produce the report base on their need.

Susan
0
permanent link
Rafik Jaouani (5.0k●1●6) | answered Mar 09 '10, 9:17 a.m.
JAZZ DEVELOPER
Data is stored in tables REPOSITORY_SNAPSHOT.INTEGRAL_RANGE

and REPOSITORY_SNAPSHOT.SCALAR

Look for rows where GROUP is:

'Floating license concurrent use'
'Floating license denials'
'Floating license checkout time'

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.