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

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

permanent link

Kenji Sarai (960●2●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 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.

It's all about the answers!

Related questions

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

One answer

Your answer