T-Sql to Get the Database Restored Status

T-Sql to get the database restored status:

DECLARE @dbname SYSNAME
SET @dbname = 'ListSelect20'
SELECT Top 1
destination_database_name as 'Database Name',
[user_name] as 'Username',
CASE restore_type
WHEN NULL THEN 'NULL'
WHEN 'D' THEN 'Database'
WHEN 'F' THEN 'File'
WHEN 'G' THEN 'Filegroup'
WHEN 'I' THEN 'Differential'
WHEN 'L' THEN 'Log File'
WHEN 'V' THEN 'Verifyonly'
WHEN 'R' THEN 'Revert'
END as 'Restore Type',
Case [replace]
WHEN NULL THEN 'NULL'
WHEN 1 THEN 'YES'
WHEN 0 THEN 'NO'
END as 'Database Replaced',
restore_date as 'Date Restored'
,CASE WHEN CONVERT(VARCHAR(10), restore_date, 110) = CONVERT(VARCHAR(10), GETDATE(), 110) THEN 'Restored Today'
   WHEN CONVERT(VARCHAR(10), restore_date, 110) = CONVERT(VARCHAR(10), GETDATE()-1, 110) THEN 'Restored Yesterday'
 ELSE 'Restored Long Back: Needs immediate Restore' END AS RestoredDay
,CONVERT(VARCHAR(8), Restore_Date, 108) AS Restore_Time
FROM msdb..restorehistory
where destination_database_name = CASE
WHEN @dbname IS NOT NULL THEN @dbname 
ELSE destination_database_name END
order by restore_date desc

T-SQL Query to get the SQL Agent job exectuted date time and duration

T-SQL Query to get the SQL Agent job exectuted date time and duration

select job_name, run_datetime, run_duration
from
(
    select job_name, run_datetime,
        SUBSTRING(run_duration, 1, 2) + ':' + SUBSTRING(run_duration, 3, 2) + ':' +
        SUBSTRING(run_duration, 5, 2) AS run_duration
    from
    (
        select DISTINCT
            j.name as job_name,
            run_datetime = CONVERT(DATETIME, RTRIM(run_date)) + 
                (run_time * 9 + run_time % 10000 * 6 + run_time % 100 * 10) / 216e4,
            run_duration = RIGHT('000000' + CONVERT(varchar(6), run_duration), 6)
        from msdb..sysjobhistory h
        inner join msdb..sysjobs j
        on h.job_id = j.job_id
    ) t
) t
order by job_name, run_datetime