how to track User's previous access Level information

[SmithaL1]

Hi team,

Iam creating a user decision report where i would like to know when did user move from Contributor to Light like the License modified date . Can any one help me with the expression to find this out ?

Thanks in advance!

[Sven-iX · Accepted solution]

Far as i know Workfront doesn't track the date a license changed. 

But you can use a JOURNAL report i think. Something like this? 

[SmithaL1]

Thank you, i shall try

[Sven-iX]

Some tips

Report filter

column current access level

valueexpression=If(isblank({user}.{accessLevel}.{name}),"No access", {user}.{accessLevel}.{name})
valueformat=HTML
linkedname=user
namekey=view.relatedcolumn
displayname=Current Access Level
namekeyargkey.0=user
namekeyargkey.1=accessLevel:name
querysort=user:accessLevel:name

Column Updated from

valueexpression=If(isblank({aux2}),"No access", {aux2})
valueformat=HTML
linkedname=direct
namekey=aux2
displayname=Updated from
querysort=aux2

Column Updated to

valueexpression=If(isblank({aux1}),"No access", {aux1})
valueformat=HTML
linkedname=direct
namekey=aux1
displayname=Updated to
querysort=aux1