Can we get the publishing history of a Tridion component?

Question

We have an issue with a component in which in-appropriate content was published and then unpublished.

From the publishing queue we were able to get only the last publish transaction of that component.

Is there any way to retrieve the complete publishing history of that component?

Would like to know who and when was this published and how many times it was published and unpublished.

Also ,our normal modification history was deleted to find out the modifications.

Please let us know a way to figure this out.

Thanks,

Sampath

Answer 1

There is not a way, out of the box, to see all publish history. By default only the last published date is available.

You could trawl the deployer log files for the publish transaction, but that would not tell you who published it.

If you require this functionality / audit trail, you would have to implement Tridion Events system and record each publish to a database or log file. You could then run reports on this to determine the required information.

Answer 2

For the record, this is an unsupported low level way to get a list of published transactions (user name, publish time, publication target, path of the page, ) for any given item

select top 1000 t.name, pt.publish_time, pta.TITLE, pt.source_item_path 
from publish_transactions pt, trustees t, publication_targets pta
where pt.SOURCE_ITEM_REFERENCE_ID = 7386 and pt.trustee_id=t.id and pt.PUBLICATION_TARGET_ID=pta.ID