Ella, Are you talking about looking for Rendition X, where the URI for the
file is no longer valid (the path changed, the filename changed, or the
file was deleted)?

I have been able to do this with a PHP based spider in the past. But if you
are using TMS 2014+, you can use the "Media Module > Maintenance > Image
Metadata" option to refresh the cached metadata. The Error Log should be
able to tell you which files it couldn't extract metadata from - which
would be the result of broken links.

On Mon, May 23, 2016 at 4:38 PM, Smith, Jeffrey <[log in to unmask]> wrote:

> Ella,
>
>
>
> Try this one:
>
>
>
> use yourdatasource
>
> select mr.renditionnumber
>
> from mediamaster mm inner join mediarenditions mr on mm.mediamasterid = mr
> .mediamasterid
>
> where mm.mediamasterid not in
>
>  (select mediamasterid
>
> from mediaxrefs)
>
>
>
> And yes, we have some orphaned media records laying around!
>
>
>
> *From:* The Museum System (TMS) Users [mailto:[log in to unmask]]
> *On Behalf Of *Ella Rothgangel
> *Sent:* Monday, May 23, 2016 4:28 PM
> *To:* [log in to unmask]
> *Subject:* broken media links
>
>
>
> Has anyone figured out a view, script, report, or query to see only media
> records where the link has been broken?
>
>
>
>
>
> Ella Rothgangel
>
> Acting Head of Registration
>
> Saint Louis Art Museum
>
> 314.655.5408
>
>
>
> To unsubscribe, send an email to [log in to unmask] with the
> following commands in the body of the email:
>
> signoff TMSUSERS
>
> // eoj
>
> You will receive a confirmation that your subscription has been removed.
> To unsubscribe, send an email to [log in to unmask] with the
> following commands in the body of the email:
>
> signoff TMSUSERS
>
> // eoj
>
> You will receive a confirmation that your subscription has been removed.
>

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.