It's all about the answers!

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

×4,712
×481
×182
×82
×40
×25
×1

question asked: Jan 26 '17, 11:22 a.m.
question was seen: 2,606 times
last updated: Jan 30 '17, 4:25 a.m.

Related questions

Database tables to query Jazz Team Server Floating and Token License Counts

0
Cameron McKay (57●10●21) | asked Jan 26 '17, 11:22 a.m.

Hello,


I would like to create a custom report that queries a table in the Jazz Team Server database to retrieve floating and token license counts.  I don't know which tables to query in the database, so I am hoping that someone can provide some guidance.

I am using Jazz Team Server 6.0.1 with the following products installed, DW, CCM, RM, QM, LQE, GC and LDX.

Cheers, Cam.

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Kenji Sarai (960●3●9) | answered Jan 26 '17, 9:28 p.m.
edited Jan 26 '17, 9:37 p.m.

Hi Cam,

Assuming you are using data warehouse (DW) for reporting, the following tables have floating license statistics.

RICALM.INTEGRAL_RANGE_COUNTER 
RICALM.RANGE_COUNTER 
RICALM.SCALAR_COUNTER
RICALM.GROUP_NAME_FACET (which has the name  of the GROUP_NAME_FACET_ID column in the above tables)

However it is a bit challenging to sort out the data in these tables in JRS, BIRT, or Cognos. There is an ongoing RFE.
https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=84361

Comments
Cameron McKay commented Jan 27 '17, 9:58 a.m.

Hey Kenji,


Thanks for the information.  The link you provided appears to be broken.  I'm going to examine the data in those tables and see if I can create a report!

Cheers, Cam.

Kenji Sarai commented Jan 30 '17, 4:25 a.m.

You might need to login RFE Community to view the content. Login RFE community (https://www.ibm.com/developerworks/rfe/) and search ID = 84361.

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.