[SalesForce] Obtaining sandbox refresh date

I've investigated and found two articles with no answer for this question:

It's been a while, so maybe something could have changed, so raising this question again. I am wondering if there's a way to query Salesforce to get the date of a sandbox refresh. The only thing I've found that comes close is through using this query:

Select createddate from SetupAuditTrail order by createddate asc limit 1

I am wondering if this is still the only viable solution.

Best Answer

If you log into your production org and navigate to Setup > Deploy > Sandboxes, you can see the Completed On value for each sandbox in the list view. This field tells you when the refresh completed.

You can also click on an individual record and see this field and other details. The full detail would look something like:

             Sandbox Name    Demo Full Sandbox
              Description    Some Description
          Sandbox License    Full
                   Status    Completed
                 Location    CS42
           Current Org Id    00D...
             Completed On    04/23/2019 5:10 PM
               Created By    Automated Process
             Created Date    01/01/2011 11:11 AM
  Last Refresh Request By    Some User
Last Refresh Request Date    04/23/2019 9:35 AM
Related Topic