Windchill Active Users

There are a few ways you can accomplish this depending on your definition of "active":

1. If "active" means how much data has been touched by a user, you could create QueryBuilder reports for your key object types and search on "created by" field either for a specific user or in general.
2. You could do option 1 and limit to the last month or so to get a picture or "recently active" users.
3. From the server itself you could use DB queries to put counts of objects against users and rank their level of activity that way.
4. Or, if "active" simply means who is currently logged in, there is an MBean you can launch with JConsole to give you the count and list of users logged in at that time.  Run periodically, say every 30 min over a week, would give some good raw data to produce a WC usage report.

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.

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