Does anyone have a working QML report for Windchill 10.x that reports users who have not logged in within 90 days? I have a QML (found on this site) but it's returning false positive users.
See if the qml from this article helps https://www.ptc.com/en/support/article?n=CS220318
This is the qml i was refering to previously. This report shows me who's logged in the last 90 days. I want to see who has NOT logged in the last 90 days. If I switch the condition within this QML it reports false positives. meaning, I will see my last login that was ~90 days ago. Even though I also logged in yesterday.
You'll want to use the Audit Record Created date and take advantage of the Sub-Select criteria and Maximum function.
I want only the latest Log In... Criteria
Audit Record Created = (sub select, audit record where user and type is equal to the master report's audit record, and the select is the Maximum(sub select's audit record created))