Skip to main content
CA_1076744710-Marble
10-Marble
April 3, 2024
Solved

License Usage Report in Codebeamer

Is it possible to generate detailed License usage report to know full details of active users, logged in user, timings, location etc.

Karol_ArorianAnswer
12-Amethyst
April 3, 2024

Hi,

I'm not aware of such a functionality OOTB in codebeamer but there are two ways to get some of these informations.

  1. In System Admin -> Server Status Dashboard there is "Logged In Users & Licenses Info" chart which will show you just the numbers.
  2. To get details of session history you could use System Admin -> iSql functionality and type there an SQL query.

 

SELECT * FROM public.session_history
ORDER BY login_time DESC

 

The result is a raw data from database so it's not user-friendly but it can help you.
The result could be also exported to excel - there is a button below the results table.

View in thread

4 replies

Karol_Arorian12-AmethystAnswer
12-Amethyst
April 3, 2024

Hi,

I'm not aware of such a functionality OOTB in codebeamer but there are two ways to get some of these informations.

  1. In System Admin -> Server Status Dashboard there is "Logged In Users & Licenses Info" chart which will show you just the numbers.
  2. To get details of session history you could use System Admin -> iSql functionality and type there an SQL query.

 

SELECT * FROM public.session_history
ORDER BY login_time DESC

 

The result is a raw data from database so it's not user-friendly but it can help you.
The result could be also exported to excel - there is a button below the results table.

Translate
    CA_1076744710-MarbleAuthor
    10-Marble
    April 4, 2024

    Hi,

    This is very helpful.

    Is there any documentation where i can see the table names(e.g public.session_history) and column names?

    This can help me fetch the data directly from database.

     

    Translate
      Karol_Arorian12-Amethyst
      12-Amethyst
      April 4, 2024

      No, I'm not aware of any documentation.

      Translate
      Terms & ConditionsAccessibility statement