It's all about the answers!

Ask a question

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

Cameron McKay (57521) | asked Jan 26 '17, 11:22 a.m.


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.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.

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 ( and search ID = 84361.

Your answer

Register or to post your answer.