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

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

Participant

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

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.  

4 REPLIES 4

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

Hi 

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

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

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.

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

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

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

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

Announcements
LiveWorx Call For Papers Happening Now!