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

Export reports from counter page

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

1 vote



3 answers

Permanent link
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 votes


Permanent link
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 votes


Permanent link
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'

0 votes

Your answer

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.

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

Question asked: Mar 03 '10, 12:23 p.m.

Question was seen: 6,891 times

Last updated: Mar 03 '10, 12:23 p.m.

Confirmation Cancel Confirm