Hi Byron,
While this is technically possible, the SQL Server’s service account likely does not have sufficient permissions to access the media folders and files.
This webpage has some good info, though I wouldn’t add any columns to TMS tables.
Best,
David
From: The Museum System (TMS) Users <[log in to unmask]>
On Behalf Of Pillow, Byron T
Sent: Tuesday, December 4, 2018 9:51 AM
To: [log in to unmask]
Subject: Query Media Records for Missing Files
Hello all,
Is it possible to run a query on media records that will return instances where a media file no longer exists at its specified path?
Kindest thanks!
Byron
BYRON PILLOW
Associate Curator
National Music Museum • www.nmmusd.org
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.