In the operations around Sitecore.net we often get contacted by someone who has a problem with a link. Recent example of that is when we started to enable the CSRF-extensions for Sitecore 6.6(Update-3). All kinds of redirect problems were caught, but how to figure out to which exact mailing they are related?
Don’t worry, that’s easy… As long as you have database access…
So let’s assume we have the following link:
The steps to get to the Campaign:
- Take the ec_as-query string parameter
- Execute the following script to the database. Where @guid is your ec_as-parameter
DECLARE @guid VARCHAR(50)
SET @guid = ‘00000000000000000000000000000000’
WHERE [AutomationStateId] = CAST(
SUBSTRING(@guid, 1, 8) + ‘-‘ + SUBSTRING(@guid, 9, 4) + ‘-‘ + SUBSTRING(@guid, 13, 4) + ‘-‘ +
SUBSTRING(@guid, 17, 4) + ‘-‘ + SUBSTRING(@guid, 21, 12)
- Now you have the AutomationId which is the same as your Automation Plan in the back-end. You can simply search for the Item in the Content Editor.
- Once you’ve found this item, you can got to the Navigate Tab –> Links –> Referrers –> All campaigns that use this automation
So basically what have we done? We used the Automation State to get back to the original Campaign. Sounds easy doesn’t it ?