What table contains contributor last login date?
I just searched through all the database tables trying to find one with the last login date for contributors and did not find it. Likely it has some other unusual name. Any ideas? There is a list of all the tables here:
http://jazzlab.net/jazz/?mid=notes&listStyle=webzine&document_srl=15204 I need to create a report showing the last login dates of all RTC users, so if there is some other way of getting that please let me know. |
Accepted answer
Someone on our DevOps team figured out how to get this info.
The script file, titled "list-rtc-logins": #!/usr/bin/env bash Ralph Schoon selected this answer as the correct answer
Comments 1
Nilesh Patil
commented Oct 25 '13, 12:22 a.m.
Hi Mike Shkolnik,
|
6 other answers
Hi Mike,
This script looks specific for tomcat. What are the required chANges in the case of the apps deployed on WAS with User registry on AD?
Thanks.
|
It is indeed for Tomcat. My DevOps person has opted not to recommend script changes for an environment we don't have and can't test and suggests that your scripting person should be able to make the necessary changes. Or perhaps someone else on the forum who is familiar with scripting can make and test the changes and post their results?
|
Hi Mike,
My query is related to the method to be adopted to retrieve the last login info - in case of RTC/JTS deployed on WAS instead of Tomcat. Because, I am unable to find the localhost_access_log file in the WAS paths
. This solution looks to be specific to Tomcat.
|
Sorry, our guy has no knowledge of WAS. Perhaps someone else here can help?
|
Hi Mike, We have RTC and JTS deployed on windows platform, which uses Apache Tomcat Application Server. Could you please guide us how to get this deployed to pull out the similar report. Comments
Mike Shkolnik
commented Nov 14 '13, 2:00 p.m.
I'm afraid I don't know much about unix scripting, so I don't know how it's implemented. I have written a "user management tool" which reads all the log files off a local drive (you need to copy them from the server first) and then spits out a report showing last login (as well as team allocations, work hours, and other activity). I will offer this up for use by others once I get licenses working. I have been able to figure out how to pull license type (such as Contributor, Developer, Stakeholder) from the API yet.
|
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.