Database tables to query Jazz Team Server Floating and Token License Counts
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
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
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.
You might need to login RFE Community to view the content. Login RFE community (https://www.ibm.com/developerworks/rfe/) and search ID = 84361.