Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How to capture the last login date or last license acquired date for CLM?

How to capture the last login date or last license acquired date for CLM?

I would like to know what the DB table name with this information so I can extract it.
I could not find a way with the REST API or JAVA api to do this so a DB table is only way.

0 votes

Comments

It looks like the LICENSE_ASSIGNMENT table shows when there is a license taken and it has column called MODIFIED but the format does not look like a date: 1405377349240 .  Is this an encrypted date by any chance?

Also, this is needed to determine who hasn't been using the application and can be denied access after a certain period of time.



One answer

Permanent link
The floatingLicenseLogFile.csv is generated in the server/logs directory.
The data is the form of :
     | license_server_url | ref_id | checkout_time | timeout_time |
license_type | user  | product_usage | acquisition_type |

From this csv, to know the last license usage from a user,  you could
a.  Sort the user data by name using the excel function and look at each user's last entry.
b.  Pivot the usage details and create a table as well.

Regarding the time mentioned in the additional comment for the question for modified:
It is the time elapsed in milliseconds since Jan 01st, 1970 or what is in
other words called as the epoch time.
You could use an epoch converter to know the time the value corresponds to. 
One such converter is here : http://www.epochconverter.com/

The time mentioned in the comment "1405377349240" translates to "GMT: Mon, 14 Jul 2014 22:35:49 GMT".

With the understanding that the time shown against MODIFIED field is referencing epoch time, you could convert the 120 days ago date to the epoch time and use it with a query on LICENSE_ASSIGNMENT table.

below is a sample query :
    select * from REPOSITORY.LICENSE_ASSIGNMENT L where L.MODIFIED >
'2015-06-30 20:01:24.706';
where MODIFIED is compared against the minimum date (120 days ago) that you wish to filter users on.
With the above query, you get a list of users who made use of a license in the last 120 days.

Now, with another query you could get a list of all users and work out the list of users whom you want to deny access.

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,014
× 7,484

Question asked: Oct 16 '15, 4:42 p.m.

Question was seen: 4,149 times

Last updated: Oct 16 '15, 4:49 p.m.

Confirmation Cancel Confirm