There are a few ways you can accomplish this depending on your definition of "active":
My company is very experienced in all things WC, including configuration management (which includes reporting). Feel free to reach out to me at email@example.com if you have any other questions.
I use the below query to find out the users, who did not login in the last 90 days (which some companies term as inactive users)
'dd mm yyyy hh24:mi:ss') C1C1,
FROM AuditRecord A0
WHERE (((A0.eventLabel = 'Login') AND (A0.createStampA2 <= (SYSDATE)-(90))))
GROUP BY A0.userName
ORDER BY TS_C1C1 DESC;
A lot of useful information on this has been mentioned by Mike Lockwood , Ben Perry and Lori Sood in Re: DOES ANYONE KNOWS QUERY TO CHECK LAST LOGIN OF A USER(INACTIVE).
Reminder - the auditrecord table only has this info if you have configAudit.xml configured to include the "login" event.
Can get to same from Site, Util.
Can also create a quick and easy query builder report for same that can be provided to all users, either within Windchill or as an external link.
note: OTB, configAudit.xml has enabled only 3 events: Login, Logout (which never made sense to me) and "container_login" (access to a context).
Were you able to get a report using the method suggested by Binesh. If so, could you please mark the answer as correct .
Hi there, I've used the JMConsole MBeans method to access a list of active users and this is a good option but do you know how this can be achieved via a command at the Linux commandline?
Just in case anyone wants the path for the mbeans, browse to
Active User List
Double click the java.lang.string[n] in the value column to see the list of users who are currently logged on
Active User Count
The number of active users is shown in the value column