I never set up the alert, so I have nothing to export and share, but I did do a little bit of sql in that direction. This is pending moves 2 weeks out by system user, so it’s looking only for the moves scheduled by the current logged in user. This may not be what you want, but maybe it gives you a starting place? I scanned it and it looks like it’s not dependent on any views particular to PMA, so you might be able to plug and play. If you do create an alert, or if anyone else does so, I would definitely like to see the results! --Jessica select distinct c.componentnumber ,convert(varchar(10),ol.transdate,121) as PendingDate, case when l.[External]=0 then substring(l.LocationString,charindex(', ',l.locationstring,1)+2,LEN(l.locationstring)) else l.LocationString end as MoveToLocation , ol.requestedby from objlocations as ol inner join locations as l on ol.locationid = l.locationid left outer join objcomponents as c on c.componentid = ol.componentid inner join objects as o on c.objectid = o.objectid where ol.transstatusid = 0 and datediff(week,getdate(),convert(datetime,ol.transdate,121)) between 0 and 2 and (ol.transcodeid > 7 and ol.transcodeid < 10) and ol.loginid = ( select top 5 substring(system_user, charindex('\',system_user)+1 , len(system_user)) as [login]) order by pendingdate, movetolocation, c.componentnumber Jessica Milby Assistant Director for Collection Information t 215-684-7283 f 215-235-0035 Philadelphia Museum of Art PO Box 7646, Philadelphia, PA 19101-7646 www.philamuseum.org From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Kimberly Koons Sent: Thursday, November 12, 2015 9:49 AM To: [log in to unmask] Subject: alert for scheduled moves Listserv - Change of strategy on my recent query searching for an alert on exhibit rotations (no response). Since this will likely need to be object-by-object, it seems scheduled moves would be a better way to go at this. Anyone have an alert out there that lets you know x days ahead of a scheduled move? -- Kimberly Koons, Presidential Libraries Museum Collections Officer National Archives & Records Administration 700 Pennsylvania Ave., NW Washington, D.C. 20408 202-357-5082 301-837-0873 To unsubscribe, send an email to [log in to unmask]<mailto:[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.