How long did the most recent refresh take?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Law

Q&A for legal professionals, students, and others with experience or interest in law

SELECT database_name, 
       site_name,
       made_available,
       processing_time,
       CASE row_number() OVER (ORDER BY made_available) 
         WHEN 1 THEN 
           DATEDIFF
           (
             MINUTE,
             MIN(initialized) OVER(),
             MAX(made_available) OVER()
           )
         END AS total_process_in_minutes
FROM sede_databases
ORDER BY made_available;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results