It's all about the answers!

Ask a question

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


Cameron McKay (571021) | 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



permanent link
Kenji Sarai (96029) | 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.