cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

Fetch idle PDMLink Users' list

pmuthuramalinga
1-Newbie

Fetch idle PDMLink Users' list

I am required to fetch users' list who have not logged in to PDMLink system for 90 days. Will it be possible to fetch such report? If yes, please let me know the steps to fetch this report.


Thanks


M Pavundoss

9 REPLIES 9

Not sure of the how, but there is no direct report available.

You will need to get a list of who has logged in and compare it to a list of all users.


You could parse the data from the PTC Windchill Usage tool.

When user login to Windchill login event is generated and OOTB that is stored in windchill DB. you can query on Windchill DB to get list of user who have not logged.
PFA attached sample QML/Report for getting list of user who have not logged in since 30 days. you can modify criteria as per requirment.




Hope this helps !!!



Thanks
Shreyas

You can have a look in the Oracle tables to find a users last login date:


select max(auditrecord.createstampa2) as LASTLOGINDATE
from auditrecord, wtuser where auditrecord.idb5 = wtuser.ida2a2 and wtuser.name = ‘ab1234’;



Jim Van Dragt
PLM Architect
Information Technology

hermanmiller.com

This info is available here (pulls from auditrecord table):

[cid:image005.png@01CF270A.38AE58A0]

[cid:image006.png@01CF270A.38AE58A0]

Provided configAudit.xml is configured (as it is OTB) with “login” - true

Thank you for your suggestions. Your suggestions helped me to fetch needed report from the database.


Thanks


M Pavundoss

In Reply to Mike Lockwood:


This info is available here (pulls from auditrecord table):

[cid:image005.png@01CF270A.38AE58A0]

[cid:image006.png@01CF270A.38AE58A0]

Provided configAudit.xml is configured (as it is OTB) with “login” - true

From a few years ago (January 2012):



That query appears to find all logins for all users during the time
specified. In my case, to search over the last 90 days the report was 20k+
events. Is there a way to reduce it to remove duplicates?
Thanks,
Pete


Probably this UI cannot - it runs a query without "latest" (SQL maximum). Not well-structured or scalable.
Likely have to use the direct database query suggested by others - or similar in a query builder report also suggested by others. We use a direct database query.
Top Tags