Last Refresh of Environment

Sometimes you'll need to known when an environment was last refreshed and may not have the details of this. One way to approximate this using the PeopleTools tables is to look at the process request table.

Specifically you can use a query like this to check the first process that was run:

select * from PSPRCSRQST 
where DBNAME = '{your database}'  
order by RUNDTTM asc;

It may only be an approximation as it relies on at least one process running after the refresh (typically a system process) which may or may not have happened on the same day as the refresh. Even so it, gives you a timeframe to work with.

No Comments
Back to top