5

In Tridion 2009, is there any way to find all the publishing history for a page for a specific period of time?

I tried to get this information from the Transactions table but it overrides the value every time the status is changed.

Is there any way to get this information from somewhere within the standard Tridion architecture (like the CM Database?) I guess it is not possible to get from the queue as that points to the Transactions table.

3

As far as I know, this information is not available anywhere in Tridion. Only the most recent publish/unpublish information is stored in Tridion.

  • Thanks for your clear input, as new implementation in event system is not possible as of now in our case. – Anupam Baksi Sep 18 '13 at 9:21
7

You are right, the Publishing Queue only stores the most recent publish action for an item. The best way to get this information is to capture it in a custom database using the Event System. You can implement an event with the following signature:

EventSystem.SubscribeAsync<RepositoryLocalObject, SetPublishStateEventArgs>
  (ItemFinishedPublishing, EventPhases.TransactionCommitted);

..and implement your delegate method: ItemFinishedPublishing to capture whatever information you require.

Note that this event is triggered only after successful publish/unpublish of an individual item (Page, Component, Taxonomy). If you want to have information about the whole publish transaction, you will need to investigate the following event signature:

EventSystem.SubscribeAsync<PublishTransaction, SaveEventArgs>
  (TransactionSaved, EventPhases.TransactionCommitted);

Note that this event is triggered multiple times per transaction, as it goes through all the states (Queued for Publishing, Waiting for Transport, Deploying etc.), so you probably only want to log stuff for the end states; Success, Warning, Failure.

  • We may go for this suggestion in future, as of now its not possible in pour case. But, many thanks for your detailed explanation on this. – Anupam Baksi Sep 18 '13 at 9:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.