Skip to main content
J
jjames-21-Visitor
1-Visitor
October 13, 2017
Question

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

  • October 13, 2017
  • 2 replies
  • 2466 views

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.  

2 replies

A
Arshad17-Peridot
17-Peridot
October 14, 2017

Hi 

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

J
jjames-21-VisitorAuthor
1-Visitor
October 14, 2017

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.

B
bcedar1-Visitor
1-Visitor
October 30, 2017

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

J
jjames-21-VisitorAuthor
1-Visitor
October 31, 2017

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

Terms & ConditionsAccessibility statement