We use Tridion 2011 serve the same site to 19 different country publications. We are upgrading to 2013 and need to be able to replicate what assets of all types are live in each given target+publication combination, and I'm trying to help with detective work on the matter. I am a front end developer who's just barely knowledgable enough to be dangerous in Tridion.

My assumption is that the way to do it would be:

1. Create a custom page with a means to select a target and a publication. Given that all of these are known, I'm fine with the short term hardcoding of these in order to get the work done faster.
2. On submitting the form, iterate through components and pages and inspect each one to see if it is published to the specified target.

I have no idea how to do any of that, but the ingredients seem to be scattered amongst several questions. It seems to me like #2 would be terribly expensive and take ages. So I would think that breaking it up into steps would be better, but can't think of a good way to do so.

Also, I would wonder if there is a simpler way to access what is published to a target by querying the target for items published to it rather than inspecting each individual item to see if it is published to the target.

All I really need (by my inexperienced thinking) is the CMS path to each asset and its tcm id, e.g. "US-WEB/Root/legal/doodad.aspx tcm:99-1234-64" or "US-WEB/Building Blocks/Content/PressReleases/superduper tcm:99-109876"

So, what's the best way to do this that won't bog down our system for ages and give us reliable results (bonus points if theres a way to do it that can be done safely by someone who probably shouldn't be doing it in the first place.)

Thanks in advance!

We use Tridion 2011 serve the same site to 19 different country publications. We are upgrading to 2013 and need to be able to replicate what assets of all types are live in each given target + publication combination, and I'm trying to help with detective work on the matter. I am a front end developer who's just barely knowledgable enough to be dangerous in Tridion.

My assumption is that the way to do it would be:

1. Create a custom page with a means to select a target and a publication. Given that all of these are known, I'm fine with the short term hardcoding of these in order to get the work done faster.
2. On submitting the form, iterate through components and pages and inspect each one to see if it is published to the specified target.

I have no idea how to do any of that, but the ingredients seem to be scattered amongst several questions. It seems to me like #2 would be terribly expensive and take ages. So I would think that breaking it up into steps would be better, but can't think of a good way to do so.

Also, I would wonder if there is a simpler way to access what is published to a target by querying the target for items published to it rather than inspecting each individual item to see if it is published to the target.

All I really need (by my inexperienced thinking) is the CMS path to each asset and its tcm id, e.g. "US-WEB/Root/legal/doodad.aspx tcm:99-1234-64" or "US-WEB/Building Blocks/Content/PressReleases/superduper tcm:99-109876"

So, what's the best way to do this that won't bog down our system for ages and give us reliable results (bonus points if theres a way to do it that can be done safely by someone who probably shouldn't be doing it in the first place.)

Thanks in advance!