| Mei Ying 2004-05-20, 2:43 am |
| Hi
The supported way of getting the information you want is
to scan through each and every placeholder for hyperlinks
to files. You will find them in the format: /some
guid/some number/file name.
e.g. http://km.vic/NR/rdonlyres/0C04D36D-01C6-4FF8-B75B-
DC6538FB05C9/0/mydoc.gif
Extract the guid and use Searches.GetByGuid and cast the
returned object as a Resource to retrieve it. If it
returns null, it's a Resource. Otherwise its a local
attachment.
To differentiate between images and regular attachments,
check the file extension.
A script that recursively walks through each placeholder
with a regular expression should do the job for you. The
same script can be programmed to tell which postings
contain the link to the file in question (somewhat like a
dependancy report). At the same time, you can perform the
upload to the Resource Gallery and amend the link
accordingly.
SQL queries are not supported. Of course if you knew how
to do it, no one can stop you.
Hope this helps,
Mei Ying
>-----Original Message-----
>After out December 2003 implementation of MCSM 2002, we
are attempting
>a clean up of our site. We would like to enforce the
requirement of
>images having to be accessed from the Resource Gallery.
In order to do
>this, we need to determine what images are currently
accessed through
>the Resource Gallery, and which ones were loaded locally.
We have been
>attempting to extract this information from the SQL
database, but have
>not been able to determine a unique key to search on to
produce this
>kind of list. Does anyone kow of any existing reports or
any SQL
>select statements that might provide us with this
information?
>.
>
|