windchill 10.2 qml report (users who haven't logged in within 90 days)

[jjames-2]

Hi folks,

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.  

[Arshad]

Hi 

See if the qml from this article helps https://www.ptc.com/en/support/article?n=CS220318

[jjames-2]

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.

[bcedar]

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))

[jjames-2]

can you provide a screen shot of what this looks like in the UI?