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.
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 !!!
Thank you for your suggestions. Your suggestions helped me to fetch needed report from the database.
In Reply to Mike Lockwood:
This info is available here (pulls from auditrecord table):
Provided configAudit.xml is configured (as it is OTB) with “login” - true