If you assign accessions to locations, but move them around to a final home after processing, it may be helpful to see where your accessions were assigned and when the record was last touched. This query will help you do a little clean-up:
Accessions ON Accessions.accessionId = AccessionsLocations.accessionId
LocationsTable ON AccessionsLocations.locationId = LocationsTable.locationId
Here’s an example of some output. We may check, for instance, accessions from before 2015 to make sure that the accession location is still relevant. I hope this is useful to someone else!
|Title||Accn||Date last modified||loc||accnID||locID|
|Yale Guidance Nursery yearly reports||2010||A||085||2010-06-22 12:18:55||SML||XXX||X||7077||1933|
|Margenau, Henry, papers||2010||M||053||2010-11-16 15:51:37||SML||XXX||X||7078||1940|