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

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

Questions
Tags
Users
Badges
Cameron McKay
(57●10●21) 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.

0 votes

1 answer
5,560 views
0 votes

One answer

Permanent link
Kenji Sarai
(960●3●9) 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

0 votes

Comments
Cameron McKay
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
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 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.

Ask a question
Guidelines
FAQ
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
× 485
× 82
× 26

Question asked: Jan 26 '17, 11:22 a.m.

Question was seen: 5,560 times

Last updated: Jan 30 '17, 4:25 a.m.

Confirmation Cancel Confirm