Seeing who and when someone deactivated a campaign | Community
Skip to main content
TimothyBr
TimothyBr
Level 4
October 4, 2021
Question

Seeing who and when someone deactivated a campaign

  • October 4, 2021
  • 2 replies
  • 608 views

Hello all!

We are trying to run a report or really anything to help show who may have deactivated a program. We have a lot of people deactivated programs by accident, and then activating them again which is great they are aware they made a problem, but when they do this it throws off a lot of our reports. So, we are trying to capture some type of audit on this, so we know who to train more.

Thanks in advance!

Tim

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

2 replies

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
October 4, 2021

Hi Tim,

Assuming the act of deactivating triggered the Last Update on such a Program, I'd expect the Last Updated By to then contain the name of the person who performed the deactivation.

If that smoking gun is to tenuous, another approach would be to set up Targeted Auditing to effectively build a mini-history that tracks every such Activation / Deactivation.

Regards,

Doug

    M
    ManishSi1
    October 19, 2021

    Hello Doug,

    Thanks for sharing this amazing logic. It works perfectly fine when I use Target/Target History setup. In my snip it says Status/Status History.

    I tweaked it a bit to use "Is Active" to track program's active/deactivated status and date. But it works only twice. When I try to activate/deactivate the program third time, the loop stops working. Is there anything wrong with the calculation I used?

    Calculation for Status History II:

    LEFT(IF(LEFT(Status History II,LEN(IF(ISBLANK(Is Active),"-",Is Active)))=Is Active,Status History II,CONCAT(IF(ISBLANK(Is Active),"-",Is Active)," (",$$NOW,") | ",Status History II)),2000)

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    November 15, 2021

    Hi Manish,

    That's curious. Your formula appears to be correct to me, so perhaps it is related to the Is Active state of the Program -- more specifically, Workfront might not allow such calculations on (e.g. Status History II) on an object (e.g. Program) that is not Active, choosing (e.g. As Designed) to instead "leave everything alone". I'd suggest you do some testing to confirm, and/or contact support, who might be able to explain their reasoning (or a workaround).

    Regards,

    Doug

    Terms & ConditionsAccessibility statement

    Loading footer...