What field will tell me when a template was last used? | Community
Skip to main content
PHaywood831
PHaywood831
Level 2
December 26, 2024
Solved

What field will tell me when a template was last used?

  • December 26, 2024
  • 2 replies
  • 695 views

Hello - I'm pulling a template report to audit the use of our templates. I have the right filter to see the templates, but am wondering what field can tell me when they were last used? Maybe there isn't one? Maybe I need to run a project report for the last year and see what templates were used instead? Thanks in advance for any suggestions - and happy holidays.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Madalyn_Destafney

    Hi there, I like to do this template report to get straight to the point - what templates were NOT used in any project in the past year? Create a template report, add in any filters you want like if you're only targeting templates with specific portfolio/program, then change to text mode and add this: 
    EXISTS:A:$$EXISTSMOD=NOTEXISTS
    EXISTS:A:$$OBJCODE=PROJ
    EXISTS:A:entryDate=$$TODAY-1y [if you want a different timeframe put that here, this is past year]
    EXISTS:A:entryDate_Mod=between
    EXISTS:A:entryDate_Range=$$TODAY
    EXISTS:A:templateID=FIELD:ID

    2 replies

    Madalyn_Destafney
    Community Advisor
    Madalyn_DestafneyCommunity AdvisorAccepted solution
    Community Advisor
    December 26, 2024

    Hi there, I like to do this template report to get straight to the point - what templates were NOT used in any project in the past year? Create a template report, add in any filters you want like if you're only targeting templates with specific portfolio/program, then change to text mode and add this: 
    EXISTS:A:$$EXISTSMOD=NOTEXISTS
    EXISTS:A:$$OBJCODE=PROJ
    EXISTS:A:entryDate=$$TODAY-1y [if you want a different timeframe put that here, this is past year]
    EXISTS:A:entryDate_Mod=between
    EXISTS:A:entryDate_Range=$$TODAY
    EXISTS:A:templateID=FIELD:ID

    If this helped you, please mark correct to help others : )
    PHaywood831
    PHaywood831Author
    Level 2
    December 27, 2024

    Thanks @madalyn_destafney ! - I was able to pull a basic template report for a specific group to see how many total templates they owned. I used this report to see the reports not used in the last year, and another report provided by @skyehansen below to see the reports the group used in the last year. Seeing both reports against the total report gives me confidence they are correct as the two add to the total. Have a happy new year!

    skyehansen
    Community Advisor and Adobe Champion
    skyehansenCommunity Advisor and Adobe Champion
    December 26, 2024

    One of the advisors has published a number of useful filters here:

    https://experienceleaguecommunities.adobe.com/t5/workfront-discussions/for-those-trying-to-clean-up-their-templates-i-have-some-goodies/m-p/547158#M84

     

    The critical thing to keep in mind is whether or not there's a template being attached as a secondary template. These will never come up in reporting using the conventional template reporting, and it's discussed in the discussion commentary.

    PHaywood831
    PHaywood831Author
    Level 2
    December 27, 2024

    Thanks @skyehansen - see above comments - your reply is also correct, but I can't seem to mark both replies as correct. 

    Terms & ConditionsAccessibility statement

    Loading footer...