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

Cameron McKay (57●5●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.

It's all about the answers!

Related questions

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

One answer

Your answer