Guest
|
Posted:
Tue Nov 01, 2005 9:51 pm Post subject:
Creating resource dependency report |
|
|
After looking through this group, and around the Web, I found Stefan's
command line tool for creating a resource dependency report. That is
great for getting a full report of the site's resources. However, I
would like to give our editors/admins the ability to get a report for a
single resource.
With the API, I can present the user with a list of resources. The
idea is for the user to select a resource, and then I'll display a list
of postings that contain that resource. Given a resource's GUID, does
anyone have a SELECT statement against the actual CMS tables that would
retrieve either the GUIDs of postings containing that resource or more
preferable, the Display Path/Name and URL of those postings?
Thanks,
Carole |
|
Stefan [MSFT]
Guest
|
Posted:
Mon Nov 07, 2005 5:50 pm Post subject:
Re: Creating resource dependency report |
|
|
Hi Carole,
please send me a mail to webmaster@stefan-gossner.de and I will send you
something.
Cheers,
Stefan
--
This posting is provided "AS IS" with no warranties, and confers no rights
New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
----------------------
<elora_c@yahoo.com> wrote in message
news:1130876393.638786.88410@g49g2000cwa.googlegroups.com...
| Quote: | After looking through this group, and around the Web, I found Stefan's
command line tool for creating a resource dependency report. That is
great for getting a full report of the site's resources. However, I
would like to give our editors/admins the ability to get a report for a
single resource.
With the API, I can present the user with a list of resources. The
idea is for the user to select a resource, and then I'll display a list
of postings that contain that resource. Given a resource's GUID, does
anyone have a SELECT statement against the actual CMS tables that would
retrieve either the GUIDs of postings containing that resource or more
preferable, the Display Path/Name and URL of those postings?
Thanks,
Carole
|
|
|