Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X
Hello,
Which criteria should I select to see who are the active users in a report?
Thanks,
Craig
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 robert.sindelar@eccellent.com if you have any other questions.
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
com.ptc/Monitors/ActiveUsers/Attributes/ActiveUsers
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
com.ptc/Monitors/ActiveUsers/Attributes/ActiveUserCount
The number of active users is shown in the value column
Thanks
Hello Craig,
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)
SELECT
A0.userName C1C0,
TO_CHAR(MAX(A0.createStampA2),
'dd mm yyyy hh24:mi:ss') C1C1,
MAX(A0.createStampA2) TS_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).
Thank you,
Binesh Kumar
Barry Wehmiler
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).
Hi Criag,
Were you able to get a report using the method suggested by Binesh. If so, could you please mark the answer as correct .
Regards,
Bhushan
Nehe,
I got the report but it shows some users haven't logged in a while and they logged in yesterday.
Thanks,
Craig